Differential Backups Query - Multiple Restores

Hi There,
maybe a very simple one here so apologies if it is. I was wondering
that if I create a differential backup each day on one server, can I
apply the backup each day to another server to bring it up to the same
state? I am aware that this is not ideal but it's the way that we work
at the moment.
to clarify:
On Monday, database A is differentially backed up
Database B is restored without recovery from the differential backup of
A
Can this process be repeated each day of the week or will I have to
restore the full backup from A and then the latest differential?
Thanks
BB
What you are described , looks like log shipping.
http://www.sql-server-performance.com/sql_server_log_shipping.asp

> Can this process be repeated each day of the week or will I have to
> restore the full backup from A and then the latest differential?
Yes , you must restore FULL backup database first
"BB" <benmburch@.hotmail.com> wrote in message
news:1168517040.780292.164600@.k58g2000hse.googlegr oups.com...
> Hi There,
> maybe a very simple one here so apologies if it is. I was wondering
> that if I create a differential backup each day on one server, can I
> apply the backup each day to another server to bring it up to the same
> state? I am aware that this is not ideal but it's the way that we work
> at the moment.
> to clarify:
> On Monday, database A is differentially backed up
> Database B is restored without recovery from the differential backup of
> A
> Can this process be repeated each day of the week or will I have to
> restore the full backup from A and then the latest differential?
> Thanks
>
|||Thanks for that Uri. Much appreciated