070-8260-2526

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

352-0331-1626-83

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


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

Á¶È¸¼ö 7232
Áú¹® ¹é¾÷ ÆÄÀÏÀ» ÀÌ¿ëÇÑ »õ·Î¿î À̸§ÀÇ µ¥ÀÌÅͺ£À̽º º¹¿ø
¹é¾÷ ÆÄÀÏÀ» ÀÌ¿ëÇÑ »õ·Î¿î À̸§ÀÇ µ¥ÀÌÅͺ£À̽º·Î º¹¿ø | MSSQL
 2011.01.02 18:56
     
¸»¸Ó¸®¾øÀ½
dongwoonseo
 
http://cafe.naver.com/softvil/90 
 
USE master
GO

-- ¹é¾÷ ¼¼Æ®ÀÇ Logical Name À» ±¸ÇÑ´Ù
RESTORE FILELISTONLY FROM DISK = 'E:mssql_backupbackup-20101112.bak'

-- ½Ì±ÛÀ¯Àú·Î ¼³Á¤ÇÏ¿© »ç¿ëÀÚÀÇ ¿¬°á ²÷±â
ALTER DATABASE user_dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

-- º¹±¸(»õ·Î¿î À̸§ÀÇ µ¥ÀÌÅͺ£À̽º·Î º¹¿ø, µ¥ÀÌÅͺ£À̽º ÀÚµ¿ »ý¼ºµÊ)
restore database user_dbname from disk='E:mssql_backupbackup-20101112.bak' with recovery,
move 'dbname' TO 'C:Program FilesMicrosoft SQL ServerMSSQL$SVSQLDatauser_dbname_DATA.MDF',
move 'dbname' TO 'C:Program FilesMicrosoft SQL ServerMSSQL$SVSQLDatauser_dbname_LOG.MDF',
REPLACE
GO

-- ¸ÖƼÀ¯Àú·Î º¹±¸
ALTER database user_dbname SET MULTI_USER
GO

-- µ¥ÀÌÅͺ£À̽º°¡ »ç¿ë ÁßÀ̾ ´Üµ¶À¸·Î ¾×¼¼½ºÇÒ ¼ö ¾ø½À´Ï´Ù. ´Â ½Ì±ÛÀ¯Àú ¼³Á¤À¸·Î ÇØ°áÇÔ

 

½ÇÇàÀº SQL ¸í·Éâ¿¡¼­ ÇÏ°í ¹é¾÷ÆÄÀÏÀÇ °æ·Î´Â ¼­¹ö»óÀÇ PATHÀÓ.
[Ãâó] ¹é¾÷ ÆÄÀÏÀ» ÀÌ¿ëÇÑ »õ·Î¿î À̸§ÀÇ µ¥ÀÌÅͺ£À̽º·Î º¹¿ø (½ÎÀÌÈĵå - (ÁÖ)¼ÒÇÁÆ®ºô) |ÀÛ¼ºÀÚ dongwoonseo