db 복원퀴리 소스

USE master
GO
ALTER DATABASE dental SET SINGLE_USER WITH ROLLBACK IMMEDIATE; -- 사용자의연결을끊습니다.
-- 복구(새로운이름의데이터베이스로복원합니다.)
RESTORE DATABASE dental
FROM DISK='C:/Program Files/Microsoft SQL Server/MSSQL10.MSSQLSERVER/MSSQL/Backup/dental_backup_2014_11_18_good.bak'
WITH RECOVERY,
move 'dental_Data' TO 'C:/Program Files/Microsoft SQL Server/MSSQL10.MSSQLSERVER/MSSQL/Data/cyberpr_Data.MDF',
move 'dental_Log' TO 'C:/Program Files/Microsoft SQL Server/MSSQL10.MSSQLSERVER/MSSQL/Data/cyberpr_Log.LDF',
REPLACE
GO
ALTER DATABASE dental SET MULTI_USER