upgrade SQLSERVER 2005 to 2012 with logshipping
Posted on 2013-12-26
I have a database 2005 R2 64 bit SQLserver (standard edition) that is about 100G that has log shipping enable to a remote machine over the WAN . The secondary DB is use for disaster recovery and it is in "read-only state, Now , I would would like to upgrade to SQLServer 2012 . How would the upgrade affect my log shipping jobs?. Do I have to redo the logshipping?
It would be an issue if I have to redo the log shipping since it will take days to transfer a backup to the remote location using our WAN
Thanks for your help