+ Post New Thread
Results 1 to 2 of 2
Windows Server 2008 R2 Thread, Moving an SQL Database from Windows 2003 - 2008 in Technical; I've got a SQL server 2008 database here which currently is used with our encryption software installed on Windows server ...
  1. #1


    Join Date
    Sep 2008
    Posts
    1,760
    Thank Post
    321
    Thanked 258 Times in 211 Posts
    Rep Power
    119

    Moving an SQL Database from Windows 2003 - 2008

    I've got a SQL server 2008 database here which currently is used with our encryption software installed on Windows server 2003. Now the server is dying and we need it transferred onto a new 2008 Server but the problem I have is that I've never used SQL and I'm not sure if I've done it right or if there are thing's Ive missed in the process.

    My thoughts were to create a backup of the database and then restore it on the new server. Currently (2003 server)when connecting to the database it connects showing ServerName\DatabaseName. However, if I try to create the database on the new server it wont let me create an instance with ServerName\DatabaseName but it will let me create DatabaseName which I can then restore the database to. When I try to install our encryption software and point it to the new database it provides me with an error saying that the database is either not there or not configured for remote access. I assume this is because I have not restored the database using the same ServerName\DatabaseName which means I haven't configured SQL correctly.

    Unfortunately this was originally setup by someone who is now off and as the server is dying it needs to be moved ASAP.

    Is there something I can check to allow me to create a new database with the same structure as SererName\DatabaseName?

  2. #2


    Join Date
    Sep 2008
    Posts
    1,760
    Thank Post
    321
    Thanked 258 Times in 211 Posts
    Rep Power
    119
    OK, it looks like I haven't setup SQL server correctly so back to the drawing board it is.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 4
    Last Post: 19th March 2012, 08:58 AM
  2. Essential tools to manage a Windows 2003/2008 domain?
    By reggiep in forum Windows Server 2000/2003
    Replies: 8
    Last Post: 6th May 2009, 09:47 AM
  3. Share iTunes Library from Windows 2003 Server
    By crc-ict in forum Windows Server 2000/2003
    Replies: 16
    Last Post: 18th August 2008, 08:40 PM
  4. Pushing printer installs from Windows 2003 R2
    By localzuk in forum Windows
    Replies: 16
    Last Post: 20th February 2007, 02:58 PM
  5. Replies: 16
    Last Post: 29th March 2006, 03:52 PM

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
  •