top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How to restore the SQL server database without log backup?

+2 votes
86 views

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
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...