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)
 Scheduled Backup

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-24 : 07:29:50
Krishna writes "I HAVE INSTALLED SQL SERVER 7.0 IN WINDOWS 2000 SERVER MACHINE.I HAVE SCHEDULED A DAILY BACKUP.
PROBLEM I FACE IS THAT , SOME DAYS BACKUP IS NOT HAPPENING WHAT COULD BE THE REASON AND HOW DO I SOLVE?"

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2004-06-24 : 07:49:38
could be any number of reasons - space, etc. etc.

Check the job history, detailed steps:

EM --> your Server --> MANAGEMENT --> SQL SERVER AGENT --> JOBS --> right click you job in right window. Tick on show detailed steps.


*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-06-24 : 09:53:42
What error message are you getting?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -