Differential restore

Yes I did restored with norecovery. I also have SP3 loaded
and have tried to do the restore both through Enterprise
Manager and the Query Analyzer. Both worked until
recently. I have made no changes to the either the
configuration or the database. this is crazy
Thanks for any help you can give me.
jeff

quote:

---

>--Original Message--
>Did you restore the full backup with NORECOVERY? If not,

---

re-restore with

quote:

---

>this option.
>--
>Tom
>----

---

--

quote:

---

>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jeff Timmerman" <anonymous@.discussions.microsoft.com>

---

wrote in message

quote:

---

>news:0a0801c3d620$25f35f30$a001280a@.phx.gbl...
>I can no longer restore a differential backup after
>restoring the fullbackup. I found the microsoft work
>around that says to do the restore throught the Query
>Analizer but that doesn't work either. Does anyone know
>how i cna fix this problem?
>

---

Just wondering about corruption here. Can you try backing up Northwind -
full and differential, plus a couple of txn logs, then restore them all? If
that fails, it could be a SQL Server problem. If it succeeds, it's your
original backups.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Jeff Timmerman" <anonymous@.discussions.microsoft.com> wrote in message
news:0ca701c3d6cd$9aa7bdf0$a501280a@.phx.gbl...
Yes I did restored with norecovery. I also have SP3 loaded
and have tried to do the restore both through Enterprise
Manager and the Query Analyzer. Both worked until
recently. I have made no changes to the either the
configuration or the database. this is crazy
Thanks for any help you can give me.
jeff

quote:

---

>--Original Message--
>Did you restore the full backup with NORECOVERY? If not,

---

re-restore with

quote:

---

>this option.
>--
>Tom
>----

---

--

quote:

---

>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jeff Timmerman" <anonymous@.discussions.microsoft.com>

---

wrote in message

quote:

---

>news:0a0801c3d620$25f35f30$a001280a@.phx.gbl...
>I can no longer restore a differential backup after
>restoring the fullbackup. I found the microsoft work
>around that says to do the restore throught the Query
>Analizer but that doesn't work either. Does anyone know
>how i cna fix this problem?
>

---