DB Server Setup and Backup/Recovery strategy

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)

DB Server Setup and Backup/Recovery strategy

Author

Topic

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2006-07-05 : 16:43:22

Guys,

We are planning DB environment for 24/7 database. Basically the DB would be subjected to whole lot of DML operations and batch jobs (planning to have a batch job which inserts 12 million rows at each instance during the day).

Can you suggest what would be the best database mirroring strategy interms of RAID and partitioning

Also what would be the best backup and recovery strategy - currently we are planning to a complete backup once a week and transaction log backup every hour. Is this a good strategy

Any comments/suggestions would be helpful

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-05 : 16:46:41

It depends.

Our databases are mission critical. We perform full backups every day and transaction log backups every 15 minutes. We cluster the servers at our primary site. We then log ship our databases to our disaster recovery site (located about 300 miles away), where a second cluster exists.

Tara Kizer
aka tduggan

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2006-07-05 : 16:57:06

tkizer,

since our system is going to be 24/7, dont you think the system will slow down when there is full backup going on.

Also what is the recommendation for the database mirroring in case of the a disk failure.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-05 : 16:59:29

quote:
Originally posted by scelamko

tkizer,

since our system is going to be 24/7, dont you think the system will slow down when there is full backup going on.

Also what is the recommendation for the database mirroring in case of the a disk failure.

Thanks

Our system doesn't slow down during backups. We have very fast disks in place.

I'll let someone else comment on your mirroring question as I'm not a disk person.

Tara Kizer
aka tduggan

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2006-07-05 : 17:06:25

tkizer,

When you sya very fast disks is it the SAN disks that you guys are using??

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-05 : 17:09:05

Yes. We are using HP's EVA solution.

Tara Kizer
aka tduggan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources