SQL Server 2000 machine failed, move database to SQL 2005 machine


We have a Windows 200 server machine with SQL server 2000 which has failed and also the backup.

We can access the HDD and have extracted the .MDF & .LDF files.

How can I bring this database into a SQL 2005 server which we have?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Barry CunneyCommented:
1. Make a good separate backup copy of the MDF and LDF files in case there are any problems or if you wish to back to SQL 2000 gain for any reason.

2. Copy the MDF and LDF files to a location appropriate and visible for your SQL Server 2005 instance - it is good practice to put the LDF file on a separate drive to the MDF file if possible.

3. In SQL Server 2005, right-click the databases node and choose the Attach Database option - you will get a GUI in which you can choose to add the MDF and LDF files
David ToddSenior DBACommented:

point 2.1
Check the rights on these files. On modern systems you may need to unblock these files, and do double check that SQL has full access to these files.

point 4
Check the users etc have the appropriate rights to access the database.

Point 5
Check the database settings, compatibility mode, checksum vs torn page, etc.

point 6
Check that your maintenance plans (backups, transaction backups, index optimisation, etc) will apply to the new database


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.