01/05/2012
How To Delete The Log File Data From Database
To delete the Log file use the following script:
dbcc shrinkfile('DB_Name_log', 1)
backup log DB_Name with truncate_only
dbcc shrinkfile('DB_Name_log', 1)
backup log DB_Name with truncate_only
dbcc shrinkfile('DB_Name_log', 1)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment