Hello all



Is there any way to schedule a job to restore the database automatically
in SQL 2000 and very important to set or define the location of Data
files (MDF) and transactions files (LDF)?



Eg if we have backup the database on mapped x: drive as Dbtest.bak. We
need to schedule it automatically so that it restores this database as
DBReport. But DBreport.mdf file should reside on D: drive and DBreport
_log.ldf should reside on H: drive



If possible, can I have this script to execute this automatically?



Thanks & Regards



Valerian




MS Sql Server LazyDBA home page