+ Post New Thread
Results 1 to 2 of 2
Enterprise Software Thread, moving databases from SQL2000 to SQL2005 without loss of service. in Technical; Hi All You will have to excuse my lack of knowledge with SQL but I have been tasked with retirting ...
  1. #1
    ranj's Avatar
    Join Date
    Feb 2006
    Thank Post
    Thanked 42 Times in 32 Posts
    Rep Power

    moving databases from SQL2000 to SQL2005 without loss of service.

    Hi All

    You will have to excuse my lack of knowledge with SQL but I have been tasked with retirting some of our oldest servers which are currently still used in production. Most of them are fine but I have hit an Windows 2000 Server with SQL 2000 and one of the databases is for our intraserver. I need to devise a plan to move this database over to an SQL 2005 or 2008 server.

    Any ideas on where I should start.

    Also as its a really old server I think there could be other db running on there. Does anyone know how I can find out what other databases are running on that server. If I go to SQL server enterprise manager, go to databases they are absolutely loads of db's but I have been told that most of them have been migrated over to other servers since.

    I went to current activity and checked the locks/object section and this I think is showing me what databases are currently used because I am assuming if they are locked it means that they are in use.

    Does anyone know of a better way?

    Any sites/books others would recommend for a newbie DB administrator it would be greatly appreciated. BTW these servers are VM's on a VMware ESX4 cluster.


  2. #2

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    In the Calamatorium.
    Thank Post
    Thanked 495 Times in 337 Posts
    Blog Entries
    Rep Power
    The good news is that you can backup the databases and restore to the new server as many times as you like without affecting the live system. The current, live SQL service will only disappear when you shut it down.

    A common gotcha is forgetting to migrate the SQL logins to the new server.

    This is a good guide for the task. Read it thoroughly; it's useful.
    If you're just testing, ignore the part about setting the database to single-user mode. Doing this will disrupt the service. You don't need to do this when you create a backup for your test.
    Last edited by jinnantonnixx; 5th October 2011 at 02:28 PM.

  3. Thanks to jinnantonnixx from:

    ranj (5th October 2011)

+ Post New Thread

Similar Threads

  1. Replies: 2
    Last Post: 27th May 2011, 09:03 AM
  2. Moving sims from 32bit to 64bit server
    By ful56_uk in forum MIS Systems
    Replies: 6
    Last Post: 11th October 2010, 10:41 AM
  3. Moving from CC3 to something else?
    By reggiep in forum Network and Classroom Management
    Replies: 103
    Last Post: 12th January 2009, 10:55 AM
  4. Moving from Apache to IIS
    By lovelldr in forum Windows
    Replies: 7
    Last Post: 3rd August 2007, 11:51 AM
  5. Moving RIS from 1 server to another
    By Zoom7000 in forum Windows
    Replies: 15
    Last Post: 10th February 2007, 12:25 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts