Copying a SQL2000 DB to SQL Server 2005

I know this is a simplistic question. I cannot fine anything about this and BOL is unhelpful.

I'm not an admin, but my boss tossed this to me anyway.

Thanks for any help you may offer.

-Bob
bobcannAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
BrandonGalderisiConnect With a Mentor Commented:
Take a FULL database backup, then restore it on the SQL 2005 server.  

Do you have access to the 2000 backups?  Are you able to create databases on the 2005?
0
 
bobcannAuthor Commented:
It was already copied without my knowledge.

Thank for your advice.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.