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:
Post a Comment