Restore backup differential on a differente server

I got TWO sqlserver .
The first is the main server , every one hour I make a differential
backup of a Db ( TestDB ) with a Job that save de file .BAK in a
folder of the second server .
Now I need to create a Job that restore the db on the second server
How can I do this ? I'm only able to restore the full backup not
differential backup :-(
please help me
thanksHave you looked at this?
http://msdn2.microsoft.com/en-us/library/ms175510.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<emanuele.pasinetti@.gmail.com> wrote in message
news:1163436938.589340.226360@.f16g2000cwb.googlegroups.com...
>I got TWO sqlserver .
> The first is the main server , every one hour I make a differential
> backup of a Db ( TestDB ) with a Job that save de file .BAK in a
> folder of the second server .
> Now I need to create a Job that restore the db on the second server
> How can I do this ? I'm only able to restore the full backup not
> differential backup :-(
> please help me
> thanks
>|||I'm working with SqlServer 2000 , I think this is about 2005, true ?
Roger Wolter[MSFT] ha scritto:
[vbcol=seagreen]
> Have you looked at this?
> http://msdn2.microsoft.com/en-us/library/ms175510.aspx
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> <emanuele.pasinetti@.gmail.com> wrote in message
> news:1163436938.589340.226360@.f16g2000cwb.googlegroups.com...|||All you need to do is to schedule a job in which you have a job step executi
ng the RESTORE DATABASE
command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Pasi" <emanuele.pasinetti@.gmail.com> wrote in message
news:1163449604.753979.234130@.h48g2000cwc.googlegroups.com...
> I'm working with SqlServer 2000 , I think this is about 2005, true ?
> Roger Wolter[MSFT] ha scritto:
>
>|||Sorry, I must have missed where you said your were using SQL 2000
http://msdn.microsoft.com/library/d... />
t_7tv7.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Pasi" <emanuele.pasinetti@.gmail.com> wrote in message
news:1163449604.753979.234130@.h48g2000cwc.googlegroups.com...
> I'm working with SqlServer 2000 , I think this is about 2005, true ?
> Roger Wolter[MSFT] ha scritto:
>
>