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.
| Author |
Topic |
|
ftsupport
Starting Member
3 Posts |
 Posted - 2006-08-16 : 01:46:56
|
| HI,i believe i have setup SQL Server 2000 to take scheduled backups every month. However, I can't find where i can check to make sure i have done this correctly, as when I return to the backup database option, all the previous information has disappeared. Is there a way to view what scheduled backups are due to take place? I need be sure that i have done it correctly. |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-08-16 : 02:30:59
|
| EM->Management -> SQL agent-> Jobs -> select any job and check the NEXT RUN DATE There will a be system table also, but no idea.------------------------I think, therefore I am - Rene Descartes |
 |
|
|
ftsupport
Starting Member
3 Posts |
Posted - 2006-08-16 : 03:03:10
|
| i can't seem to find where this is possible. Am i supposed to do this using Enterprise Manager? There doesn't appear to be a Management button/option/menu item etc. |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-08-16 : 10:06:53
|
quote:
Originally posted by ftsupport
Am i supposed to do this using Enterprise Manager?
Yes, EM = Enterprise Managerquote:
Originally posted by ftsupport
There doesn't appear to be a Management button/option/menu item etc.
Then tell what u c in the tree kind of list in the left pane of EM, once u expand Console Root --> Microsoft SQL Servers --> <Ur Server> ---> <<<Expand>>>Srinika |
|
|
|
ftsupport
Starting Member
3 Posts |
Posted - 2006-08-16 : 18:52:35
|
| found it. beautiful. thanks very much for your help. |
|
|
|
|
|
|
Scheduling backups