Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.
4
votes
2answers
82 views
Database stuck in restoring and snapshot unavailable
I tried to restore my database from a snapshot. This usually took around a minute to complete the last couple of times. When I did it today, it didn't complete for around 30 minutes and the spid was ...
13
votes
1answer
531 views
Sql Anywhere 11: Restoring incremental backup failure
We want to create remote incremental backups after a full backup. This will allow us to restore in the event of a failure and bring up another machine with as close to real time backups as possible ...
2
votes
1answer
298 views
Ensure correct username when using pg_restore
I have just installed postgres 9.1.6 on a local Ubuntu server. Now I'm trying to restore a database dump from a database on Heroku. The local database is setup like this:
sudo -u postgres psql -c ...
0
votes
1answer
27 views
SQL server dataloss restore
I have done an incorrect update in my DB and hence I restored the DB with a backup from the previous day. I have not taken a copy of the corrupted data before restoring the backup. Is there any ...
0
votes
1answer
129 views
mysql duplicate entry error 1062 when restoring backup
Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this.
Requirement: To create an exact replica 'db4' of an existing DB 'db3'.
Procedure ...
0
votes
1answer
178 views
Slow backup and extremely slow restores
I don't normally work with MySQL but with MS-SQL and am having issues restoring a dump backup of a 9 GB database. I converted it to MS-SQL and it takes a grand total of 4 minutes to restore but the ...
2
votes
0answers
35 views
Is it possible to have a valid backupset with null position?
In database restore process I need to rely on position column exists in backupset record to restore the latest backupset.
Restore the latest backup on the database
I noticed sometimes position is ...
1
vote
0answers
16 views
Backing up file groups with restore to earlier backup SQL Server 2008
I have a task: I have created a database with a filegroup lamb that has a few tables
I need to extract a csv into a table in a file group named lamb and backup file group lamb
Then extract another ...
1
vote
0answers
223 views
Restoring Oracle prod backup to test server with new database name
I need to restore an Oracle production database (aaprod) to a test server that already is home to a test database (aatest) under a new name (bbtest). I have a cold backup of the production database
...
0
votes
0answers
129 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 database instance using the master account I created when creating the ...
0
votes
0answers
131 views
change database name controlfiles after restore?
I have restored database with the name DB to another database called DB01
it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it ...
