How to see if a specific DB has a schedule backup

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)

How to see if a specific DB has a schedule backup

Author

Topic

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2007-08-01 : 14:09:45

All,

Using enterprise manager I need to findout if a particular Database has a backup scheduled or not?

How can I check this using enterprise manager?

Can somone please list the steps?

Looking for a quick reply.

Thanks a million in adavance.

Zee

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-01 : 14:29:33

Check scheduled job under sql server agent and maintenance plan.

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2007-08-01 : 14:43:23

In SQL server 2000 enterprise manager, under "Managment" under "Sql Server Agen" the "Jobs" is empty.
Why is that?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-08-01 : 14:48:34

It's empty because you don't have any jobs. Are you a sysadmin for this server?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2007-08-01 : 15:49:21

No I am not a sysadmin.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-08-01 : 15:56:29

Then perhaps you can't see the jobs due to permissions. Talk to your DBA to see what is there.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2007-08-01 : 15:57:10

Ok. Thanks for your help.

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2007-08-01 : 15:58:07

BTW doesn't the following tells you if you have a schedule backup?

use msdb
Select * from sysjobhistory

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-08-01 : 16:10:29

msdb.dbo.sysjobs
msdb.dbo.sysjobschedules

Are these all empty?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2007-08-01 : 17:03:38

Yes...they all are empty. SO what does that mean? Does it mean that no backup is scheduled?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-08-01 : 17:10:18

It means you have no jobs setup. It's possible that your sysadmin has it scheduled in another tool. Can't you just contact them to find out what they have in place and where?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2007-08-02 : 10:09:47

Thanks for your help :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources