Solved

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

Posted on 2007-11-28
3
150 Views
Last Modified: 2010-03-19
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
Comment
Question by:jamie177
3 Comments
 
LVL 21

Accepted Solution

by:
Kevin3NF earned 500 total points
ID: 20375065
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now