Virtual Architects Support Wiki

User Tools

Site Tools

You are here: start » computing » windows » mssql_restore
Trace: • mssql_restore
computing:windows:mssql_restore

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

computing/windows/mssql_restore.txt · Last modified: 2018/07/24 09:01 by gcooper

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki