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 2005 Forums
 SQL Server Administration (2005)
 Backup Jobs

Author  Topic 

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-09-11 : 09:16:17
I have back up job and for some reason when i click this to start i cannot see the processes running and the backups are not being generated. I looked in activity, running processese i cannot see this running.

Any suggestions.

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2008-09-11 : 11:31:37
Is the job enabled? What does the job history show?
Go to Top of Page

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-09-11 : 12:23:29
Job not ran for a day or so ....but cannot any message it does not report anyting in here if failing - can't see if in activity its old if i ran manually the job it just sits there for ever with executing and i see nothing running or the backup started.
Yes enabled.
Go to Top of Page

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-09-11 : 13:27:50
Reboot fixed it
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-11 : 13:45:59
Let me guess, you are using a database maintenance plan and not custom code?

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

Subscribe to my blog
Go to Top of Page

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-09-11 : 13:52:00
Yes shame on me for not writing my own custom backups.....was just about to do it...but the maintenance plan was working.

That was my next step to rewrite it:
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-11 : 13:53:00
Why bother writing your own when I've already done the hard work:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

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 -