March 21, 2014 at 4:04 pm
what is the procedure to shrink the log file when the database is configured in replication .
March 21, 2014 at 4:23 pm
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.
---------------------------------------------------------------------
March 21, 2014 at 4:57 pm
can you send any query to do
March 21, 2014 at 5:13 pm
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; Theyll drag you down to their level and beat you with experience
March 21, 2014 at 5:20 pm
FYI, in its simplest form
USE [DATABASE]
GO
DBCC SHRINKFILE (N'Database_log' , 0)
GO
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 21, 2014 at 5:33 pm
please read these
http://www.sqlservercentral.com/articles/Administration/64582/
http://msdn.microsoft.com/en-us/library/ms189493(v=sql.100).aspx
---------------------------------------------------------------------
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply