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 |
|
f.collini
Starting Member
2 Posts |
 Posted - 2004-06-16 : 08:34:00
|
| Hello,i am experiencing problems at a customers of mine; he has got a MSDE 2000 with a 4Gb Transaction File Log Full.I can do no operations, nor backup until i free up space in this log.Is there a way (perhaps with the OSQL command), to delete the transaction file log conserving the other data?My customer has no updated backup!!! ((::Thank you in advance for your interest, best best regards!Francesco |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-16 : 13:23:22
|
| BACKUP LOG DBName WITH NO_LOGThat will truncate the transaction log. But, you also need to determine why it has grown so large. What is the database recovery model set to? If it is FULL and you need the ability to restore to a point in time, then you need to start performing regular transaction log backups. If you don't need the ability to restore to a point in time, then change it to SIMPLE and you won't have to worry about this again.Tara |
 |
|
|
f.collini
Starting Member
2 Posts |
Posted - 2004-06-16 : 17:57:49
|
| Ok Tara,first of all thank you in advance for your kind interest.I do not need to restore at a certain time, so i want to use the SIMPLE Backup.I make backup of my DB with osql and i use this command:OSQL -U ... -P ... -Q "BACKUP DATABASE DBNAME TO DISK = 'C:\SOS\DBNAME.SAV'".How have i to modify this script in order to not backup transaction log anymore?Thank you again, best regards!Francesco |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-16 : 17:59:52
|
| To change your recovery model, use ALTER DATABASE command. You do not need to change the backup database command.Tara |
|
|
|
|
|
|
Msde2000: Deleting File Transaction Log Full