Table of Contents

Microsoft SQL Database Restore

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-backup-using-ssms

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-transaction-log-backup-sql-server

Ahsay or Other Backup Software

Restore the database and transaction log files for the point in time you want to restore.

Restore the files to a temporary local disk drive location, suck as C:\Temp.

MSSQL Management Studio

We'll use Microsoft SQL Server Management Studio to restore the database.

Select the backup files in the temporary disk location

In MSSMS, connect to the server instance In the Options tab, we select to overwrite the database in this case