I just had to use this command to shrink a 350 GB log file!
NUL: - a null device. I feel like I'm back in my PDP/11 or VAX days!Code:BACKUP LOG Acctfiles TO DISK='NUL:' DBCC SHRINKFILE ( Acctfiles_Log, 1)
It worked!
|
Results 1 to 6 of 6
Threaded View
|
Click Here to Expand Forum to Full Width |