November 25, 2015 at 4:49 am
Dear Fellow
Pl. guide me how to do on above subject. also I need Log shipping from SQL 2008 R2 to SQL 2012 Rs
Regards
Nitin
November 25, 2015 at 4:57 am
https://technet.microsoft.com/en-us/library/ms190640%28v=sql.110%29.aspx
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 25, 2015 at 5:09 am
You cannot log ship down-version. A SQL 2012 database cannot be restored to a sQL 2008 R2 server, neither can log backups, so that's not going to happen.
Log shipping up-version (sql 2008 R2 to SQL 2012) can be done, it's no different in setup to log shipping with the same version. That said, it's only supported for the purposes of a rolling upgrade, it's not a very sensible thing to do as a DR setup (because if it's ever failed over, it cannot be failed back because databases can't be restored down-version). The only mode that is allowed is with the second database RESTORING, hence not readable.
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply