Restoring a 2000 database onto SQL Server 2005

[AccessUser22]

We were given a .BAK database file from our client that I believe is in SQL Server 2000. Problem is we are running SQL Server 2005. I've read where I'm supposed to create the database and then restore using the .BAK file to get it up and running, but I'm getting an error which I think is due to the fact that the .BAK is off of a 2000 database. Can someone please tell me how I can upgrade the .BAK to 2005?

 

[AccessUser22]

Nevermind. The .BAK had two data files and my originally created db only had one. Once I added a second data file, it restored fine.

 

[mrdenny]

There is actually no need to create the database first. Creating the database first only makes it a little easier in the GUI to restore a database.

If you use the T/SQL RESTORE DATABASE command you won't have any problem restoring first try.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com