SQL2K: Typical Running Job at Your DB

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL2K: Typical Running Job at Your DB

Author

Topic

dewacorp.alliances

452 Posts

Posted - 2006-08-25 : 08:57:34

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.

nr
SQLTeam MVY

12543 Posts

Posted - 2006-08-26 : 16:53:07

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.

dewacorp.alliances

452 Posts

Posted - 2006-08-28 : 17:56:12

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

nr
SQLTeam MVY

12543 Posts

Posted - 2006-08-28 : 19:30:50

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources