automatic backup / restore to another db

7 Jun 2006 8:24 PM

Smokey Grindle

we have a "snapshot" database used for development testing we it constantly
(weekly 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

7 Jun 2006 8:35 PM

Keith Kratochvil

In your job that performs the backups why not just add one more job step.

It woudl contain something like this:

IF (SELECT DATENAME ( weekday ,getdate() )) = 'Sunday'

BEGIN

RESTORE DATABASE...

--send email

--....anything else?

END

--
Keith Kratochvil

Show quoteHide quote

"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 (weekly 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
>

27 Jun 2006 2:19 PM

Smokey Grindle

thanks! thats just what I did

Show quoteHide quote

"Keith Kratochvil" <sqlguy.bac***@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 ( weekday ,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 (weekly 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
>>
>
>