0

Suppose I want to restore a database in such circumstances: from one side there is no backup, from the other side - all the changes are stored in the log file. Can I restore the database from the log file to a specific date & time?

Geri Reshef
  • 397
  • 1
  • 6
  • 17

1 Answers1

1

You are talking about point in time recovery

for that you first need a full backup at least then if you take t-log backup you can restore. without full backup nothing possible

kleopatra
  • 51,061
  • 28
  • 99
  • 211
Saurabh Sinha
  • 1,363
  • 1
  • 9
  • 11