How to restore data from mdf file?

  • 1
  • Question
  • Updated 5 years ago
There was a failure of the system how to restore .mdf file in sql server 2005 how to fix?
Photo of Ahag Nybiym

Ahag Nybiym

  • 2 Posts
  • 0 Reply Likes

Posted 5 years ago

  • 1
Photo of M3 Sweatt

M3 Sweatt, Official Rep

  • 203 Posts
  • 18 Reply Likes
Photo of billrigth

billrigth

  • 2 Posts
  • 0 Reply Likes
Data changes are guaranteed to be written to the transaction log, but the data pages may still be held in cache. If every transaction had to write affected pages to disk on commit, the disk throughput and cache turnover would be so high that the database would be very slow indeed. The fact that the transaction changes are recorded in the transaction log means that a transaction can always be rolled back if necessary, even if the server crashes. This is why the transaction log is always scanned for transaction to be rolled back / rolled forward on server startup before a database is brought online. You may try read thes, it is a professional data recovery software. Here is page:  http://www.sqlserver.restoretools.com/