Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Credo
Starting Member
5 Posts |
 Posted - 2009-07-19 : 11:55:33
|
I'm in a bit of a pickle here - and I'm hoping someone can help me out here fairly soon. I've been getting the:"The log file for database 'TMS' is full. Back up the transaction log for the database to free up some log space"Therefore, I've run this code to backup the transaction logs to another machine on the network, as well, I've backed it up to removable media.BACKUP LOG [TMS] TODISK = N'\\D6001\db_BACKUP\AW8.TRN' WITH NOINIT,NAME = N'TMS transaction log backup',STATS = 10GO What now?I'm still fresh out of disk space. Can I now delete the LDF file from the DATA directory? I still need to clear up space, but I'm not sure what the next step would be.Basically we've just been backing up the database flat files to another drive (both MDF, and LDF).Any help would be GREATLY appreciated - especially sooner rather than later. we're kind of at a stand still right now. :( |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-19 : 13:43:46
|
You can SHRINK the logfile, if it is larger than you expect.Something have made the log file to grow.How often do you do normal full backups?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-19 : 14:09:39
|
| Do not delete the log file. It's not an optional file, deleting it can damage the database, sometimes beyond repair.See this article on managing transaction logs [url]http://www.sqlservercentral.com/articles/64582/[/url]Also, if you've been backing up the database files while SQL is active, there's a good chance those files will be useless for restore. You should back the database up using SQL's backup functions and then copy the backups to tape.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
TRN file generated... now what?