philduba.com

SQL Server 2005 Restore from SQL Server 2000 BAK File

Posted On August 21, 2007 8:58 AM By Phil in SQL Server

I had a problem that was racking my brain for quite some time. A project I was working on was an addition to a legacy system. I was given the code base and a backup file of the database. The file was generated from a SQL Server 2000 database. I am running SQL Server 2005 Developer on my local environment. I had the hardest time importing it using the Restore option in Management Studio. I kept getting that the the import could not be done. After wading through a ton of partial posts and cross references that no longer existed, I found this posting on the MSDN forum. It gave both SQL and Management Studio options. The worts part, all I had to do was click "Overwrite Database" in the Options of the Restore wizard, and I would have had this working a while ago. Well, now I have a reference in case I run into the same problem again.

Comments (3) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 1752 Views

Comments

Bless your heart for posting this. You just upgraded my night's work from godawful and thankless to merely bothersome and tedious :D

# By Michelle Kinsey Bruns | 9/4/07 10:38 PM

You're welcome Michelle. I spent a looong time trying to figure it out (think weeks, not days or hours), so glad my post could help out someone else.

# By Phil | 9/4/07 11:06 PM

I'm going to add one more thing to this. In the options, there is a destination for the mdf and log files, make sure they got to the right path. That one got me today importing a DB for my .NET project.

# By Phil | 9/5/07 9:07 PM

Post Your Comments

Name:

Email Address:

Website:

Comments:

Enter text that you see in the image:

Remember My Information:

Subscribe:

If you subscribe, any new posts to this thread will be sent to your email address.