SQL Server Performance Forum – Threads Archive

DATABASE RESTORE FROM LOG FILE

Hi guys, Is there a way in SQL to restore DATABASE from a LOG file, assuming that my Recovery model is full.
I know that is can be done using some 3rd party tools, but is there a way to do it in SQL[?] AKTHAR DILMOHAMUD
65 BENARES ST
PORT LOUIS
MAURITIUS

---

If the last database backup is continued you can perform log backups WITH NORECOVERY clause and for last set of backup WITH RECOVERY to get back the data. BOL is your friend. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

Agree satya, but given that i am running a FULL recovery model, do i really need a backup of log file to restore my data, Is there a way of doing it without a former backup…. AKTHAR DILMOHAMUD
65 BENARES ST
PORT LOUIS
MAURITIUS

---

i think there is no other way ……….. krishna chaitanya sanka
project engineer-SQLDBA ‘TO IMPROVE IS TO CHANGE….TO BE PERFECT IS TO CHANGE OFTEN!!!!

---

i think there is no other way ……….. krishna chaitanya sanka
project engineer-SQLDBA ‘TO IMPROVE IS TO CHANGE….TO BE PERFECT IS TO CHANGE OFTEN!!!!

---

You need the log file to recover to a point in time or the point of failure. AFAIK, you don’t need the log file to restore to the last full backup. If you don’t have a backup of the mdf file, what would you want to restore? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

---

Full Recovery provides the ability to recover the database to the point of failure or to a specific point in time. In between if the BACKUP LOG or CHECPOINT is issued the transactions are written to the file which is need if you want to restore from good known backup in the order. HTH
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>