May 29, 2015 at 4:11 am
Hi,
I'm setting up a new SQL server which will be running on SQL 2014, I want to log ship the databases from the old SQL server 2008 server. However when I've setup the job, I'm unable to restore the database on the 2014 as the database needs updating. If I update the database this will invalidate the logs that will be shipped to it.
Has anyone had any experience of log shipping between 2008 and 2014, where the 2008 box is the primary server? How do you get around the need to update the database? The servers need to stay in sync (or near as).
Any help is appreciated.
Marcus
May 29, 2015 at 4:13 am
Restore the DB as NORECOVERY, restore the logs as NORECOVERY. It will work, but it's not a DR setup and the secondary database cannot be made readable. It's typically used as part of an upgrade.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2015 at 4:15 am
Hi,
Thanks for the quick response, I'll give this a shot as this process is only for a new deployment / upgrade so failing back to the primary is not of importance.
Marcus
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply