What's up!

Pyaarey Allah!

Tuesday, June 25, 2013

MS SQL Shrink DB Log File


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

1 comment: