SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Bulk_Logged mode
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

105 Posts

Posted - 09/19/2012 :  10:55:04  Show Profile  Reply with Quote

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

  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000