Tran log full and disk space also full. Can not take the tran log on same disk.So take tran log to diffrent disk.then follow the 3 steps 2 or 3 times and log space will come to normal.
USE DatabaseName GO 1. DBCC SHRINKFILE(, 1) 2. BACKUP LOG WITH TRUNCATE_ONLY 3. DBCC SHRINKFILE(, 1) GO
No comments:
Post a Comment