±â¼ú ÀÚ·á: 2497528 - ¸¶Áö¸· °ËÅä: 2011³â 1¿ù 31ÀÏ ¿ù¿äÀÏ - ¼öÁ¤: 1.0

Step by Step: SQL Server ¿¡·¯ ·Î±× È®ÀÎ ¹× °ü¸® ¹æ¹ý

½Ã½ºÅÛ ÆÁº» ¹®¼­ÀÇ ³»¿ëÀº ±ÍÇϰ¡ »ç¿ëÇÏ´Â ¿î¿µ üÁ¦¿Í ´Ù¸¥ ¿î¿µ üÁ¦¿¡ ÇØ´çÇÕ´Ï´Ù. ¹®¼­ ³»¿ë Áß ±ÍÇÏ¿Í °ü·Ã ¾ø´Â ºÎºÐÀº Ç¥½ÃµÇÁö ¾Ê½À´Ï´Ù.
±×¸² Ãà¼Ò±×¸² È®´ë
Step by Step ±â¼ú ÀÚ·á ¸ðµÎ º¸±â (http://support.microsoft.com/gp/sbs_index/ko)
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

¼Ò°³

SQL ServerÀÇ ÇöÀç »óŸ¦ °¡Àå Á¤È®ÇÏ°í ºü¸£°Ô ÆÄ¾ÇÇÒ ¼ö ÀÖ´Â SQL Server ¿¡·¯ ·Î±×¸¦ °¡µ¶Çϱâ ÁÁÀº ÇüÅ·Π°ü¸®ÇÏ´Â ¹æ¹ýÀ» ¼Ò°³ÇÕ´Ï´Ù.

¾Æ¿ï·¯ À̸¦ º°µµÀÇ Å×À̺í·Î °ü¸®ÇÒ ¼ö ÀÖ´Â ¹æ¹ýÀ» ¼³¸íÇÕ´Ï´Ù.


¹æ¹ý

´ÙÀ½ ¹æ¹ýÀ» ¼ø¼­´ë·Î µû¶ó ÇØ º¸¼¼¿ä.
  1. SQL Server ¿¡·¯ ·Î±× Àбâ
    1. SQL Server Management Studio(SSMS) ½ÇÇàÇϱâ

      [½ÃÀÛ], [¸ðµç ÇÁ·Î±×·¥], [Micro SQL Server 2005](¶Ç´Â Micro SQL Server 2008À̳ª 2008 R2), [SQL Server Management Studio]¸¦ Â÷·Ê´ë·Î Ŭ¸¯ÇÏ¿© SQL Server Management Studio¸¦ ½ÇÇàÇϼ¼¿ä.

      ±×¸² Ãà¼Ò±×¸² È®´ë

    2. µ¥ÀÌÅͺ£À̽º ¿¬°áÇϱâ

      ¿¬°á Á¤º¸(¼­¹ö À̸§ ¶Ç´Â IP Address ¹× ·Î±×ÀÎ Á¤º¸)¸¦ ÀÔ·ÂÇÏ¿© Á¶È¸ÇϰíÀÚ ÇÏ´Â ¼­¹ö¿Í ¿¬°áÇϼ¼¿ä.

      ±×¸² Ãà¼Ò±×¸² È®´ë

    3. sp_readerrolog ±¸¹® ½ÇÇà

      ±×¸² Ãà¼Ò±×¸² È®´ë

      ÀÌ ¶§, ½ÇÇà ¹öư(F5 ȤÀº CTRL+E)À» ´©¸£±â Àü¿¡ [ÅØ½ºÆ®·Î °á°ú Ç¥½Ã]¸¦(
      ±×¸² Ãà¼Ò±×¸² È®´ë
      )¼±ÅÃÇϰųª CTRL+T¸¦ ´©¸£¼¼¿ä.

      ÀÌÈÄ ½ÇÇàÇÏ°Ô µÇ¸é ¾Æ·¡¿Í °°ÀÌ °¡µ¶Çϱâ ÁÁÀº ÇüÅ·Π¿¡·¯ ·Î±×¸¦ È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.

      ±×¸² Ãà¼Ò±×¸² È®´ë


      ¼­¹öÀÇ Á¤º¸(OS ¹× SQL SeverÀÇ ¹öÀü, ¼­¹ö À̸§), master µ¥ÀÌÅͺ£À̽º ¹× ¿¡·¯ ·Î±× ÆÄÀÏÀÇ À§Ä¡ ¹× Ȱ¼ºÈ­µÈ Trace FlagÀÇ Á¤º¸µµ È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.

      ½ºÅ©·Ñ¹Ù¸¦ À̵¿ÇÏ¿© ÇöÀç ½ÃÁ¡¿¡¼­ ÁÖ¸ñÇÒ ¸¸ÇÑ ¸Þ½ÃÁö´Â ¾ø´ÂÁö È®ÀÎÇϵµ·Ï ÇÕ´Ï´Ù.

  2. SQL Server ¿¡·¯ ·Î±× °ü¸®Çϱâ

    SQL Server ¿¡·¯ ·Î±×´Â ±âº»ÀûÀ¸·Î ÃÑ 7°³ÀÇ ÆÄÀÏ·Î °ü¸® µË´Ï´Ù. ¼­ºñ½º°¡ Àç½ÃÀÛ µÉ ¶§ ¸¶´Ù Rollover µÇ¸ç, ±âº» ÆÄÀÏÀÇ ¼ö¸¦ ³Ñ¾î¼­´Â ·Î±×´Â »ç¶óÁý´Ï´Ù.
    µû¶ó¼­ ¿¹±âÄ¡ ¾ÊÀº ÀÌÀ¯·Î SQL Server°¡ ¿©·¯ ¹ø ¹Ýº¹ÀûÀ¸·Î Àç½ÃÀÛ µÇ¸é ¹®Á¦ ½ÃÁ¡ÀÇ ·Î±×¸¦ È®º¸ÇÒ ¼ö ¾ø°Ô µÉ ¼öµµ ÀÖ½À´Ï´Ù. À̸¦ ¿¹¹æÇϱâ À§ÇØ ±âº»ÀûÀ¸·Î °ü¸®µÇ´Â 7°³ÀÇ ÆÄÀÏ º¸´Ù ´õ ¸¹Àº ¼öÀÇ ÆÄÀÏ·Î °ü¸®µÇµµ·Ï Á¶Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
    ¿©±â¼­´Â ÆÄÀÏÀÇ ¼ö¸¦ ´Ã¸®´Â °ÍÀÌ ¾Æ´Ñ ¿¡·¯ ·Î±×¸¦ Å×À̺í·Î °ü¸®ÇÏ´Â ¹æ¹ýÀ» ¼Ò°³ÇÕ´Ï´Ù. ÀÌ ³»¿ëÀº How to Archive your SQL Errorlogs into a Table (http://blogs.msdn.com/b/repltalk/archive/2011/01/05/how-to-archive-your-sql-errorlogs-into-a-table.aspx) ¿¡¼­µµ È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.

    ¼ö ¸¹Àº ·Î±×ÀÎ ½ÇÆÐ ¸Þ½ÃÁö µîÀÌ ·Î±ë µÇ¸é¼­ ÇϳªÀÇ ¿¡·¯ ·Î±× ÆÄÀÏÀÇ Å©±â°¡ ¸Å¿ì Ä¿Áö°Ô µÇ´Â °æ¿ì°¡ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù.

    ±×¸² Ãà¼Ò±×¸² È®´ë


    ÀÌ·¯ÇÑ °æ¿ì, ¿¡·¯ ·Î±×¸¦ ·Î±× ºä¾î³ª sp_readerrorlog ±¸¹®À¸·Î Àб⸦ ½ÃµµÇÏ¸é ¿À·£ ½Ã°£ÀÌ °É¸± ¼ö ÀÖÀ¸¹Ç·Î ³»°¡ ¿øÇÏ´Â ½Ã°£¿¡ ´ëÇÑ ·Î±× ÆÄ¾ÇÀÌ ¾î·Á¿ï ¼öµµ ÀÖ½À´Ï´Ù.

    ÀÌ ¶§ Ȱ¿ëÇÒ ¼ö ÀÖ´Â ¹æ¹ýÀº ´ÙÀ½°ú °°½À´Ï´Ù.
    1. SQL Server Errorlog ¹× Agent Log °ü¸®¿ë Å×ÀÌºí »ý¼º

      IF  NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MS_SQLERRORLOG]') AND type in (N'U'))
      BEGIN
      CREATE TABLE [dbo].[MS_SQLERRORLOG](
          [LogDate] [datetime] NULL,
          [ProcessInfo] [varchar](10) NULL,
          [Text] [varchar](max) NULL
      ) ON [PRIMARY]
      END
      GO
      
      
      IF  NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MS_SQLAGENTLOG]') AND type in (N'U'))
      BEGIN
      CREATE TABLE [dbo].[MS_SQLAGENTLOG](
          [LogDate] [datetime] NULL,
          [ProcessInfo] [varchar](10) NULL,
          [Text] [varchar](max) NULL
      ) ON [PRIMARY]
      END
      GO
    2. ÇöÀç ½ÃÁ¡±îÁöÀÇ Errorlog ÀúÀåÇϱâ
      INSERT INTO MS_SQLERRORLOG
      EXEC ('sp_readerrorlog')
      GO
      
      EXEC msdb.dbo.sp_cycle_errorlog
      GO
    3. ÇöÀç ½ÃÁ¡±îÁöÀÇ Agent Log ÀúÀåÇϱâ(¿¡ÀÌÀüÆ® ¼­ºñ½º°¡ ¹Ýµå½Ã µ¿ÀÛ ÁßÀ̾î¾ß ÇÔ)
      INSERT INTO MS_SQLAGENTLOG
      EXEC ('sp_readerrorlog -1, 2')
      GO
      
      EXEC msdb.dbo.sp_cycle_agent_errorlog
      GO
    4. Å×ÀÌºí »ý¼º ÈÄ 2), 3)ÀÇ ¹æ¹ýÀ» ÁÖ±âÀûÀ¸·Î ¼öÇàÇÏ¿© SQL Server ·Î±×¸¦ Å×À̺í·Î À̰üÇÏ¿© °ü¸®Çϸé, Log Date ¹× ProcessInfo µî¿¡ µû¶ó¼­ ¿øÇÏ´Â ³»¿ëÀÇ ·Î±×¸¦ º¸´Ù ºü¸£°Ô È®ÀÎÇÒ ¼ö ÀÖÀ¸¸ç ¾Æ¿ï·¯ ¿¡·¯ ·Î±×ÀÇ Å©±â°¡ Ä¿Á®¼­ µð½ºÅ©ÀÇ °ø°£À» °úµµÇÏ°Ô Â÷ÁöÇÏ´Â °ÍÀ» ¿¹¹æÇÒ ¼ö ÀÖ½À´Ï´Ù.

      ±×¸² Ãà¼Ò±×¸² È®´ë

Ãß°¡ Á¤º¸

´ÙÀ½ ³»¿ëÀ» Âü°í Çϼ¼¿ä.


ÀÇ°ß º¸³»±â

Ç¥ Ãà¼ÒÇ¥ È®´ë
±×¸² Ãà¼Ò±×¸² È®´ë

Microsoft °í°´Áö¿ø »çÀÌÆ®¿¡¼­´Â °í°´´ÔÀÇ ¼Ò¸®¸¦ ±Í´ã¾Æ µè½À´Ï´Ù. ¾Æ·¡ ÀÇ°ß º¸³»±â·Î ¼ÒÁßÇÑ ÀÇ°ß º¸³»Áֽñ⠹ٶø´Ï´Ù.

º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
Ű¿öµå:?
kbstepbystep kbhowto KB2497528