Sunday, March 11, 2012

Differential Backup Question

Hello,
I know you can take a db backup and restore it on a different server.
Can you also take a full db backup along with a differential backup and
restore it on a different server?
Thanks in advance!Yep. Transaction logs, too.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:3FC2DCEF-6A6B-45DC-99B8-645176F3BF5E@.microsoft.com...
Hello,
I know you can take a db backup and restore it on a different server.
Can you also take a full db backup along with a differential backup and
restore it on a different server?
Thanks in advance!|||Mark,
Yes you can. You can move a base full backup plus its differential backup
with no problem.
RLF
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:3FC2DCEF-6A6B-45DC-99B8-645176F3BF5E@.microsoft.com...
> Hello,
> I know you can take a db backup and restore it on a different server.
> Can you also take a full db backup along with a differential backup and
> restore it on a different server?
> Thanks in advance!
>

No comments:

Post a Comment