Need guidance with SQL 2000 server being rebuilt and upgraded to SQL 2005

I have a a server 2003 server running SQL 2000.  I need to reload the OS and install SQL 2005.  I have a critical DB that I need to be able to put back in place on SQL 2005 when the server is reloaded.

1 - how do I backup up my DB and necessary logs and other files from SQL 2000?
2 - how do I restore the DB to the SQL 2005 server once it is rebuilt?

I'm a network admin not a DBA so I'm flying blind on this one.

Thanks in advance for any help!

-jamie177
jamie177Asked:
Who is Participating?
 
Kevin3NFCommented:
You can go the GUI route and right-click the database in SQL 2000 Enterprise Manager.  All tasks>>Backup database.

After the rebuild, in SQL 2005 management Studio, right click Databases>>Restore database

That part is easy.  You will more than likely have issues with users and security, since that information is stored in the master db.  I've not done this sort of upgrade and had to mess with users/logins, but I have no doubt its documented by MS and here on EE
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.