SQL Server Performance

Migrating SQL server to a new Server

Discussion in 'SQL Server 2005 General DBA Questions' started by Joben, Jan 7, 2011.

  1. Joben New Member

    Hi Friends,
    What is the best way to move databases from one to another server?
    Thank you


  2. Luis Martin Moderator

    Hi Joben,
    You can find the same question in severals post in our Forums.
    Use search option and back again.
  3. sandeepsingh_05 New Member

    Hi,
    There are many methods available, backup-restore, attach-detach,copy db etc.. go through BOL or msdn sites..
  4. satya Moderator

    Joben
    As Luis suggested this is a frequently asked question here, so you will find relevant information by searching on forums. Also here is the http://support.microsoft.com/kb/224071 KBA that will give a startup options.

Share This Page