Viewing 3 posts - 1 through 3 (of 3 total)
First you can truncate the unused portion of the log by issuing:
backup log [databasename]
with TRUNCATE_ONLY
go
Then shrink the log file: get the fileid of the .ldf that you are trying to...
March 23, 2004 at 3:46 pm
#500127
I'm looking forward to the naming conventions discussion. Our 43 servers have names all over the place.
February 3, 2004 at 5:50 pm
#492692
If this is a WIN2K server make sure the SQL Agent service acct is in the local admin group. Also in Outlook you need to make sure that the...
January 15, 2004 at 11:03 pm
#490357