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)
 SQL2K: Typical Running Job at Your DB
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dewacorp.alliances
Constraint Violating Yak Guru

Australia
452 Posts

Posted - 08/25/2006 :  08:57:34  Show Profile  Visit dewacorp.alliances's Homepage  Click to see dewacorp.alliances's MSN Messenger address  Reply with Quote
Hi there

Would you mind to share with me what is typical job that you guys running as day to day db maintenance. I am trying to comparing with ours.

Here's what we configure so far in SQL:
1. Secondary DB Backup to File Server (primary is done through Veritas NetBackup) - every night
2. Primary Transaction Log to File Server - every hour. (sometimes depending on the database .. normally we used Veritas NetBackup)
3. Integrity Check - Saturday midnight
4. Optimazation (Reorganizes data and index pages AND Remove Unused space from database files) - Saturday midnight
5. Usage Update - wednesday night
6. Cycle Error Log - Sunday midnight

Those jobs (1-5) were associate with each user database while System databases is combined into for each job.

BTW ... we did this through Database Mainteanance Plan. We are thinking to move to script instead which I believe is more control.

Thanks for sharing.

Edited by - dewacorp.alliances on 08/25/2006 11:43:14

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 08/26/2006 :  16:53:07  Show Profile  Visit nr's Homepage  Reply with Quote
Depends on the system.
I have a client at the moment where there are no backups or integrity checks - and that's fine for their system.
Have another with daily full backups, diffs throughout the day and log evey 10 mins. All full backups restored to another server and integrity checked.

It's up to a dba to decide what's needed for the business (should be part of a business continuity plan) - you can't generalise.

==========================================
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

dewacorp.alliances
Constraint Violating Yak Guru

Australia
452 Posts

Posted - 08/28/2006 :  17:56:12  Show Profile  Visit dewacorp.alliances's Homepage  Click to see dewacorp.alliances's MSN Messenger address  Reply with Quote
quote:
Originally posted by nr

DHave another with daily full backups, diffs throughout the day and log evey 10 mins. All full backups restored to another server and integrity checked.



Hi nr. You mentioned about "All full backups restored to another server". So you have a job as well for restore on the other server so it's some sort of Database Shipping ... correct?

Thanks
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 08/28/2006 :  19:30:50  Show Profile  Visit nr's Homepage  Reply with Quote
Yep.
Backup
copy
restore

I use the same sort of thing for doing log shipping as well.
see
http://www.nigelrivett.net/SQLAdmin/s_TestRestore.html
http://www.nigelrivett.net/SQLAdmin/s_RestoreLatestBackup.html
http://www.nigelrivett.net/SQLAdmin/s_RestoreDatabase.html
http://www.nigelrivett.net/SQLAdmin/LogShipping.html

==========================================
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
  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.08 seconds. Powered By: Snitz Forums 2000