Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Bulk_Logged mode

Author  Topic 

itsonlyme4
Posting Yak Master

109 Posts

Posted - 2012-09-19 : 10:55:04

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??????

   

- Advertisement -