lsn chain question

I am able to restore a full database backup file to another sql server without any problems
I am unable to apply transaction log backups on top of the full backup.
I am also unable to apply differential backups to the full backup.

I am using the no recovery option on the restore of the full backup.
I get an lsn error.  
attached is the lsn chains associated with the two files I am trying to restore.
they are highlighted in blue in the experts exchange.xlsx file

does anyone see any problems?

I am trying to recover the file associated in row 4 on top of the full database backup on row 6
experts-exchange.xlsx
jamesmetcalf74Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Deepak ChauhanSQL Server DBACommented:
Here is your backup times

07/04/2015 09:00:03,Backup,Unknown,Log was backed up. Database: "dbName" forth log
07/04/2015 06:00:30,Backup,Unknown,Log was backed up. Database: "dbName" -- third log
07/04/2015 03:00:05,Backup,Unknown,Log was backed up. Database: "dbName" -second log
07/04/2015 00:00:03,Backup,Unknown,Log was backed up. Database: "dbName" first log
07/03/2015 23:00:58,Backup,Unknown,Database backed up. Database: "dbName" -- first full

Restore sequence will be ....

1. Restore database xyz from disk='.......\full backup.bak' with NORECOVERY
2. Restore database xyz from disk='.......\first log backup.bak' with NORECOVERY
3. Restore database xyz from disk='.......\second log backup.bak' with NORECOVERY
4. Restore database xyz from disk='.......\third log backup.bak' with NORECOVERY
5. Restore database xyz from disk='.......\forth log backup.bak' with RECOVERY


Do you have any differential backup between FULL and Tlog?
if this is the case then restore sequence will be....

1. Restore database xyz from disk='.......\full backup.bak' with NORECOVERY
2. Restore database xyz from disk='.......\differential backup.bak' with NORECOVERY
3. Restore database xyz from disk='.......\first log backup.bak' with NORECOVERY  --just after differential
4. Restore database xyz from disk='.......\second log backup.bak' with NORECOVERY
5. Restore database xyz from disk='.......\third log backup.bak' with RECOVERY
and restore up to last log backup

but last log restore will be with recovery.
jamesmetcalf74Author Commented:
I tried that but I keep getting errors msg

Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "E:\SQL_Data\dbname.mdf" failed with the operating system error 3(The system cannot find the path specified.).

im trying to restore on a new machine... the directory it is looking for is not on the restore server
Anoo S PillaiCommented:
At the time of restore, you can specify the physical location to which the files are to be restored. The existence of same directory or folder structure is not necessary -

Please refer "Restoring a database and move files" in url - RESTORE (Transact-SQL)

If you are still facing problems , please post the chain of commands and the errors raised on each of the command execution.
Deepak ChauhanSQL Server DBACommented:
During the restore sql server find the physical file location from backup set if location does not exist you will get this error.

just to check the existing file location in backupset.

Restore filelistonly from disk='.....\full backupfile.bak'

While restoring you can change the location in restore script using TSQL or using UI.

using tsql : - You can use MOVE option to change the location of file accordingly.

for eg: Restore database xyz from disk='.......\full backup.bak' with NORECOVERY , Move '<logicalFilename>' to '<new location\databasefile.mdf>'

RestoreWithNorecovery.jpg

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jamesmetcalf74Author Commented:
Hey guys
im starting from scratch on this.

Can someone figure out what i am doing wrong for this restore attempt or tell me if my backup files are jacked.
scenario:

I am trying to recover a database from backups.  I am grabbing the backup files from our network share
and attempting to recover on my laptop.
laptop has a full install of sql 2012.

1) i am able to restore the full backup file and keep it in the non recovery state.
2) when i try to apply the differential backup on the recovering state full, it gives me the error.  "there is a break in the lsn chain"

in the picture provided. "pic1.jpg"
can someone confirm that by just looking at the lsn chain values, that the backups seem to be ok?

black square has the full back up file
red square has the differential back up file that fails.
pic1.jpg
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.