automatic backup / restore to another db

we have a "snapshot" database used for development testing we it constantly
(wly only) synced with the development database (on same server) I wanted
to set up a schedule that will backup the database called development every
sunday morning, then restore that onto the "devsnapshot" database right
after that sucessfully completed... is there any easy way to do this in sql
server 2005? if so how? i dont want mirrored data (aka realtime change
tracking) but i want to have the DML and data all copied so its a 1:1 copy..
thanksIn your job that performs the backups why not just add one more job step.
It woudl contain something like this:
IF (SELECT DATENAME ( wday ,getdate() )) = 'Sunday'
BEGIN
RESTORE DATABASE...
--send email
--...anything else?
END
Keith Kratochvil
"Smokey Grindle" <nospamhere@.dontspam.net> wrote in message
news:ukwlBCniGHA.2220@.TK2MSFTNGP05.phx.gbl...
> we have a "snapshot" database used for development testing we it
> constantly (wly only) synced with the development database (on same
> server) I wanted to set up a schedule that will backup the database called
> development every sunday morning, then restore that onto the
> "devsnapshot" database right after that sucessfully completed... is there
> any easy way to do this in sql server 2005? if so how? i dont want
> mirrored data (aka realtime change tracking) but i want to have the DML
> and data all copied so its a 1:1 copy.. thanks
>|||thanks! thats just what I did
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OKeTrIniGHA.2456@.TK2MSFTNGP04.phx.gbl...
> In your job that performs the backups why not just add one more job step.
> It woudl contain something like this:
> IF (SELECT DATENAME ( wday ,getdate() )) = 'Sunday'
> BEGIN
> RESTORE DATABASE...
> --send email
> --...anything else?
> END
>
> --
> Keith Kratochvil
>
> "Smokey Grindle" <nospamhere@.dontspam.net> wrote in message
> news:ukwlBCniGHA.2220@.TK2MSFTNGP05.phx.gbl...
>