Job was failed,even I have more space in Disk

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

SQL Server 2000 Forums

SQL Server Administration (2000)

Job was failed,even I have more space in Disk

Author

Topic

nivas_kt
Starting Member

3 Posts

Posted - 2007-07-21 : 03:27:11

Hi all

I have a Job which is ment for backup while it running job
it throw a error(alert)Transaction log full,
I check the trasaction option Autogrow is ON and I check the
Diskspace that having suffecient space

some body help me regarding this

Thanks in Advance

Thanks&Regards
Nivas_kt

nivas_kt
Starting Member

3 Posts

Posted - 2007-07-21 : 11:08:12

Hi all

I have a Job scheduled to take backup every day night,yester day job thow error saying is that 'Transaction log full' .

Please some one help me regarding the same

thanks in Advance

Thanks&Regards
Nivas_kt

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-21 : 12:22:52

Which db's log is full? Is msdb? Check sql server log for detailed reason.

sqldba_ind
Starting Member

22 Posts

Posted - 2007-07-23 : 12:02:36

I don't that is MSDB, by default MSDB having Simple recovery model,
so that transaction log back up not possible.

http://support.microsoft.com/default.aspx/kb/303229

Thanks&Regards
srini

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-23 : 13:54:24

Log of msdb can be full due to many reason. If that's the case, you'll get error from backup job since sql can't update msdb for job status.

sqldba_ind
Starting Member

22 Posts

Posted - 2007-07-24 : 04:30:10

Hi

Thanks rmina,
if this is the case,what is the action we have to take immeditaly.

But still i have a dout since MSDB in Simple recovery model,
it always truncate the trasaction file

Thanks&Regards
srini

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-24 : 14:54:05

Check log usage for involved dbs in em, expand it if needed.

NeilG
Aged Yak Warrior

530 Posts

Posted - 2007-07-24 : 15:25:22

What recovery model are you using on the db and when was the last time you did just a transaction log backup.

nivas_kt
Starting Member

3 Posts

Posted - 2007-07-25 : 05:44:27

Hi NeilG

I have a production Database and I have a scheduled job(hourly configured) which is taking backups(Transaction log),

My schedules like this below
1.Every day morning full backup and every hour transaction log backup.

at 1PM Job was failed error sysing is that Transaction log was full...
so,that i checked option database ,Options are like this
1.auto grow ON
2.percentage 10

i cheked Disk diskspace --- space is available

please give me suggestion

Thanks&Regards
Nivas_kt

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-25 : 11:18:49

Can you post complete error message here? What does sql server log say?

donpolix
Yak Posting Veteran

97 Posts

Posted - 2007-07-30 : 00:53:57

You were able to check filegrowth of your tlog, but how about MAXSIZE?

Donn Policarpio

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources