Restore a differential database backup

Owned by Knowledge Assistant
Mar 15, 2023
1 min read



Description of Issue

How to restore a differential backup in SQL Server?



Context

  • SQL Server Management Studio (SSMS)

  • Differential

  • Restore

  • Tyler System Management (TSM)



Cause

Need to restore full database backup and a differential database backup



Resolution

  1. Login to the database server

  2. Sign into Microsoft SQL Server Management Studio (SSMS) with the specific server name

  3. Navigate to the Object Explorer on the left right

    1. Right Click Databases 

    2. Click Restore Database...

    3. Under Source select the Device 

    4. Click the ... to the right

    5. Click Add to see the database backups within the default backup folder (or browse to a specific folder as needed)

    6. Click the full database backup (IE: <database.bak>) to be restored

    7. Click OK

    8. Click Add to see the database backups within the default backup folder (or browse to a specific folder as needed)

    9. Click the differential database backup (IE: <database.bak>) to be restored

    10. If restoring backups from a different server:

      1. Under Select a page, click Options

      2. Check the box  Overwrite the existing database (WITH REPLACE)

      3. Check the box Close existing connections to destination database

    11. Click OK

  4. The newly restored database should populate under the Databases folder

Tyler Hosted Clients do not have access to their servers and will need to contact TSM Support to restore the database.



Additional Information