July 2, 2013 at 11:43 pm
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
Can you post the code you entered and the exact error message displayed?
Joie Andrew
"Since 1982"
July 3, 2013 at 2:01 am
I am using GUI of SSMS 2012 for doing restore operation.
July 3, 2013 at 2:04 am
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
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
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
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
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
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
physical_device_namebkSizeTimeTakenbackup_start_datefirst_lsnlast_lsnBackupTypeserver_namerecovery_model
d:\tail.trn0 MB0 Seconds2013-07-03 11:53:43.0005400000002120000154000000021700001Transaction LogQBSRECPU04FULL
D:\Backups\a\a_backup_2013_07_03_115000_8310075.trn0 MB0 Seconds2013-07-03 11:50:00.0005400000002040000154000000021200001Transaction LogQBSRECPU04FULL
D:\Backups\a\a_backup_2013_07_03_114501_4010075.trn0 MB0 Seconds2013-07-03 11:45:01.0005400000001840000154000000020400001Transaction LogQBSRECPU04FULL
D:\Backups\a\a_backup_2013_07_03_114501_5420075.bak1 MB1 Seconds2013-07-03 11:45:01.0005400000001860003854000000020400001DifferentialQBSRECPU04FULL
D:\Backups\a\a_backup_2013_07_03_114000_9340075.trn0 MB0 Seconds2013-07-03 11:40:01.0005400000000980000154000000018400001Transaction LogQBSRECPU04FULL
D:\Backups\a\a_backup_2013_07_03_113503_8269408.trn0 MB0 Seconds2013-07-03 11:35:03.0005400000000530000154000000009800001Transaction LogQBSRECPU04FULL
D:\Backups\a\a_backup_2013_07_03_113503_8269408.bak8 MB1 Seconds2013-07-03 11:35:03.0005400000000990016854000000017100001FullQBSRECPU04FULL
July 3, 2013 at 3:13 am
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
there is no kick off full backups and no backup jobs running....
July 3, 2013 at 3:28 am
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
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
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