Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
balakrishnachow
Starting Member
24 Posts |
 Posted - 2010-12-12 : 06:15:19
|
| Hi,i have a little bit problem with restore.i have one full backup,two differential backup,ten trns i have.when i am going to restore full it restore fine after that which differential backup i need to restore how i will check the corresponding diff backup for that full backup(i have used restore headeronly command)but there is no mactches b/w lsn(i mean first lsn of full backup is equal to last lsn of diff backup).acn you any body help on this issue.thanksbalakrishna.bgood |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-12 : 10:02:41
|
| You just restore a full backup then any diff following it and before the next full backup. Usually the last full followed by the last diff if after the full.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
restore