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 |
jjmusicpro
Yak Posting Veteran
79 Posts |
Posted - 2010-05-24 : 16:59:10
|
Im on sql server 2008 and getting this error, it was working fine until today, i didnt change anything.The transaction log for database 'mydb" is full..Any ideas? |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
jjmusicpro
Yak Posting Veteran
79 Posts |
Posted - 2010-05-24 : 17:03:46
|
My DB is around 2 gigs, and will stay at that size.The Recovery model was set to FULL, but i read to change it to Simple. I dont need to recover this data, i only use it as a temporary holding place... with a few tables that have data...Will setting it to simple, have this error come up again?I have 19+ gigs free on C drive.I dont ever backup the transaction log.quote: Originally posted by tkizer What recovery model are you using for the database? If it's not SIMPLE, then how often are you backing up the transaction log? How much disk space do you have free on the drive where the transaction log exists?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-05-24 : 17:30:15
|
Once you change it to SIMPLE recovery model, it should be fine. You may need to shrink down the ldf file now though as it probably grew to a large size. For a 2GB data file, you have an ldf around 500MB. The error could happen again if you run a long-running transaction and the the ldf file isn't able to keep expanding to accommodate it due to our a growth restriction or disk space issue.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
zstarsales04
Starting Member
20 Posts |
Posted - 2010-05-25 : 02:27:01
|
spam removed |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-05-25 : 03:27:29
|
Take a look through this article - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
|
|
|
|
|