SQL Server

Shrink transaction log file in Sql Server

Command are as follows:

For Sql Server 2005

BACKUP LOG 
[DBNAME] 
WITH TRUNCATE_ONLY
DBCC SHRINKFILE(
[DBNAME]
_log)


For Sql Server 2008



ALTER DATABASE [DBName]
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (DBName_log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE [DBName]
SET RECOVERY FULL;
Ebook Download
View all
Learn
View all
Membership not found