i have a long-neglected sql server 2000 instance and the logfile for the model database has grow out of control.
the model db was in full recovery mode for who knows how long with no transaction log backups being run against it. the model db database file is under 1MB but the logfile is 160GB.
Not sure what the best course of action is here..
a full backup of the model DB is running now but it's just spinning (not finishing).
should I cancel it and attempt a TLOG backup?
or shrink the log like this:
--sp_helpdb to verify log size, FileID and recovery Mode of the log
--If necessary, change recovery mode to Simple
alter database [mydatabase] set recovery simple
--Backup LOG with NO_LOG
BACKUP LOG [mydatabase] WITH NO_LOG
--Shrink log file
DBCC SHRINKFILE (2)
--If necessary, change recovery mode back to FULL
alter database [mydatabase] set recovery FULL
--be sure to perform a FULL database backup when completed
and then leave put it in simple recovery mode and leave it there?
any guidance would be appreciated.