Skip to main content

Mssql database backup restore script

USE [master]
RESTORE DATABASE [Algeria]

FROM DISK = N'C:\db\db\Algeria_FULL_05282021_131711.BAK' WITH FILE = 1,

MOVE N'Algeria' TO N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\Algeria.mdf',

MOVE N'Algeria_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\Algeria_log.ldf',

NOUNLOAD,
REPLACE,
STATS = 5;

Thank you!