USE [master] GO ALTER DATABASE YourDBName SET RECOVERY SIMPLE WITH NO_WAIT USE YourDBName; GO DBCC SHRINKFILE (YourDBName_Log_File_Logial_Name, 1024); GO USE [master] GO ALTER DATABASE YourDBName SET RECOVERY FULL WITH NO_WAIT GO
What's up!
Pyaarey Allah!
Tuesday, June 25, 2013
MS SQL Shrink DB Log File
Subscribe to:
Post Comments (Atom)
This comment has been removed by the author.
ReplyDelete