sql server
Shrink file in sql server
A
Desh-Duniya Team
Author
ALTER DATABASE your_database_name
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (your_database_name_log, 1)
GO
ALTER DATABASE your_database_name
SET RECOVERY FULL
go
sp_helpdb your_database_name