Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

configuring log shipping from 2008 to 2005 Expand / Collapse
Author
Message
Posted Saturday, October 13, 2012 6:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 9:48 AM
Points: 66, Visits: 171
can we configure below logshipping setup
Prmiary: SQL Server 2008
Secondary Server 2005 with Standby Mode

would it work? can any one suggest me?
Post #1372416
Posted Saturday, October 13, 2012 7:27 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:03 PM
Points: 42,485, Visits: 35,554
Cannot be done. Databases can never be downgraded.

For log shipping with standby, the secondary must be the same version as the primary. If you're restoring with norecovery, the secondary can be a higher version, but never a lower.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1372420
Posted Sunday, October 14, 2012 2:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:12 AM
Points: 1,362, Visits: 15,266
sreenubabu.s (10/13/2012)
can we configure below logshipping setup
Prmiary: SQL Server 2008
Secondary Server 2005 with Standby Mode

would it work? can any one suggest me?


The only way you "could" get the data on a lower version of sql is to use replication. This could be scheduled in a similar manner to log shipping if you wished
Post #1372488
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse