Solved

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

Posted on 2007-11-28
3
153 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

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Grid querry results 41 83
CREATE DATABASE ENCRYPTION KEY 1 80
SQL query to summarize items per month 5 78
Downgrading MS SQL 2008 R2 Enterprise to MS SQL 2005 Standard? 12 84
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

726 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