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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 The transaction log for database

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2010-07-28 : 15:59:10
Hi,
my database is in simple recovery model, but jobs are getting failed with the error The transaction log for database. how can i resolve this....

thanks in advance

Arnav
Even you learn 1%, Learn it with 100% confidence.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-28 : 16:03:54
You can't backup the transaction log for a database using SIMPLE recovery model. Fix your SQL job so that it excludes SIMPLE recovery model databases for your transaction log backups.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-07-28 : 16:26:37
What's the full error?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2010-07-28 : 16:28:07
due to space crunch, there is no space for logfile to growth. i troubleshooted and fixed. thanks a lot

Arnav
Even you learn 1%, Learn it with 100% confidence.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-28 : 17:05:02
Oh! I misunderstood your post as you didn't post the full error.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -