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 |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2003-11-03 : 03:47:52
|
| Hi,I have taken full backup at 12.00a.m,transaction log at 1.00am.But the system fails at 1.45a.m.HOw do i recovery the data from 1.00a.m to 1.45a.m.(I have simulated the question to learn)I want to know state of server in this kind of a situation and steps taken by the DBA to recovery the data.If the experts could share there real time experience, it would great.thanx. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-11-03 : 05:43:03
|
| seeHow to restore to the point of failure (Transact-SQL)in bol==========================================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. |
 |
|
|
purisqlserver
Yak Posting Veteran
73 Posts |
Posted - 2003-11-03 : 06:50:35
|
| thanx for the reply, i have few more questions for the same.I read BOL for recovering, this is wht it says:Create a backup of the currently active transaction log.1)wht if we are not able to restart sqlserver on the system after sytem failure. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-03 : 15:43:13
|
| Do you mean that the service won't start? If so, then you'd need to figure out why by checking in the Event Viewer's Application Log.Tara |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-03 : 15:44:39
|
| For your first question, you'd need to have a backup after 1:45am in order to restore to a point in time. The 1:00am transaction log will only help you get to 1:00am. You need one past 1:45am to get the rest of the data. With the information given though, you couldn't get the data between 1:00am and 1:45am unless the system was still available. If it were, then you would immediately backup the last transaction log.Tara |
|
|
|
|
|
|
sytem failure-recovery