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

Re: MUGH-SQLCON Re Restore

Expand Messages
  • mohd rizwan
    Kanchan, You can see this below link for syntax...
    Message 1 of 7 , Nov 15, 2008
    • 0 Attachment
      Kanchan,

      You can see this below link for syntax...
      http://www.builderau.com.au/program/sqlserver/soa/Restore-your-SQL-Server-database-using-transaction-logs/0,339028455,339282046,00.htm

      For syntax of Diffrential restore ...you can check BOL.

      Thanks & Regards,
      Mohd Rizwan(¨`·.·´¨) Always
      `·.¸(¨`·.·´¨) Keep
      (¨`·.·´¨)¸.·´ Smiling!
      `·.¸.·´

      --- On Thu, 6/11/08, kanchan verma <kanchanvrm@...> wrote:
      From: kanchan verma <kanchanvrm@...>
      Subject: Re: MUGH-SQLCON Re Restore
      To: sqlcon@yahoogroups.com
      Date: Thursday, 6 November, 2008, 10:10 AM













      can u give with syntax so that it will easy for me to understand

       

      regards



      --- On Fri, 31/10/08, Santhosh <san_spy@yahoo. com> wrote:



      From: Santhosh <san_spy@yahoo. com>

      Subject: Re: MUGH-SQLCON Re Restore

      To: sqlcon@yahoogroups. com

      Date: Friday, 31 October, 2008, 5:10 PM



      Hi,

      1. Restore the Last full backup



      2. Restore the latest increment backup.



      3. Restore the transaction log backups taken after that last incremental backup.



      With :))s

      Santhosh Kumar S.J - MCITP

      ReadMe @ sqlspy.blogspot. com

      ReadMe @ santhoshpakkangal. blogspot. com



      ____________ _________ _________ __

      From: kanchan verma <kanchanvrm@ yahoo. .co.in>

      To: sqlcon@yahoogroups. com

      Sent: Friday, 31 October, 2008 3:52:55 PM

      Subject: MUGH-SQLCON Re Restore



      Suppose I have taken full backup on friday and increment on monday, tuesday and wednesday then how to restore the backp



      regards



      Add more friends to your messenger and enjoy! Go to http://messenger. yahoo.com/ invite/



      [Non-text portions of this message have been removed]



      Add more friends to your messenger and enjoy! Go to http://messenger. yahoo.com/ invite/



      [Non-text portions of this message have been removed]



      From Chandigarh to Chennai - find friends all over India. Go to http://in.promos. yahoo.com/ groups/citygroup s/



      [Non-text portions of this message have been removed]



























      Get your preferred Email name!
      Now you can @... and @....
      http://mail.promotions.yahoo.com/newdomains/aa/

      [Non-text portions of this message have been removed]
    • kanchan verma
      dear   i would like to have script command for backup and as well as for restore   regards   kanchan ... From: Santhosh Subject: Re:
      Message 2 of 7 , Nov 18, 2008
      • 0 Attachment
        dear
         
        i would like to have script command for backup and as well as for restore
         
        regards
         
        kanchan
        --- On Fri, 31/10/08, Santhosh <san_spy@...> wrote:

        From: Santhosh <san_spy@...>
        Subject: Re: MUGH-SQLCON Re Restore
        To: sqlcon@yahoogroups.com
        Date: Friday, 31 October, 2008, 5:10 PM






        Hi,
        1. Restore the Last full backup

        2. Restore the latest increment backup.

        3. Restore the transaction log backups taken after that last incremental backup.

        With :))s
        Santhosh Kumar S.J - MCITP
        ReadMe @ sqlspy.blogspot. com
        ReadMe @ santhoshpakkangal. blogspot. com

        ____________ _________ _________ __
        From: kanchan verma <kanchanvrm@yahoo. .co.in>
        To: sqlcon@yahoogroups. com
        Sent: Friday, 31 October, 2008 3:52:55 PM
        Subject: MUGH-SQLCON Re Restore

        Suppose I have taken full backup on friday and increment on monday, tuesday and wednesday then how to restore the backp

        regards



        Add more friends to your messenger and enjoy! Go to http://messenger. yahoo.com/ invite/

        [Non-text portions of this message have been removed]

        Add more friends to your messenger and enjoy! Go to http://messenger. yahoo.com/ invite/

        [Non-text portions of this message have been removed]
















        Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/

        [Non-text portions of this message have been removed]
      • kunal choudhary
        Hi, Back the tail of log     Backup log DBName to Disk = Location with no truncate. Restore Full backup     Restore database DBName from disk =
        Message 3 of 7 , Nov 18, 2008
        • 0 Attachment
          Hi,

          Back the tail of log
              Backup log DBName to Disk = 'Location' with no truncate.
          Restore Full backup
              Restore database DBName from disk = 'location' with NO RECOVERY.
          Restore Latest incremental backup with no recovery option
          Restore all log backup after incremental backup in the order they hav taken.
          Restore Log DBName from disk = 'Location' with No Recovery.

          Apply below command once all restore are done.

          Restore database DBName with recovery.

          Thank you,


           



          ________________________________
          From: kanchan verma <kanchanvrm@...>
          To: sqlcon@yahoogroups.com
          Sent: Tuesday, 18 November, 2008 2:09:00 PM
          Subject: Re: MUGH-SQLCON Re Restore



          dear
           
          i would like to have script command for backup and as well as for restore
           
          regards
           
          kanchan
          --- On Fri, 31/10/08, Santhosh <san_spy@yahoo. com> wrote:

          From: Santhosh <san_spy@yahoo. com>
          Subject: Re: MUGH-SQLCON Re Restore
          To: sqlcon@yahoogroups. com
          Date: Friday, 31 October, 2008, 5:10 PM

          Hi,
          1. Restore the Last full backup

          2. Restore the latest increment backup.

          3. Restore the transaction log backups taken after that last incremental backup.

          With :))s
          Santhosh Kumar S.J - MCITP
          ReadMe @ sqlspy.blogspot. com
          ReadMe @ santhoshpakkangal. blogspot. com

          ____________ _________ _________ __
          From: kanchan verma <kanchanvrm@ yahoo. .co.in>
          To: sqlcon@yahoogroups. com
          Sent: Friday, 31 October, 2008 3:52:55 PM
          Subject: MUGH-SQLCON Re Restore

          Suppose I have taken full backup on friday and increment on monday, tuesday and wednesday then how to restore the backp

          regards

          Add more friends to your messenger and enjoy! Go to http://messenger. yahoo.com/ invite/

          [Non-text portions of this message have been removed]

          Add more friends to your messenger and enjoy! Go to http://messenger. yahoo.com/ invite/

          [Non-text portions of this message have been removed]

          Add more friends to your messenger and enjoy! Go to http://messenger. yahoo.com/ invite/

          [Non-text portions of this message have been removed]




          Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/

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