Restore SQL 2000 Database from logs
A user deleted a SQL 2000 database on May 4th. My last valid database backup was Jan 13 and then I ran another one on May 5th. Is it possible to restore to a point in time on May 4th given what I have? We run Commvault. The actual data in the database has regularly working backup avalaible for the entire time period.
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
how did you backup? as far as I can see you don't have the good backups to restore to the point in time...
You need to have a transaction log backup to restore to point in timw
ASKER
Full SQL database backup on Jan 13th & May 4 with transaction logs on both. Is it possible to get a point in time between them?
Only if you have transaction log backups from the 13 Jan date. How often do you save transaction logs?
ASKER
I have One copy of the transaction log, and it has never been truncated.
Ok, it sounds as if we are talking about two different things. Let me review - you have a full backup 13 Jan. A full backup would have the transaction log and data. You have a full backup from 4 May or 5 May (I'm not sure which since you have mentioned both dates). You have a copy of the transaction log and it has never been truncated.
What do you mean by "a copy"? Do you mean that you have a copy of the .ldf file? Do you mean that you have a transaction log backup?
Do you have a regularly scheduled transaction log backup? If you do have regular transaction log backups do you have every one them from the 13 Jan full backup?
To do a restore to a specific moment in time you have to have a full backup (your 13 Jan) and then you must apply every transaction log backup from that date until you reach that moment.
You will not be able to do a restore to a specific moment if you only have a full backup. You will not be able to do a restore to a specific moment if you do not have transaction log backups.
What do you mean by "a copy"? Do you mean that you have a copy of the .ldf file? Do you mean that you have a transaction log backup?
Do you have a regularly scheduled transaction log backup? If you do have regular transaction log backups do you have every one them from the 13 Jan full backup?
To do a restore to a specific moment in time you have to have a full backup (your 13 Jan) and then you must apply every transaction log backup from that date until you reach that moment.
You will not be able to do a restore to a specific moment if you only have a full backup. You will not be able to do a restore to a specific moment if you do not have transaction log backups.
ASKER
lumigent log explorer is what does it...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
First you need to Restore full database and then reatore transaction log file.