Solved

Copying a SQL2000 DB to SQL Server 2005

Posted on 2009-04-06
2
220 Views
Last Modified: 2012-05-06
I know this is a simplistic question. I cannot fine anything about this and BOL is unhelpful.

I'm not an admin, but my boss tossed this to me anyway.

Thanks for any help you may offer.

-Bob
0
Comment
Question by:bobcann
[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
2 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 500 total points
ID: 24081431
Take a FULL database backup, then restore it on the SQL 2005 server.  

Do you have access to the 2000 backups?  Are you able to create databases on the 2005?
0
 

Author Comment

by:bobcann
ID: 24081753
It was already copied without my knowledge.

Thank for your advice.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

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…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

751 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