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 |
|
ay2k_99
Starting Member
22 Posts |
 Posted - 2008-06-04 : 08:21:24
|
| Dear All,I m using sql server 2000 with sp4. my database with the name of account which is having size of 16GB. my backup is schedule with the following manner...1. Backup the Full DB every Night at 12.00 AM.2. Transaction Log Backup is taken every 30 Min.3. My DB was crash with 3.46 PM.My 2nd Last Transaction log backup is taken 3.00 PM and other one is taken 3.30 PM. but i check restore verify 3.30 PM it is working. but my 3.00 PM transaction log was damage.My database was crashed down last night how could i recover with Point in time recovery. how could i recovery my latest backup.Kindly send me your feedback.Thanks,Amey |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-06-04 : 10:16:32
|
| Any idea on how was it damaged? Are you backing up across the network to a remote server? If it is damaged, the most current data you'll be able to retrieve is up to your 2:30PM log backup as the damaged backup broke the log chain. Retore your full backup with NORECOVERY, restore all tansaction log backups through 2:00Pm, also with NORECOVERY and finally your 2:30PM backup with RECOVERY (see BOL for syntax).Terry |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2008-06-04 : 13:36:41
|
| Yup - no way to fix a corrupt log backup.On 2005 it's possible to restore a corrupt log backup using WITH CONTINUE_AFTER_ERROR, and then run a full CHECKDB and repair - but that way usually creates inconsistencies in the database.ThanksPaul RandalSQL Server MVP, Managing Director, SQLskills.com |
|
|
|
surya_rakanta
Starting Member
19 Posts |
Posted - 2008-07-31 : 00:06:48
|
| 3. My DB was crash with 3.46 PM.-----------What error message when you try to attach those crashed MDF file ?Or What is the latest error message pertaining to this database when the SQL server is re-started ?This information is required as first step to identify the problem and fix the database.RgdsEka S.God didn't do this, Anna, WE did.— Robert Neville in I am Legend. |
|
|
|
|
|
|
Transaction Log .....