July 28, 2008 at 9:06 am
How to estimate database recovery time in sql 2005.
July 28, 2008 at 9:51 am
Can you explain what you are trying to do or what your scenario is?
This seems like an interview or test question. Please show some effort to work on the problem yourself. We are happy to help, but do not want to do all work for you.
July 28, 2008 at 10:08 am
balbirsinghsodhi (7/28/2008)
How to estimate database recovery time in sql 2005.
How long is a piece of string?
Without a lot, lot more info, there's no way to say. I've had everything from 30 sec to 13 hours.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 10:38 am
The reason I am asking because last time one of our Databse was in Recovery mode starting from Saturday and finished recovery on Monday evening at 11 PM. Data should be available on Monday morning to users at any cost and it did not recovered Monday morning.
Networking Manager said that if I would have told them about the estimation of recovery plan than there would not be any delay restoring the database from tape backup and user will get the data monday morning so there was little bit conflict between me and Networking manager.
So networking guys were saying if they know the estimation time of database recovery than they will decide if they go for tape bacup or not.
July 28, 2008 at 10:43 am
That's far too long.
How big's the DB, how active and what is your storage system?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 28, 2008 at 10:52 am
We have approx 2 Tera byte of data storage in one databse.
Here is the server configuration.
Itanium 2
1.60 GHz, 32 GB of Ram
We have created lots of partition tables in our database for performance purpose and also using sliding windows technology in our database for archiving old data in archive table.
I started using Hyperbac software to backup this huge database and it is working pretty good. the compression rate is 75% which great.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply