070-8260-2526

ÆòÀÏ ¿ÀÀü 9½Ã ~ ¿ÀÈÄ 6½Ã
´ÜÀ§³óÇù

352-0331-1626-83

¿¹±ÝÁÖ:°­¸¸¼öÅ×Å©³ÝÄÚ¸®¾Æ


ÀÚÁÖ¹¯´Â Áú¹®
Ȩ > °í°´¼¾ÅÍ > ÀÚÁÖ¹¯´Â Áú¹®

Á¶È¸¼ö 8197
Áú¹® msSQL ¹é¾÷µ¥ÀÌÅÍ º¹¿ø½Ã Äõ¸®¹®
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