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!