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

Stand by or no recovery in Log shipping ??? Expand / Collapse
Author
Message
Posted Sunday, August 18, 2013 7:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 7, 2013 4:29 PM
Points: 23, Visits: 146
Hi there,
I am going to set up a log shipping in Production environment. Just want to get input from smart computer genius here.
Question is, what recovery mode should I pick in prod environment during log shipping and why?
plz don't say it 'depends'. (Just tell me what have you been doing?)
My database is 98 GB big and expecting to grow 500 GB in 6 months.
Thank you
Post #1485580
Posted Sunday, August 18, 2013 7:53 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:41 AM
Points: 42,814, Visits: 35,937
It depends.
Do you need to read the secondary? For example, offloading reports. If so, standby. If not, no recovery.

It's got nothing to do with what other people do. It's just about what you need and what you're trying to do.



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 #1485582
Posted Monday, August 19, 2013 9:58 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, December 8, 2013 10:48 PM
Points: 31, Visits: 124
What are your reasons for setting up log shipping? Purely for DR or for off loading reporting? If you are thinking of running reporting even off the secondary know that it is still a pain in the arse. I've found it easier to just do a nightly restore of a nightly full backup (added advantage of testing every nightly full backup!). If this doesn't meet your reporting requirements and you need more realtime, i still think there are better ways then standby LS secondarys.
Post #1486094
Posted Tuesday, August 20, 2013 4:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 7, 2013 4:29 PM
Points: 23, Visits: 146
It is for DR purpose
Post #1486185
Posted Tuesday, August 20, 2013 5:02 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:41 AM
Points: 42,814, Visits: 35,937
As I said earlier
Do you need to read the secondary? For example, offloading reports. If so, use standby. If not, use no recovery.



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 #1486187
Posted Wednesday, August 21, 2013 4:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 7, 2013 4:29 PM
Points: 23, Visits: 146
Thank you so much
Post #1486634
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse