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 |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2007-11-16 : 10:16:58
|
| I did the full backup of .7 TB database about 2 weeks ago and did full restore with norecovery mode and then i did differential backup of about 100 gb and tried to restore but it is showing following error :System.Data.SqlClient.SqlError: This differential backup cannot be restored because the database has not been restored to the correct earlier state. (Microsoft.SqlServer.Smo)While restoring the files are different than original database filesPlease help |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-16 : 10:41:44
|
| sounds like the full backup you restored was not the last full backup before the differential backup you are trying to restore. not sure what your last sentance means... |
 |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-11-16 : 12:08:52
|
| Either u have restored the latest full backup and not a differential taken after that or u may have restored an old full backup.RKNAIR |
|
|
|
|
|
|
Error on Restoring Database