The transaction log for database 'mydatabase' is full
Issue : The transaction log for database 'mydatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
Resolution :
BACKUP LOG WITH TRUNCATE_ONLY GO DBCC SHRINKFILE (, 1) GO
No comments:
Post a Comment