writing styles how to write good college essays formal lab report sample writing a memoir essay sample powerpoint presentation help with business plan

Ahsay restore Microsoft SQL (MSSQL) server database

If you want to restore a Microsoft SQL database, from a fuld backup, and put some transaction log file into it.  (This backup has backup by ahsay)

This is the why to do it:

  1. Start Microsoft SQL Server Management Studio
  2. Right click on Databases, and select restore database

  3. Type a database “To database”, and select from device , and press the butten with the 3 dots (…)

  4. Select file, and then click Add

  5. Select the database file you want to restore, and click ok

  6. Then select options, and click “Leave the database non-operational, and do not roll back uncommitted transactions. (Restore with NORECOVERY), then click OK
  7. Start a new query, and type this (Change it to yours database and files).
  8. RESTORE LOG RestoreTest
    FROM DISK = ‘F:\RestoreTest\2011-09-13(09-00-00)_LOG_RestoreTest_2011.bak’
    FROM DISK = ‘F:\RestoreTest\2011-09-13(10-00-00)_LOG_RestoreTest_2011.bak’

    RESTORE LOG Farma_test
    FROM DISK = ‘F:\RestoreTest\2011-09-13(11-00-00)_LOG_RestoreTest_2011.bak’

    RESTORE LOG Farma_test
    FROM DISK = ‘F:\RestoreTest\2011-09-13(12-00-00)_RestoreTest_2011.bak’

  9. When you have takende the sekund last backup file, just type this:
  10. RESTORE LOG Farma_test
    FROM DISK = ‘F:\RestoreTest\2011-09-13(13-00-00)_RestoreTest_2011.bak’
Share this:
Share this page via Email Share this page via Stumble Upon Share this page via Digg this Share this page via Facebook Share this page via Twitter

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *