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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-08-15 : 22:15:22
|
| Naroor Rathish writes "hi, guys i am working on a e-governance project. we have large amount of data to be managaed and daily data upation is very high. and now i am trying to find a technique to perform data backups acoording to the size of the database.So may i know that whether we can perform backups when a desired or fixed database size has been reached and also it must be done automaticaly thru the application(i mean software). i think u guys can help me out to find me a good solution. If any body can forward me some links it will also be helpful to me.thanx,Naroor Rathish." |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2004-08-15 : 23:22:16
|
| Amazing what SOX does for DR.http://www.microsoft.com/sql/techinfo/administration/2000/availability.asp |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-16 : 00:45:50
|
| http://weblogs.sqlteam.com/taradYou could easily modify her scripts. Have a job that that check the database size every hour or so. When it reaches a certain size, it kicks off a backup. I would create a table that hold DB name, size, and datetime so you can track historically also. You really don't need an application to do this for you, just as an fyi. It's not that difficult to accomplish with scripts and a job.One question, you are backing up every night and doing regular transaction log backups aren't you??? If so, why do you also need the backup when the size reaches a certain point. I don't understand how this could possibly translate into a useful backup point.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
DB Backups