September 24, 2007 at 2:07 am
Hi,
I am trying to restore a SQL 2000 database to an SQL 2005 database but when I select the database to restore, in the logical file name boxes it says "master" and "mastlog" I have checked and the file I am trying to restore is not the master database. Why would it say this as also the database will not restore as it gives an sysnsobjs object aready exists error.
Thanks for your help
Julian
September 24, 2007 at 8:53 am
How are you trying to restore the database?
What happens if you try to restore it using T-SQL?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
September 24, 2007 at 9:12 am
Restore it with a different database name (don't use the defaults) and change the logical names to match this as well.
September 24, 2007 at 11:58 pm
Hi Julian,
I can understand why this is causing you some confusion as it is not blatantly obvious - but you are able to type over where it says "Master" and add the name required for your DB restore.
Catherine Eibner
cybner.com.au
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply