restore Sql server 2000 db in sql server 2005

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

Transact-SQL (2000)

restore Sql server 2000 db in sql server 2005

Author

Topic

krushnapanda
Starting Member

18 Posts

Posted - 2007-07-27 : 05:59:31

Hello Dear,
how can i restore database in sql server 2005
my old databas is in sql server 2000
my server is citrix server

i tried it but
its gives error
System.Data.SqlClient.SqlError:The backup set holds a backup of a database other than the existing 'aa' database(Microsoft.SqlServer,Smo)
thanks

Thanks

Kristen
Test

22859 Posts

Posted - 2007-07-27 : 06:26:23

You need to use the "Overwrite" (or similarly named) option, and you may need to change the file locations, logical names and so on.

I think the GUI makes this complicated, as it is not usually obvious what is going on!, and you may be better off using T-SQL to do the job. See:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources