RESTORE DATABASE [Monitoring_Agency]
FROM DISK = N'D:\Monitoring_Agency.bak'
WITH FILE = 1,
MOVE N'Monitoring_Agency'
TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Monitoring_Agency.mdf',
MOVE N'Monitoring_Agency_Log'
TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Monitoring_Agency.ldf',
NOUNLOAD, REPLACE, STATS = 10
GO
FROM DISK = N'D:\Monitoring_Agency.bak'
WITH FILE = 1,
MOVE N'Monitoring_Agency'
TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Monitoring_Agency.mdf',
MOVE N'Monitoring_Agency_Log'
TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Monitoring_Agency.ldf',
NOUNLOAD, REPLACE, STATS = 10
GO