BACKUP LOG <database name> WITH TRUNCATE_ONLY
USE <database name>
DBCC SHRINKFILE (2, 20)
USE <database name>
DBCC SHRINKFILE (2, 20)
-- 2, file id of log file
-- where 20 = 20 MB , target size of log file
Subscribe to:
Post Comments (Atom)
Solution of Programming Problems
Labels: SQL Server
0 comments:
Post a Comment