Migrate log shipping standby server to new server | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Migrate log shipping standby server to new serverHi, 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.
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.
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