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

Bulk_logged mode during reinitialization - sql server 2000 transactional RePL Expand / Collapse
Author
Message
Posted Wednesday, September 19, 2012 8:50 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, March 24, 2014 5:37 AM
Points: 743, Visits: 1,535

Running a reinitialization of one of my Subscribers (SQL Server 2000 Transactional replication)

The bulk-inserts are giving me grief - we have limited space. I changed the recovery mode of the subscriber DB to bulk-logged and I am doing FREQUENT transaction log backups. I read that the entire process is one long transaction - but I think that means one transaction for each article? So I should be able to shrink the log between larege tables??????



Post #1361410
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse