Solved

Copying a SQL2000 DB to SQL Server 2005

Posted on 2009-04-06
2
178 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
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

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…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

758 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