Post reply

Restoring failed

  • July 2, 2013 at 11:43 pm

    #276925

    Hi all,

    i am trying to restore a database to point in time in sql server 2012.

    so i want to test that one with a sample database... i have taken fullbackup ..and then entered some data..then taken differential backup and entered some data and taken log backup...

    when i am trying to restore, the full backup was successfully restored. when i am trying the differential backup it is saying unable to create restore plan due to break in LSN chain. i am not able to find what wrong i have done...

  • July 3, 2013 at 1:39 am

    #1629391

    Can you post the code you entered and the exact error message displayed?

    Joie Andrew
    "Since 1982"

  • July 3, 2013 at 2:01 am

    #1629396

    I am using GUI of SSMS 2012 for doing restore operation.

  • July 3, 2013 at 2:04 am

    #1629398

    Then go through the full and differential restores again in SSMS and before executing the restores script out the actions and post the scripts here so we can see what you are trying to do.

    Joie Andrew
    "Since 1982"

  • July 3, 2013 at 2:05 am

    #1629399

    multiple reasons could be there:

    1. Some other backup process is scheduled or taken manually

    2.Recovery mode might have changed to simple and then

    3.Might have taken full backup with copy only option

    4.Might be LS scheduled

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

  • July 3, 2013 at 2:11 am

    #1629400

    by the time i select the differential backup in the GUI the script option is greyed out and on left hand top corner displaying 'unable to create restore plan due to break in LSN Chain'.

  • July 3, 2013 at 2:27 am

    #1629405

    Interesting. When you restore the full backup are you leaving the db in recovery?

    I would restore using T-SQL. You only have 3 backups to restore (2 if you don't want to use the differential), so it is not that much code to generate.

    Joie Andrew
    "Since 1982"

  • July 3, 2013 at 2:41 am

    #1629409

    yes the database was restored using no recovery and after successful restoration of full backup the database was in restoring mode....

  • July 3, 2013 at 2:52 am

    #1629416

    Do you have jobs/maintenance plans that run on a scheduled basis? Is it possible that another full backup kicked off between the time that you performed your full backup and your differential?

    Joie Andrew
    "Since 1982"

  • July 3, 2013 at 3:09 am

    #1629424

    physical_device_name bkSize TimeTaken backup_start_date first_lsn last_lsn BackupType server_name recovery_model

    d:\tail.trn 0 MB 0 Seconds 2013-07-03 11:53:43.000 54000000021200001 54000000021700001 Transaction Log QBSRECPU04 FULL

    D:\Backups\a\a_backup_2013_07_03_115000_8310075.trn 0 MB 0 Seconds 2013-07-03 11:50:00.000 54000000020400001 54000000021200001 Transaction Log QBSRECPU04 FULL

    D:\Backups\a\a_backup_2013_07_03_114501_4010075.trn 0 MB 0 Seconds 2013-07-03 11:45:01.000 54000000018400001 54000000020400001 Transaction Log QBSRECPU04 FULL

    D:\Backups\a\a_backup_2013_07_03_114501_5420075.bak 1 MB 1 Seconds 2013-07-03 11:45:01.000 54000000018600038 54000000020400001 Differential QBSRECPU04 FULL

    D:\Backups\a\a_backup_2013_07_03_114000_9340075.trn 0 MB 0 Seconds 2013-07-03 11:40:01.000 54000000009800001 54000000018400001 Transaction Log QBSRECPU04 FULL

    D:\Backups\a\a_backup_2013_07_03_113503_8269408.trn 0 MB 0 Seconds 2013-07-03 11:35:03.000 54000000005300001 54000000009800001 Transaction Log QBSRECPU04 FULL

    D:\Backups\a\a_backup_2013_07_03_113503_8269408.bak 8 MB 1 Seconds 2013-07-03 11:35:03.000 54000000009900168 54000000017100001 Full QBSRECPU04 FULL

  • July 3, 2013 at 3:13 am

    #1629425

    there is no backup jobs at present. and there is no kick off full backups in between the time.

  • July 3, 2013 at 3:13 am

    #1629426

    there is no kick off full backups and no backup jobs running....

  • July 3, 2013 at 3:28 am

    #1629435

    We can't see what you can see, so help us to help you. Please write a RESTORE statement for each operation. Post all the statements, along with any error messages you get when you run them.

    John

  • July 3, 2013 at 3:42 am

    #1629443

    i tried using restore command in SSMS for the same issue and it went fine and the database restored successfully. the issue is with GUI and how can i post the screenshot.

  • July 3, 2013 at 3:48 am

    #1629449

    Just came across this:

    SQL Server Management Studio 2012 errors when doing restore to SQL 2008

    Take a look at the workaround and see if that works for you.

    Joie Andrew
    "Since 1982"

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply