Wednesday, May 23, 2007

How to delete log file

If you want to delete the log file, this the command:
(database eq : SASB)

USE SASB
BACKUP LOG SASB WITH TRUNCATE_ONLY
GO
DBCC SHRINKDATABASE(SASB,0,TRUNCATEONLY)
GO
EXEC sp_addumpdevice 'disk', 'DumpDisk','e:\program_files\data\dumpdisk.bak'
GO
BACKUP DATABASE SASB TO DumpDisk
GO

No comments: