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


1 comment:

Dear User,

Thank you very much for your kind response