![]() ![]() Select OK to close the Select backup devices dialog box. Select Device:, and then select the ellipses (.) to locate your backup file. Right-click the Databases node in Object Explorer and select Restore Database. To restore your database, follow these steps: To read more about the different backup options, see BACKUP (Transact-SQL). NAME = N'SQLTestDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\SQLTestDB.bak' The path may be different on your computer: USE
0 Comments
Leave a Reply. |