Results 1 to 5 of 5

Thread: restore db

  1. #1
    Join Date
    Nov 2003
    Posts
    6

    Unanswered: restore db

    Hi, I'm trying to restore tran log and the server returns error nb. 4330:
    The log in this backup set cannot be applied because it is on a recovery path inconsistent with the database.
    Please, dont you know, where the problem is?
    thanks for any advice...

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Probably the logs have to applied in order that they were dumped to the last full backup....

    Or are you trying to last full back up and have the wrong file?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2003
    Posts
    6

    Unhappy

    Of course I did it with right backup and in a right order...

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: restore db

    Originally posted by Kubas
    The log in this backup set cannot be applied because it is on a recovery path inconsistent with the database.
    Sorry, I didn't know...you need to supply for information...

    My mind reader machine is broken at the moment...

    Can you show us your restore code?

    Are the file located on different drives? How many logs did you have to apply?

    Is the process automated?

    Do you map and unmap the drives after the restore?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Nov 2003
    Posts
    6

    Re: restore db

    Nevermind
    I found out new fact that could cause the problem:

    I made komplet backup of database before reinstalation SQL server. After that reinstalation a made backup of tran log..
    Now I'm not able to load the tran log on the komplet database.

    I loaded complet backup in EM with norecovery option.
    Then in QA I tried to start this code:

    use master
    restore log Backup
    from disk = 'F:\MSSQL\BACKUP\CallCentrum\CallCentrum_db_200310 100030.BAK'
    with file = 2,
    stopat ='3.11.2003 12:55 AM'
    (tran log is in the same file as complete backup, therefore file =2)
    In that moment I get back the error msg. nb. 4330

    I think the problem is in reinstalation, although the pathes didnt change. The complete backup is made on another instalation of SQL Server then the tran log...

    I hope I descibed it understandable..

    Originally posted by Brett Kaiser
    Sorry, I didn't know...you need to supply for information...

    My mind reader machine is broken at the moment...

    Can you show us your restore code?

    Are the file located on different drives? How many logs did you have to apply?

    Is the process automated?

    Do you map and unmap the drives after the restore?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •