I have the typical need to bring down the size of a log file from 17 gig to maybe 2.0 gig Heavy deletions in overnight processes.
My maintenance task is to call :
1) Backup DB to backup object. Completes
2) Backup Log to backup object -- Completes
3) Execute Script :
-- Get your space back to 2. gig
DBCC SHRINKFILE (db_log, 2000) << FAIL
Message in history is cut off telling me why?
Any ideas on this?