Category Archives: Database Migration

How to: Restore Database Backup Using SQL Script (T-SQL)

Besides using the GUI to restore your database, you can try using T-SQL scripts to restore your database from your logical disk.

RESTORE DATABASE [YourDatabaseName]
FROM DISK = 'D:\YourDBFullBackupFile.bak'
WITH STATS = 10

I come across another method from SQLAuthority.com.

RESTORE FILELISTONLY
FROM DISK = 'D:\YourDBFullBackupFile.bak'