Loading ...
Sorry, an error occurred while loading the content.

Re: MUGH-SQLCON How to take tail log backup in SQLServer.

Expand Messages
  • Shashi Kumar Singh
    Hi, To take log backup you need to give this command: BACKUP DATABASE DB_NAME TO DISK= PATH BACKUP_NAME WITH NOTRUNCATE_ONLY ... -- Thanks & Regards Shashi
    Message 1 of 3 , Sep 1, 2010
    • 0 Attachment
      Hi,

      To take log backup you need to give this command:

      BACKUP DATABASE DB_NAME TO DISK='PATH\BACKUP_NAME' WITH NOTRUNCATE_ONLY

      On Thu, Jul 22, 2010 at 7:24 PM, Santhosh <san_spy@...> wrote:

      >
      >
      > Tail log backup is nothing but transaction log backup. Basically in case of
      >
      > database failure the last transaction log backup taken before recovering
      > the
      > database is called tail log backup. Check below
      >
      > http://msdn.microsoft.com/en-us/library/ms179314.aspx
      >
      >
      > With :))s
      > Santhosh Kumar S.J - MCITP
      > ReadMe @ sqlspy.blogspot.com
      > ReadMe @ santhoshpakkangal.blogspot.com
      >
      > ________________________________
      > From: SARADADEVI <sv_39@... <sv_39%40yahoo.co.in>>
      > To: sqlcon@yahoogroups.com <sqlcon%40yahoogroups.com>
      > Sent: Thu, 22 July, 2010 6:45:31 PM
      > Subject: MUGH-SQLCON How to take tail log backup in SQLServer.
      >
      >
      > How to take tail log backup in SQLServer.
      >
      > [Non-text portions of this message have been removed]
      >
      > [Non-text portions of this message have been removed]
      >
      >
      >



      --

      Thanks & Regards

      Shashi Kumar Singh
      Senior System Engineer
      IBM India (P)Ltd.
      Email:singh.shashikumar2@... <Email%3Asingh.shashikumar2@...>,
      shashi_120@...


      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.