SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backup
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 08/23/2004 :  06:45:10  Show Profile  Reply with Quote
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

USA
4184 Posts

Posted - 08/23/2004 :  08:44:31  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message  Reply with Quote
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.

MeanOldDBA
derrickleggett@hotmail.com

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

buddyprav
Starting Member

1 Posts

Posted - 08/28/2004 :  08:43:37  Show Profile  Send buddyprav a Yahoo! Message  Reply with Quote
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
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 08/28/2004 :  11:42:41  Show Profile  Visit nr's Homepage  Reply with Quote
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.
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

USA
4184 Posts

Posted - 08/30/2004 :  08:16:27  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message  Reply with Quote
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.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000