SQL Server 2005 Restore Error

Discussion in 'ASP .Net' started by Jayakrishnan, Jul 15, 2009.

  1. Jayakrishnan

    Jayakrishnan Guest

    In SQL Server 2005, I need to append data using restore option. How to
    deal with this. I need to append data not to overwrite.

    I tried "RESTORE WITH RECOVERY" option. I received the following error.

    "The tail of the log for the database "pubs" has not been backed up. Use
    BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do
    not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the
    RESTORE statement to just overwrite the contents of the log.
    (Microsoft.SqlServer.Smo)"

    I tried Backup with transaction log option. and restored it. I received
    the following error.

    "The log or differential backup cannot be restored because no files are
    ready to rollforward. (Microsoft.SqlServer.Smo)"

    Thanks in advance.

    Jay..
     
    Jayakrishnan, Jul 15, 2009
    #1
    1. Advertisements

  2. Jayakrishnan

    David C Guest

    Try the sqlserver.server forum.
    "Jayakrishnan" <> wrote in message
    news:...
    >
    > In SQL Server 2005, I need to append data using restore option. How to
    > deal with this. I need to append data not to overwrite.
    >
    > I tried "RESTORE WITH RECOVERY" option. I received the following error.
    >
    > "The tail of the log for the database "pubs" has not been backed up. Use
    > BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do
    > not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the
    > RESTORE statement to just overwrite the contents of the log.
    > (Microsoft.SqlServer.Smo)"
    >
    > I tried Backup with transaction log option. and restored it. I received
    > the following error.
    >
    > "The log or differential backup cannot be restored because no files are
    > ready to rollforward. (Microsoft.SqlServer.Smo)"
    >
    > Thanks in advance.
    >
    > Jay..
     
    David C, Jul 15, 2009
    #2
    1. Advertisements

  3. Jayakrishnan

    Jayakrishnan Guest

    David C wrote:
    > Try the sqlserver.server forum.
    > "Jayakrishnan" <> wrote in message
    > news:...
    >> In SQL Server 2005, I need to append data using restore option. How to
    >> deal with this. I need to append data not to overwrite.
    >>
    >> I tried "RESTORE WITH RECOVERY" option. I received the following error.
    >>
    >> "The tail of the log for the database "pubs" has not been backed up. Use
    >> BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do
    >> not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the
    >> RESTORE statement to just overwrite the contents of the log.
    >> (Microsoft.SqlServer.Smo)"
    >>
    >> I tried Backup with transaction log option. and restored it. I received
    >> the following error.
    >>
    >> "The log or differential backup cannot be restored because no files are
    >> ready to rollforward. (Microsoft.SqlServer.Smo)"
    >>
    >> Thanks in advance.
    >>
    >> Jay..

    >
    >

    thanks
     
    Jayakrishnan, Jul 16, 2009
    #3
  4. Jayakrishnan

    Jayakrishnan Guest

    David C wrote:
    > Try the sqlserver.server forum.
    > "Jayakrishnan" <> wrote in message
    > news:...
    >> In SQL Server 2005, I need to append data using restore option. How to
    >> deal with this. I need to append data not to overwrite.
    >>
    >> I tried "RESTORE WITH RECOVERY" option. I received the following error.
    >>
    >> "The tail of the log for the database "pubs" has not been backed up. Use
    >> BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do
    >> not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the
    >> RESTORE statement to just overwrite the contents of the log.
    >> (Microsoft.SqlServer.Smo)"
    >>
    >> I tried Backup with transaction log option. and restored it. I received
    >> the following error.
    >>
    >> "The log or differential backup cannot be restored because no files are
    >> ready to rollforward. (Microsoft.SqlServer.Smo)"
    >>
    >> Thanks in advance.
    >>
    >> Jay..

    >
    >

    thanks
     
    Jayakrishnan, Jul 16, 2009
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Juan T. Llibre
    Replies:
    0
    Views:
    638
    Juan T. Llibre
    Jun 7, 2005
  2. =?Utf-8?B?c2NvdHRybQ==?=

    sql session state for .net v1.1/.net v2.0 and sql server 2005

    =?Utf-8?B?c2NvdHRybQ==?=, Feb 13, 2006, in forum: ASP .Net
    Replies:
    3
    Views:
    2,981
    Steven Cheng[MSFT]
    Feb 16, 2006
  3. farseer

    SQL Server 2005 + SQL Server Express

    farseer, Aug 7, 2006, in forum: ASP .Net
    Replies:
    3
    Views:
    535
    farseer
    Aug 8, 2006
  4. Brad  Brening
    Replies:
    0
    Views:
    627
    Brad Brening
    Mar 1, 2007
  5. rote
    Replies:
    3
    Views:
    1,420
  6. XJ
    Replies:
    8
    Views:
    1,990
  7. Wesley Chen
    Replies:
    0
    Views:
    388
    Wesley Chen
    Apr 7, 2009
  8. Wesley Chen
    Replies:
    9
    Views:
    519
    Sean O'Halpin
    Apr 14, 2009
Loading...