Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.

learn more… | top users | synonyms (1)

2
votes
1answer
1k views

Only a single WITH MOVE clause should be specified for any logical file name

I'm trying to do a copy database by scripting a backup and restore. I have the backup procedure working correctly but I keep getting the error Conflicting file relocations have been specified ...
6
votes
1answer
3k views

Backup a database with a huge number of tables

Is there a way to backup a PostgreSQL database with a huge number of tables? An attempt with pg_dump for a database of about 28000 tables resulted in the following error message: pg_dump: WARNING: ...
3
votes
1answer
396 views

Postgres Backup queries on AWS after reading Postgres docs

I am reading backup section of postgresql docs before heading over to create backup strategy on my EC2 instance. So there are 2 ways to do it. Create a dump using pg_dump. File level backup with ...
0
votes
2answers
1k views

How to run a cold backup with Linux/tar without shutting down MySQL slave?

I run the following before tar-ing up the data directory: STOP SLAVE; FLUSH TABLES WITH READ LOCK; FLUSH LOGS; However, tar will sometimes complain that the ibdata* and ib_logfiles* files are ...
3
votes
4answers
282 views

Does it make sense to use full recovery if the data and log files are on the same HD?

We have a database that was set up to use full recovery and my guess is that the reasoning was only to prevent data loss if a failure happened between full backups. We make daily full backups of the ...
4
votes
1answer
1k views

Retrieving data if control file is lost in oracle Database

Suppose if the databases control file is lost permanently (no backup). Can we retrieve the data from data file in Oracle database?
3
votes
2answers
459 views

Backup SQL DataBase to C$

Another simple SQL backup question from me.... I've got a SQL Server database running on SSMS 2008 and am trying to configure some backup jobs. I am now seemingly fine with backing up and restoring ...
6
votes
1answer
435 views

SQL Recover from .bak file with NOINIT

This will, hopefully, be a nice and quick question for someone out there. It continues from my previous question. I have a .BAK file that I'm trying to restore. The .BAK was created with the NOINIT ...
2
votes
2answers
8k views

SQL Server: Simple database restore with overwrite

What I'm trying to do is backup one of our production databases and restore them as our dev database (overwriting what's been there). That's how I back up: backup database [authfx] to disk = ...
7
votes
1answer
325 views

Error in SSMS when attempting to restore a database

