SQL Server Performance

Migrate log shipping standby server to new server

Discussion in 'SQL Server 2005 Log Shipping' started by yhchan2005, Jul 18, 2010.

  1. yhchan2005 Member

    Hi, my company just bought a new server with high powerful spec. currently i am using 1 server which is doing log shipping standby server, would like to know the step to transfer/ move the database to the new server. My DB size now is around 400GB, backup and restore will take very long time, hope to get some simple way to do it. thanks.
  2. ashish287 New Member

    dettach from source and attach to destination. But you need to calculate your downtime as database will not be available for that perticular period.
    As well how to do this with user and system database, please google and you will find lot of article.
  3. satya Moderator

    As referred have you agreed the downtime from business to transfer the databases to new hardware?
    So this will be a total migration of SQL Server platform, as you say database size is around 400 GB see what is the size of transaction log and if possible SHRINK it in order to sustain the size for the move, once the new server is setup with databases you can easily set back the LDF size.
    There are plenty of questions in this regard in the forums, also you can refer to KBA http://support.microsoft.com/kb/224071 & http://support.microsoft.com/kb/314546

Share This Page