Restore database from differential backup

Is it possible to restore SQLServer database from differential backup with
out need of FULL backup.
Thanks in Advance
krish
No. Diff backup requires that you first restore the most recent database backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"krish" <krish@.discussions.microsoft.com> wrote in message
news:582A5389-0466-42B1-8EB8-1D5C7DCEC374@.microsoft.com...
> Is it possible to restore SQLServer database from differential backup with
> out need of FULL backup.
> Thanks in Advance
> krish
|||Hi karaszi,
Thanks for a quick reply.
can a database be restored from a full backup of prod server and diff backup
of dev server.
Thanks in Advance
Krish
"Tibor Karaszi" wrote:

> No. Diff backup requires that you first restore the most recent database backup.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "krish" <krish@.discussions.microsoft.com> wrote in message
> news:582A5389-0466-42B1-8EB8-1D5C7DCEC374@.microsoft.com...
>
>
|||hi krish,
differential backup will contain all the activites on the sql server
performed right from the time the last Full backup is taken. You cannot
resote from the differential backup of the dev server on the prod server. The
sequence number will be a mismatch and hence it will not continue. If you
have lost the differential backup of the production due to some reason, you
can try restoring the log backups, if you had taken it'.
If you need more explanation or problem is be defined futher, let me know.
Regards
"krish" wrote:
[vbcol=seagreen]
> Hi karaszi,
> Thanks for a quick reply.
> can a database be restored from a full backup of prod server and diff backup
> of dev server.
> Thanks in Advance
> Krish
> "Tibor Karaszi" wrote:
|||hi mani,
i will explain in clear whats my problem is
i am working with project server and i am looking for
a project plan on a particular date.backup script has removed the fullback
backup files before that date on prod machine.
i have a diff backup from dev machine for that date but no full backup was
there as i have restored with a different db name.
IS there anyway suppose
i have created db name x.my backup script has taken
1st day--diff
2nd day--diff
3rd day--diff
4th day--full
is there anyway can i roll back to 2nd day.
THanks in Advance
krish
"mani" wrote:
[vbcol=seagreen]
> hi krish,
> differential backup will contain all the activites on the sql server
> performed right from the time the last Full backup is taken. You cannot
> resote from the differential backup of the dev server on the prod server. The
> sequence number will be a mismatch and hence it will not continue. If you
> have lost the differential backup of the production due to some reason, you
> can try restoring the log backups, if you had taken it'.
> If you need more explanation or problem is be defined futher, let me know.
> Regards
> "krish" wrote:
|||Your scenario doesn't change the fact that in order to restore from a diff backup, you need to first
restore from that diff backup's most recent database backup. I'm afraid.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"krish" <krish@.discussions.microsoft.com> wrote in message
news:734A87B2-B74C-4644-9EE6-66D160075EEB@.microsoft.com...[vbcol=seagreen]
> hi mani,
> i will explain in clear whats my problem is
> i am working with project server and i am looking for
> a project plan on a particular date.backup script has removed the fullback
> backup files before that date on prod machine.
> i have a diff backup from dev machine for that date but no full backup was
> there as i have restored with a different db name.
> IS there anyway suppose
> i have created db name x.my backup script has taken
> 1st day--diff
> 2nd day--diff
> 3rd day--diff
> 4th day--full
> is there anyway can i roll back to 2nd day.
> THanks in Advance
> krish
> "mani" wrote:
sql