Solved

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

Posted on 2007-11-28
3
154 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
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…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

718 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