Embedded Files
SSMS => Right click destination database => Tasks => Take Offline
Find the location of database backup and latest full backup (BAK)
SSMS => New Query => Do restore with following script (notice: this example restore is done from prod to test)
RESTORE DATABASE SomecityTest FROM DISK='I:\SQLBackup\SomecityProd\SomecityProd_backup_2021_08_09_190001_2760309.bak'
WITH
MOVE 'SomecityProd' TO 'F:\SQLData\SomecityTest.mdf',
MOVE 'SomecityProd_log' TO 'G:\SQLData\SomecityTest_log.ldf',
REPLACE
SSMS => Right click destination database => Tasks => Take Online
Page updated
Google Sites
Report abuse