We have over a dozen SQL servers, one of which hosts a couple of hundred sage databases, when i right-click on the Databases node in SSMS there is a long delay then i get the following error (and the ...
4
votes
1answer
12k views

Is there a backup operator role in Microsoft SQL Server 2008?

I have a Windows Server 2008 with Microsoft SQL Server 2008 and VERITAS NetBackup installed. Basically, this NetBackup requires a valid logon ID into the SQL Server that is powerful enough to do a ...
9
votes
2answers
21k views

SQL Server backup failing. Error: 3041, Severity: 16, State: 1

First of all, I'm very new at stackexchange, so please bear with me. I'm running a SQL Server 9.0.4060. My problem is: my SQL Server backup keeps failing on a lot of the databases. The Maintenance ...
2
votes
1answer
801 views

Restore database from individual datafile backups

I had a script that backs up all the individual datafiles like: RMAN> BACKUP AS COMPRESSED BACKUPSET DATAFILE 'datafile<1>.dbf' So i have backupsets of all the datafiles. I'm confused as ...
0
votes
2answers
998 views

Row level restore with Oracle Recovery Manager (RMAN)

We're approaching the end of 2012 and I still find myself relying on database exports to maintain the ability to do row level restore operations. While this is a proven method, it sure would be nice ...
2
votes
0answers
84 views

How to display differential backup date in SSMS Object Explorer Details

SQL Server Management Studio exposes the Object Explorer Details (selectable from the View menu option) and its context menu that allows adding fields to the default display. Full and Transaction Log ...
2
votes
1answer
821 views

PostgreSQL - How can I manage WAL archiving for different databases on a server?

I'd like to use WAL archiving for incremental backup of my database. But I have 2 databases on my server, and I can't afford the disc space for backup of both of them. So I only want to backup one of ...
6
votes
1answer
575 views

Backup to three drives suddenly slow

The situation: I have a 1.3 TB Database (SQL 2005) that I am currently backing up to 2 network shares on separate machines and on one local USB. (Don't ask why - long story involving a DBA that quit ...
10
votes
1answer
4k views

What's a good SQL Server backup schedule?

There seems to be a plethora of information regarding the process of setting up backup tasks, but not much information about the big-picture view of database backups. At least, it's hard to formulate ...
0
votes
1answer
1k views

Oracle XE: Transfer Database from Linux to Windows

our professor gave us a linux VM with a Oracle XE 11g Database. I want to transfer this Database to my Windows installation because I dont't want to boot up the VM for every exercise. Everything ...
5
votes
2answers
1k views

Can I Run Two Full Backups on SQL Server 2005 at the Same Time?

Running SQL Server Express 2005 here. We are creating several programs which run a backup on the database using Server Management Objects (SMO) mostly through C# (.NET). We have separate processes ...
2
votes
3answers
23k views

Taking a backup of a single table in the SQL Server

I know how to take a backup of a database in SQL Server and restore it. But how can I take a backup of a single table, and then restore it? Is it possible? I have a database with two different names ...
2
votes
2answers
80 views

How can I make this backup scheme more friendly for reporting?

Currently, we have around 50 remote servers, each with a production database. Each night, all 50 of these servers run a backup job and zips the backup. Each morning, a local server runs a job for each ...
3
votes
1answer
146 views

How do I back up On Premise Microsoft SQL Server 2008 to Azure cloud

I have a 50 GB hosted SQL Server database at SoftLayer. I want to do backups to cloud storage, as the SoftLayer managed SQL Server backups are ridiculously priced. Eventually we will totally move ...
3
votes
3answers
4k views

Sql Server 2008 R2: Simple recovery model with transaction log backups

I'm busy reviewing my SQL Maintenance plans and I'm a bit confused with the recovery model option on the databases, specifically related to point in time recovery. Here is my scenario: I have two ...
2
votes
2answers
20k views

How to take Oracle backup and restore?

I am coming from SQL Server background where SQL Server studio has a very easy way of taking database backup and then doing a restore. I have been using Oracle 11G express edition for past couple of ...
4
votes
1answer
4k views

Is Percona xtrabackup the right choice for my 500GB MySQL backup?

I have a MySQL db with 500GB, consisting mainly of Innodb tables, and one big (200GB) MyISAM table. My current backup strategy is copying the db files to an external harddrive. This causes a downtime ...
4
votes
2answers
2k views

Restore all applicable files in a backup device in T-SQL

I'm using SQL Server (2008 R2 in this case) and I am backing up my databases into backup devices (one per database). Every Sunday the device is overwritten with a new full backup, every night a ...
0
votes
2answers
2k views

Is it possible to use ExpressMaint with SQL Server 2012 (Express)?

When I try running ExpressMaint on a server with SQL Server 2012 installed, it fails with an error saying it cannot find the Microsoft.SqlServer.Smo libraries (SQL Management Objects). From what I've ...
2
votes
3answers
208 views

Why isn't the transaction log getting truncated when taking a full backup?

In full recovery model, if we take a full backup, the log file is not truncated. It is done when we take a transaction log backup. Any particular reason of why it is done this way?
2
votes
2answers
209 views

Software for backing up SQL Server databases [closed]

Since using the new version of Symantec, I've experienced lots of problems doing incremental backups of clients' SQL databases. Is Windows Server backup a good alternative to Symantec Backup Exec ...
3
votes
1answer
95 views

Necessary to use a checksum on a backup and not solely the 'verify backup' option?

If want to ensure the integrity of a backup, would it be a necessity to use a checksum on all of my backups and not just the 'verify backup' option?
4
votes
1answer
2k views

Does the Amazon RDS backup/snapshot service lock tables?

We have a database that is 100+GB. Most tables use the InnoDB engine. A regular dump takes 1-2 hours. If we moved to Amazon RDS, would this backup cause table locks? Does Amazon use a simple ...
2
votes
1answer
1k views

Postgresql WAL Archiving, How to do it properly?

Basically I have one (for now) mission critical postgresql database that I will need up to the minute recovery for, I've never implemented a working WAL archival before so I would like to know what is ...
0
votes
4answers
71 views

Copy my data from a existing db to a new db

I have a database which has my data's that I have been working for months. Now, I want to delete that db. What concern's me is that the data's that I have might come in handy in the future ...
4
votes
3answers
3k views

Set Backup Compression on SQL Server 2008R2 on by default

I can't seem to find the option to set the server property that will enable compression on SQL database backup to be ON by default, so I don't have to manually set it every time. Can anyone point me ...
2
votes
1answer
478 views

How do I ensure consistent MySQL backups?

How can we ensure MySQL backups are consistent when they are taken as full backups as well as incremental backups using binlogs? According to me, I record the COUNT(*) from random tables after ...
2
votes
1answer
2k views

How to schedule a weekly backup of a database only if it has been changed since last backup

I´m new to SQL Server administration. I´d like to create automatically backup database every Sunday night, but only if there was any change in previous week (if not, backup is unnecessary). Is there ...
6
votes
1answer
8k views

Microsoft SQL Server 2008 R2 backup error

I'm trying to do a simple backup to an external disk and getting this error: Backup failed for Server 'Server-name' Additional information: System.Data.SqlClient.SqlError: The media loaded ...
4
votes
2answers
378 views

SQL Server Transaction Log Initial Data Load

What is the standard process when initially populating a database with 5GB+ to avoid a large transaction log? From my understanding the log file would jump to a large size after the initial load and ...
2
votes
3answers
8k views

Copy PostgreSQL data from one PC to another

I am migrating my server application from the existing system to another system. Unfortunately, the existing system is also the database server. It has data stored. Is it possible to copy this data to ...
7
votes
1answer
1k views

SQL Server considerations when backing up / restoring a database that uses replication

In the event that I need to restore a database involved in replication, what considerations to I need to keep in mind? Do I need to keep backups of both the publisher and the subscriber? Can I ...
1
vote
1answer
3k views

Can we back up mysql databases by copying files?

I tried to reinstall mysql on my machine, but it keeps failing. Everytime it fails, it does this locking and that locking and future effort would fail again. Finally I decided to do truly clean ...
6
votes
1answer
2k views

How to create a SQL Server 2008 backup without logs with mirroring

How do I create a backup of a SQL Server 2008 in a mirrored setup without any logs? We need to do this so that when we restore our local development databases, we would have the most up to date ...
4
votes
1answer
1k views

Transaction Log Truncation with Copy Only

I have a database backup job set to use full backup with the Copy only option on once daily. The copy only is on because from what I have read that is the only way to backup a database that is ...
5
votes
3answers
2k views

On SQL Server Backup: Msg 3271, Level 16, State 1, Server Line 1 A nonrecoverable I/O error occurred on file

I am trying to back up a pretty big database and I keep getting this error: Msg 3271, Level 16, State 1, Server {Server Name}, Line 1 A nonrecoverable I/O error occurred on file "{Backup File ...
2
votes
1answer
419 views

Assertion failure from InnoDB while restoring using Innobackupex

I thought I would give back to all those people who help me when I have a problem. This might be something old, but I did not find it anywhere so here goes: We recently upgraded our production DBs ...
1
vote
1answer
184 views

Access denied Error in MySQL and Drupal

We are trying to deploy a Drupal application on our production server. We see this strange error Lost connection to MySQL server at ''Access denied root@ipaddres password(yes) after deploying. We ...
0
votes
1answer
628 views

New transactions during a Sybase “dump database” command

I have a Sybase 15.5 database which is backed up every night using the DUMP DATABASE command. The process takes about 30 minutes. What happens to the transactions that occur within those 30 minutes? ...
0
votes
1answer
3k views

Oracle big datafile restore fails using Netbackup (ORA-19511, ORA-27190)

I am restoring datafiles about 1000GB in size. I am using Netbackup as a backup server. After 2 hours reading Netbackup fails with the following error: 7/25/2012 3:27:50 PM - Error bpbrm(pid=1176) ...
6
votes
8answers
14k views

Taking backup of all the databases in SQL Server

I have a Microsoft SQL Server 2005 DB server. In the DB server, I have around 250 user databases. I have to take a back up of all these databases. Since, manually taking backup consumes lot of time, I ...