Simple restore database to same server on same disk configuration.

-- Database Backup File Info
RESTORE FILELISTONLY  
   FROM DISK = 'D:\DatabaseBackups\MyDB_Full.bak' 

RESTORE DATABASE [MtDB] FROM DISK = 'D:\DatabaseBackups\MyDB_Full.bak'  
WITH FILE = 1, REPLACE, maxtransfersize = 4194302, buffercount = 96, stats = 5
Last modified: September 27, 2021

Author

Comments

Write a Reply or Comment