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

Replication or log shipping for reporting database Expand / Collapse
Author
Message
Posted Tuesday, July 9, 2013 10:29 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 4:40 PM
Points: 96, Visits: 608
I'm trying to decide between log shipping and replication for using a secondary database for reporting purposes. They want to have a secondary database for use as a reporting database. They're OK with the databases being 30-60 minutes out of sync. I was thinking about log shipping but I can't kick the users out when the logs are restoring. Now I'm thinking about using snapshot replication but I don't know if 30-60 minutes is too often for snapshots to be recreated. The database is about 25G. Should I just use transactional replication? Any thoughts would be greatly appreciated.
Post #1471734
Posted Wednesday, July 10, 2013 12:16 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 10:40 AM
Points: 47, Visits: 813
Transnational Replication might do the job but if the primary database is going to be updated with new tables and columns then this could become a problem since it would not sync unless you add as an article and also it will add identity columns to all of these so i feel that you can use mirroring and snapshot it on the reporting server and this way you can snapshot whenever you need the latest.
Post #1471956
Posted Wednesday, July 10, 2013 9:11 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 4:40 PM
Points: 96, Visits: 608
I was thinking of transactional replication as well. I was going to do snapshot replication as a temporary fix and then implement transactional later. Mirroring plus snapshots is a good idea but we only have SQL 2008 Standard so we can't create snapshots. Thanks for the input!
Post #1472195
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse