Restore Prod to Test problems - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Restore Prod to Test problems

Author

Topic

DrewBurlingame
Starting Member

49 Posts

Posted - 2002-05-21 : 23:40:24

I'm suddenly having problems restoring a copy of my production db to my test box. I've done it numerous times, but now it gives me the following error:

Server: Msg 3154, Level 16, State 1, Line 1
The backup set holds a backup of a database other than the existing 'Priya' database.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.

When I delete the Priya database on the test box, and try to restore, the operation times out. I'm at a loss.

Any ideas?

Thanks,
Drew

marileng
Starting Member

28 Posts

Posted - 2002-05-22 : 00:30:26

On the options tab on restore database window, check the path of restore as whether it is the same as the file where you assigned your new database.

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-05-22 : 09:00:35

quote:

Error 3154
Severity Level 16
Message Text
The backup set holds a backup of a database other than the existing '%ls' database.

Explanation
The backup set is a backup of a database with the same name as the database to which you are restoring. However, the database being restored was created by a different CREATE DATABASE statement than the database in the backup set. Even though the databases have the same name, they are in fact different databases.

Action
Either overwrite the existing database by reissuing the RESTORE DATABASE command using the WITH REPLACE clause, or restore the backup set to a different database name. If you restore the backup set to a different database name, ensure that the files that will be created do not already exist and are not being used by another database. If you chose the wrong backup set to restore, select a backup of the existing database and restore it.

-sql7 BOL

<O>

nr
SQLTeam MVY

12543 Posts

Posted - 2002-05-22 : 09:11:53

>> When I delete the Priya database on the test box, and try to restore, the operation times out.

Implies that it's not just the database existing that's the problem.
Have you tried another backup - maybe that one was currupt.
Is there enough room on the disk.
Check the file names that are being created.
Make sure that the backup contains the correct database and only one backup.
Try restoring an old backup to see if it's the live box or test that are causing the problem.

==========================================
Cursors are useful if you don't know sql.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources