Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.
4
votes
1answer
454 views
Cannot restore Amazon RDS SQL Server database to given point-in-time using SQL Server Management Studio
I'm trying to restore one of my Amazon DRS SQL Server databases. Using SQL Server Management Studio, I can correct to my DRS instance using the master account I created when creating the database ...
2
votes
1answer
186 views
Which backup files are needed for a successful restore?
Considering the built-in 'Backup Database' script (backup.bat) that comes with a new installation of the Oracle Express 11g Edition, after finishing the script execution, what folders/files should be ...
4
votes
1answer
466 views
Appending backups while overwriting expired sets
I've been reading up on this, but the online documentation is a bit difficult to understand and seems awkwardly written. For example the INIT, NOINIT. One says it will try to overwrite everything. ...
3
votes
1answer
240 views
How can I restore SQL Server database to a custom location, if the backup file was renamed?
Suppose I have an SQL Server database called bubu and the respective backup file is bubu.bak.
If I want to restore it with the backing store in a custom location, I use the following T-SQL statement:
...
5
votes
2answers
2k views
How to delete a Backup from a backup set in SQL Server 2008 R2
The title pretty much sums it up. We are running out of space on our backup disks, and need to remove old backups out of the set. I can't seem to find any information on this.
3
votes
1answer
83 views
Backup and off-site restore setup
I've been reading a lot of threads about different backup options for MySQL and was hoping for some more insight so I can settle on one.
Our current situation is ~100 GB of InnoDB and MySAM data in ...
5
votes
2answers
263 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 ...
3
votes
1answer
223 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: ...
2
votes
1answer
155 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 ...
2
votes
1answer
99 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
1answer
169 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? ...
3
votes
4answers
147 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 backups.
We make daily full backups of the ...
5
votes
2answers
776 views
SQL Server backup, attach to BAK file?
I have a SQL Server database with a full text index. When I created the app that uses it, I made a backup of the database and I ship the .BAK file with the app. As part of the app install it does a ...
4
votes
1answer
139 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
159 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 ...
5
votes
1answer
188 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 ...
1
vote
1answer
263 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
110 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 ...
5
votes
2answers
2k 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 ...
0
votes
1answer
673 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 ...
2
votes
1answer
139 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 ...
1
vote
1answer
142 views
Failed to restore mysql database with zmanda
I want to setup a slave from my backup version of mysql using zmanda (it's a full backup).
I've followed this guide.
Result of mysql-zrm-reporter
backup_set backup_date ...
3
votes
1answer
53 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 ...
0
votes
2answers
232 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 ...
4
votes
2answers
195 views
Change Location of VALIDATE RECOVERY FILES work area
Is there a way to tell the VALIDATE RECOVERY FILES command to use a different location with more available disk space?
When I run the command in RMAN, it fails with the following error stack:
...
1
vote
1answer
2k views
Problem with View When Restoring a MySQL Backup
I have a database (InnoDB) with some tables, views and routines...
Periodically I do a backup using the command line:
mysqldump -u user -ppassword --routines db_name > backup.sql
But I have a ...
4
votes
1answer
558 views
What's the fastest way to replicate a MySQL database from one machine to another?
What's the fastest way to replicate a MySQL database from one machine to another? The two machines are connected via LAN. How to do it without mysqldump?
If using mysqldump, is the fastest way
$ ...
2
votes
0answers
58 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 ...
1
vote
1answer
251 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 ...
5
votes
3answers
7k views
How to restore multiple backups
I'm using ExpressMaint and Windows Scheduled Tasks to create weekly full and daily differential backups of some MS SQL Server 2008 R2 Express databases
Weekly fulls
expressmaint -S ...
5
votes
2answers
433 views
How to automatically stagger transaction log shipping to minimize bandwidth usage peaks?
The following question pertains to Microsoft SQL Server transactional log shipping (TLS).
We're using SQL Server 2008 R2 SP1, although the question is probably relevant for all recent editions.
...
0
votes
1answer
62 views
A failure in SQL Server backup job [closed]
The job was invoked by schedule 16 (WIN7DB01 UserDB Backups.Subplan_1). The last step to run was step 1 (Subplan_1). I could not understand what is the cause of this. Please help me.
6
votes
2answers
290 views
PostgreSQL PITR restore
I have a PostgreSQL 9.1 server running on a CentOS 5.8 32bit OS and I have enabled WAL archiving. On this server, there are three databases: databaseA, databaseB and databaseC. Someone deletes a ...
2
votes
3answers
667 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 ...
5
votes
1answer
398 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 ...
-1
votes
1answer
317 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 ...
2
votes
2answers
929 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
57 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
96 views
PostgreSQL synchronized commit performance
I'm setting up a pair of PostgreSQL servers. Because cash is short I can only afford one high class server and some crapy backup box. If the expensive high end box should catch fire, operations can ...
1
vote
2answers
692 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
281 views
Why would a SQL Server 2008 R2 database disable a table index when upgraded to SQL Server 2012
I've restored a database backup in a new SQL Server 2012 server from a .bak made in SQL Server 2008 R2, and one of the tables has it's primary key index disabled. This doesn't happen when I restore to ...
4
votes
2answers
291 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 ...
3
votes
1answer
1k 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 ...
2
votes
1answer
91 views
Software for backing up SQL Server databases
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 ...
2
votes
2answers
122 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?
3
votes
2answers
585 views
Removing Archive Logs after PostgreSQL PITR online-recovery
I'm using pgpool-II + PostgreSQL 8.4 on three servers: primary + standby1 + standby2.
Replication mode is "on"
Load balance mode is "on" (between primary and standby1)
I followed the official ...
3
votes
1answer
78 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?
0
votes
1answer
576 views
How to Create Snapshot Backups in MySQL
I've seen a lot of people talking about snapshots backup, even I'm reading a book about mysql but nobody explain the code how to make a snapshots backup. This is what the book says:
flush tables ...
2
votes
3answers
546 views
How to detect a running mysqldump?
Here are the things I can't change:
We got a mySQL myISAM replication running a master and some slaves. One slave is being used for nightly backups using mysqldump. The backups is using heavy locks ...
-4
votes
5answers
2k views
Safely deleting a SQL Server log file (.LDF)
I can make sure my app is in a consistent state.
I can rollback all the uncompleted transactions if any (just in case) it's ok
I can DETACH the database
What do I need the log file for after that?
...
