top button
Flag Notify
Site Registration

How to restore the SQL server database without log backup?

+2 votes

We have full backup and no log backup can I restore the database?

posted Oct 12, 2013 by Karri Satyanarayana Naidu

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

I hope I understood your question correctly -

When you BACKUP DATABASE, you backup data pages from the data files (MDF and NDFs), not the file(s). The engine then appends any changes (from the log entries) that happened during the backup.

When you restore the DB, then it recreates the files on disk. The log file itself is absolutely essential to how all RDBMSes work.

answer Oct 12, 2013 by Deepankar Dubey