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 |
|
bab_ganesh
Starting Member
4 Posts |
 Posted - 2011-11-12 : 07:44:41
|
| Hi Experts,We have a production database with 200GB of data and increasing 100+MB per day. We are taking backup daily and planning to take backup every 15 min (transaction log).In the web all are saying the DB damage and failover. But I want to know exactly what are all the possible damages and failover for the huge database other than out of memory.Enviroment:SQL Server 2008MS Windows 2008Ganesh. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-11-12 : 08:19:45
|
| Database corruption, hardware failures, server failures, accidental drop of DB, etc.Out of memory is not a failure--Gail ShawSQL Server MVP |
 |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2011-11-16 : 11:49:03
|
Also..Fire, Earthquakes, and acts of god. |
|
|
|
|
|
|
What are all the Database damages & failures?