July 18, 2011 at 12:18 pm
Hi all,
I am trying to Backup some Databases from Live Server and then I want to Restore them in the Test Server but I keep receiving the following error message "...is not part of the media set that is currently being processed, ensure that the backup device are loaded with the current media.
Would you please let me know what I am doing wrong please, I am using the SQL Wizard to do the Back up.
Thank you
July 18, 2011 at 12:36 pm
It sounds like a database with that name already exists on the test server. You can choose a different name or on the Restore wizard go to options and click the check box "Overwrite the existing database".
Adam Durr
Remote DBA support
www.bluegecko.net
July 18, 2011 at 12:46 pm
An explanation:
http://social.msdn.microsoft.com/Forums/en/sqltools/thread/abf50e00-c9b0-4809-9e61-43ed8a53e968
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 18, 2011 at 2:11 pm
And perhaps why this occurred: http://voiceofthedba.wordpress.com/2011/07/18/sql-server-backup-inadvertent-striping/
July 19, 2011 at 5:57 pm
Write the code yourself.
backup database test to disk = 'c:\test.bak'
restore database test from disk = 'c:\test.bak'
<with move> etc. check bol.
Which is faster, the above or a GUI.
Please you also know what is going on when things fail.
GUI = goooey
Cheers
Jannie
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply