January 6, 2009 at 1:17 am
Haii
I need help for the following question.i am having a production database,daily backup scheduled at 6 pm.its a 24 hr working scenerio.after few hours the database crash.i am having the back up of last day and trascation of 5 hour are not backed up.so is it posible to restore those transactions missed
January 6, 2009 at 2:07 am
You need to decide how much data you can afford to loose and according to that decide on your backup policy. Depending on the requirements you can use other types of backups such as differential or log transaction with the full backup. I suggest that you’ll read at BOL about the backup types, so you’ll be able to plan your backup policy in a better way. You’ll might want to start with this page - ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/09a6e0c2-d8fd-453f-9aac-4ff24a97dc1f.htm
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 6, 2009 at 2:09 am
What is the recovery mode of your database? Is your database accessible?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 6, 2009 at 2:14 am
Recovery mode is full and database is accesable .only thing i mising those transactioins.is it posible?\
January 6, 2009 at 3:40 am
If your DB is in Full and is accessible, it sounds like what you need to do is to perform a tail log backup - ie run a transaction log backup on the DB in question. That will capture the transactions since the last backup. Once you have that, restore your full/differential backups WITH NORECOVERY then restore the log backups WITH NORECOVERY until you get to the tail log backup, which you should restore WITH RECOVERY. Before you do anything, read up in BOL for details specific to your scenario. A search on Tail-Log Backup might be a good place to start. If you're unsure, restore the database under a different name to check you have the process right.
Hope that helps
Cath
January 6, 2009 at 7:14 am
Is the database in full recovery?
Do you have regular transaction logs?
Can you do a final log backup before you restore the backup?
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply