Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
SQL2000 Transaction Log
Name: techieman Date: June 15, 2007 at 08:57:24 Pacific OS: Server 2003 CPU/Ram: 3.00Ghz / 3gb RAM Product: HP
Comment:
I am having some problems with a transaction log file which has grown to 98gb. Basically I need to shrink it to free up some space.
I have tried using the DBCC SHRINKFILE (database) command and also BACKUP LOG database etc but as the space on the server is less than the LDF file it isnt working.
Can anyone tell me how to shrink this file, Please! :-)
Life is more painless for those who are brainless.
0
Response Number 2
Name: techieman Date: June 15, 2007 at 09:35:21 Pacific
Reply:
Thanks for that, however, I still have the problem that I cannot Backup, Truncate or Shrink the database because I do not have enough disk space on the server. The DB is 98GB in size and I only have 30GB Free Space!
Summary: Hey all, We have an exchange database that appears to be corrupted, or has a hardware failure. Maintenance fails to run and backups fail to complete. ESE errors are present after these failures, along...
Summary: We're running Windows 2003 SBS and Backup Exec 10d. We do full backups twice weekly. The Exchange 2003 transaction logs are not flushing after a full backup using BackupExec. I've also done several ...
Summary: "Why can't I make desktops or small factor desktops domain controllers? All they do is process logins. Why must I need server class PC's to be servers? Would it be better if I make a Pentium 2 233 MHz...
0 
