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