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?This is a multi-part message in MIME format.
--=_NextPart_000_0372_01C3D5F8.5D023FA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Did you restore the full backup with NORECOVERY? If not, re-restore with
this option.
--
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: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?
--=_NextPart_000_0372_01C3D5F8.5D023FA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Did you restore the full backup with NORECOVERY? If not, re-restore with this option.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Jeff Timmerman" wrote in message news:0a0801c3d620$25=f35f30$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?
--=_NextPart_000_0372_01C3D5F8.5D023FA0--|||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
>--Original Message--
>Did you restore the full backup with NORECOVERY? If not,
re-restore with
>this option.
>--
>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: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?
>|||This is a multi-part message in MIME format.
--=_NextPart_000_017E_01C3D6A7.28C09CA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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
>--Original Message--
>Did you restore the full backup with NORECOVERY? If not,
re-restore with
>this option.
>--
>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: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?
>
--=_NextPart_000_017E_01C3D6A7.28C09CA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
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
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Jeff Timmerman" wrote in message news:0ca701c3d6cd$9a=a7bdf0$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 crazyThanks for any =help you can give me.jeff>--Original Message-->Did =you restore the full backup with NORECOVERY? If not, re-restore with>this option.>>-->Tom>>--=---->Thomas A. Moreau, BSc, PhD, MCSE, MCDBA>SQL Server MVP>Columnist, =SQL Server Professional>Toronto, ON Canada>www.pinnaclepublishing.com/sql>>>"Jeff= Timmerman" wrote in message>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?>
--=_NextPart_000_017E_01C3D6A7.28C09CA0--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment