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 |
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-08-23 : 06:45:10
|
Hi,I have set the back up to overwrite and schedule it for daily run at mid night using enterprise manager.BUT when checking the scheduler again it always seems to be set to append and there are no time schedules that I set previously.Do you know why my schedules are not being set?Thanks |
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-23 : 08:44:31
|
You can look at the jobs in Enterprise Manager and see when the Maintenance plans have been scheduled, if they are enabled, and the last time they ran. If you right-click on the job, you can also see the job history. You might want to consider using scripts for backups, maintenance, etc instead of the maintenance plans. Take a look at the scripts Tara has: http://weblogs.sqlteam.com/tarad . This gives you more ability to troubleshoot and customize.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
buddyprav
Starting Member
1 Post |
Posted - 2004-08-28 : 08:43:37
|
hi, im struggling with the same problem. so help me.plz gimme solution for backup scheduler.or mail me at email: praveen_alam@yahoo.com |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-08-28 : 11:42:41
|
If you just want to overwrite every time then code it yourself - it's just a backup statement.I would advise keeping a few copies though - I try to keep the last three.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-30 : 08:16:27
|
You have to set your scehdules in the Maintenance plans if you are using maintenance plans. If not, look at Tara's blog. Schedule the backups statements she has there like Nigel said. It's not that hard. If you actually try it and need help, let us know.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|