[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

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
0
jamie177
Asked:
jamie177
1 Solution
 
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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now