SQL Server 2000 backup list

[mot98]

Hi All,

I am running a SQL Server 2000 here, and am trying to find out where it lists all the backups that have been scheduled.

I need to know what has already been scheduled and keep a list of it.

Thanks for any help...

mot98

"I'd rather be dead and cool..then alive and uncool."
---Harley Davidson & The Marlboro Man

 

[JayKusch]

Is the backup a scheduled job or is it done manually?

Thanks

J. Kusch

 

[SQLBill]

In Enterprise Manager, drill down to Management.

First select Database Maintenance Plans.
is there anything listed there? If so, click on it and select Properties, then review it. It will also be shown in the JOBS section (see next)

Then, find SQL Server Agent (also under Management), expand it and you'll see Jobs. Click on that and you will see all the scheduled jobs including Maintenance Plan Jobs. Double click on any of the jobs and you'll be able to see what the job does and when it does it.

-SQLBill

 

[JayKusch]

If it is a job then ...


USE msdb

EXEC sp_help_jobhistory @job_name = 'JobNameHere'




Thanks

J. Kusch