Resolution :
BACKUP LOG
GO
DBCC SHRINKFILE (
GO
Monday, September 6, 2010
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
Resolution :
BACKUP LOG
GO
DBCC SHRINKFILE (
GO
Subscribe to:
Posts (Atom)