RE: New Server Hardware - Move everything from one Server to another?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi, Scott,
I understand that you had two questions:
1. How to move databases between two SQL Server 2005 servers?
2. Can all the database files including master and other system databases
be moved on the new server?
If I have misunderstood, please feel free to let me know.

For your first question and partial of your second question, you can refer
to this artilce:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/?id=314546

For your second question, you can restore all of the user databases to the
target server; howeveryou cannot restore or attach the system databases to
a new server, unless they have the same environment (same OS, same
installation path, and same service packs etc).
In most cases, it is no need to restore your system databases to a new
server. Could you please let me know your requirements?

If you have any other questions or concerns, please feel free to let me
know.

Best regards,
Charles Wang
Microsoft Online Community Support
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================





.

Relevant Pages

  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Copying WSS to another Server
    ... the data in sync I back the SQL databases up and restore them to the replica ... It already has WSS installed. ... > on one server and copy it to another for dev/test purposes, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Moving SQL Server 2000 from NT4.0 to Windows 2003
    ... Detach your existing user databases, ... user databases (or RESTORE) to the new server. ... > Hey Steve, ... Windows 2003 will not allow SQL Server SP less than 3. ...
    (microsoft.public.sqlserver.server)
  • Re: Exchange DR, what to do
    ... setup blank databases on theDRexchangeserver, ... data out of the RSG, it tries to restore it to the original server, ... the cluster exchange virtual server name was, ...
    (microsoft.public.exchange.admin)
  • Re: Server Migration...
    ... If you have restored all of your databases, ... Columnist, SQL Server Professional ... Does that mean I need to restore all user databases first and I restore ... Master, MSDB, Model. ...
    (microsoft.public.sqlserver.server)