ȨÆäÀÌÁö
À¥È£½ºÆÃ
À¯Áöº¸¼ö
µµ¸ÞÀÎ(±âÁ¸)
µµ¸ÞÀÎ(½Å±Ô)
¹®ÀÇ/¿äû
Áö½ÄFAQ
»êµé¹Ù¶÷¸ô
070-8260-2526
ÆòÀÏ ¿ÀÀü 9½Ã ~ ¿ÀÈÄ 6½Ã
´ÜÀ§³óÇù
352-0331-1626-83
¿¹±ÝÁÖ:°¸¸¼öÅ×Å©³ÝÄÚ¸®¾Æ
ÀÚÁÖ¹¯´Â Áú¹®
Ȩ > °í°´¼¾ÅÍ > ÀÚÁÖ¹¯´Â Áú¹®
Á¶È¸¼ö
7388
Áú¹®
¹é¾÷ ÆÄÀÏÀ» ÀÌ¿ëÇÑ »õ·Î¿î À̸§ÀÇ µ¥ÀÌÅͺ£À̽º º¹¿ø
¹é¾÷ ÆÄÀÏÀ» ÀÌ¿ëÇÑ »õ·Î¿î À̸§ÀÇ µ¥ÀÌÅͺ£À̽º·Î º¹¿ø | 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
¿ø°ÝÁ¦¾î
ÀÚÁÖ¹¯´ÂÁú¹®
¿Â¶óÀλó´ã
°ßÀû¹®ÀÇ
»çÀÌÆ®¸Ê