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

shrinklog fle Expand / Collapse
Author
Message
Posted Sunday, May 4, 2014 8:12 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Sunday, October 5, 2014 8:30 AM
Points: 526, Visits: 2,033
how to shrink the logfile of the database who is configured in replication?
Post #1567396
Posted Monday, May 5, 2014 1:24 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:32 AM
Points: 4,372, Visits: 10,652
A Google search with your exact words produces lots of results.
http://www.google.it/search?q=how+to+shrink+the+logfile+of+the+database+who+is+configured+in+replication

Are you sure none of those can help you?



--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1567425
Posted Monday, May 5, 2014 5:01 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 @ 3:55 AM
Points: 40,159, Visits: 36,545
ramyours2003 (5/4/2014)
how to shrink the logfile of the database who is configured in replication?


Exactly the same way you shrink a log file for a DB that isn't replicated. DBCC ShrinkFile.



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 #1567469
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse