Create Database from MS-SQL Backup File
1.Create Database from SSMS
2.Restore Database.
Tick this field.
Script for restore database.
RESTORE DATABASE [DBFRMBAK] FROM
DISK = N'@@\Empower.Bak' WITH FILE = 1,
MOVE N'OLDDBNAME' TO N'@@\DBFRMBAK.mdf',
MOVE N'OLDDBNAME_log' TO N'@@\DBFRMBAK.ldf',
NOUNLOAD, REPLACE, STATS = 10
GO
Good to know about ms-sql backup file.
ReplyDeleteMicrosoft Access to SQL Server Migration