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

shrink logfile in replication Expand / Collapse
Author
Message
Posted Friday, March 21, 2014 4:04 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: Today @ 8:12 AM
Points: 521, Visits: 2,007
what is the procedure to shrink the log file when the database is configured in replication .

Post #1553695
Posted Friday, March 21, 2014 4:23 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:15 PM
Points: 5,976, Visits: 12,886
the same as for any other database. The only effect replication has is that the transactions will have to have been replicated before you can shrink past the virtual log file containing them.

Normal caveats about shrinking apply.


---------------------------------------------------------------------

Post #1553705
Posted Friday, March 21, 2014 4:57 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: Today @ 8:12 AM
Points: 521, Visits: 2,007
can you send any query to do
Post #1553708
Posted Friday, March 21, 2014 5:13 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:06 PM
Points: 3,865, Visits: 7,130
Please review this similar post, it will give you a script to accomplish what you want and outline some things to think about before you actually make a decision to run the query

http://www.sqlservercentral.com/Forums/Topic570720-146-1.aspx


______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1553709
Posted Friday, March 21, 2014 5:20 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:06 PM
Points: 3,865, Visits: 7,130
FYI, in its simplest form
USE [DATABASE]
GO
DBCC SHRINKFILE (N'Database_log' , 0)
GO



______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1553710
Posted Friday, March 21, 2014 5:33 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:15 PM
Points: 5,976, Visits: 12,886
please read these

http://www.sqlservercentral.com/articles/Administration/64582/

http://msdn.microsoft.com/en-us/library/ms189493(v=sql.100).aspx


---------------------------------------------------------------------

Post #1553712
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse