• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

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.
0
tfgeorge
Asked:
tfgeorge
1 Solution
 
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
Hi you should have full data base backup copy and all transaction log file.

First you need to Restore full database and then reatore transaction log file.




0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
how did you backup? as far as I can see you don't have the good backups to restore to the point in time...
0
 
SireesCommented:
You need to have a transaction log backup to restore to point in timw
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
tfgeorgeAuthor Commented:
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?
0
 
ptjcbCommented:
Only if you have transaction log backups from the 13 Jan date. How often do you save transaction logs?
0
 
tfgeorgeAuthor Commented:
I have One copy of the transaction log, and it has never been truncated.
0
 
ptjcbCommented:
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.

0
 
tfgeorgeAuthor Commented:
lumigent log explorer is what does it...
0
 
ee_ai_constructCommented:
PAQ / Refund
ee_ai_construct, CS Moderator
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now