automating restore

Hello,
I'm trying to automate a prod to test restore to run weekly on a SQL 2000
sp3a server. Its on the same machine so I can't use the copy db wizard.
Should i use DTS, replication or what. I don't want to deal with orphaned
users and the like. It should be as seamless as possible.
TIA,
jj
jj
Have you looked at BACKUP\RESTORE commands?
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:OmwojWWNFHA.1040@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I'm trying to automate a prod to test restore to run weekly on a SQL 2000
> sp3a server. Its on the same machine so I can't use the copy db wizard.
> Should i use DTS, replication or what. I don't want to deal with orphaned
> users and the like. It should be as seamless as possible.
> TIA,
> jj
>

Auto Shutdown Service Manager

Plz Help me.
Auto shutting down of my sql service manager. what i will start it,
but the server is shutdown after 30 seconds. that is why i can't used any
services. Please to help me, what about to start of my sql service manager
and matained of sql server 2000 (enterprice)? Please answer and good thing.
Plz faster and faster moment.
Thank of all and member.
Saw Oo(Myanmar)
Hi,
For Stopping and starting the SQL Server Service please the Control Panel --
Services option.
Thanks
Hari
SQL Server MVP
"SawOo.ygn" <SawOo.ygn@.discussions.microsoft.com> wrote in message
news:AD9546B7-87BB-4386-BB61-F064D200410A@.microsoft.com...
> Plz Help me.
> Auto shutting down of my sql service manager. what i will start it,
> but the server is shutdown after 30 seconds. that is why i can't used any
> services. Please to help me, what about to start of my sql service manager
> and matained of sql server 2000 (enterprice)? Please answer and good
> thing.
> Plz faster and faster moment.
> Thank of all and member.
> Saw Oo(Myanmar)
>