Hi guys,
I have a problem, I made a full backup of my old database, that was running in SQL 2000 and took the backup database to the new computer running sql 2005, i tried to restore the database into a new one in sql 2005, and it does not work. It says the backup
set contains backup for another database and not for the new one i created in sql 2005.
I am not sure what to do, can you help me out?
thanks
-
-
Tyler Brown
Bullets change governments far surer than votes.
I'm not a big SQL Database guru, but wouldn't it solve your problem if you just did a database dump to text file, exporting the table structure of all tables as well as all the data contained therein. Simply run this SQL dump script on the SQL Server 2005 machine and it will create all tables and populate them as well?
Edit: I realize that the text files could get rather large, rather quickly. I'm not sure what the limit is, if any, on the size of SQL scripts. -
stephbu
Error and Omissions Excluded
By default SQL will try to restore the database files in their original locations. I think its pretty likely that its failing because the current file device names/locations differ from those original locations. (e.g. different drive name or path)
Have a look in the Transact SQL Help for the RESTORE DATABASE topic, in particular the WITH MOVE <name> TO <filename> clause.
This article walks through some of the steps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;304692 -
Marcopio
Church
You cannot restore an SQL Server 2000 Backup with SQL Server 2005.
But you can use the Copy Database Wizard from SQL Server 2005 to Copy one or all of your databases from SQL Server 2000 to 2005.
Hope this helps.
Peace in Christ
Marco Napoli
http://www.ourlovingmother.org -
Pace
What do you see?
yup yup thats what I did. Try its built in tools first
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.