We are in the process of conversion and therefore we take the snapshots
regularly. Database is around 60GB. So I want to schedule this process
in the night time which saves our time during day and moreover for
system performance too.

Valerian

-----Original Message-----
From: Elam L. Patrick III (CDC/OCOO/ITSO) [mailto:[Email address protected]
Sent: Friday, April 27, 2007 10:51 AM
To: Valerian Rodrigues
Subject: RE: Restore Database Automatically using Schedule Jobs

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Why?

Thanks,
L. Patrick Elam III, BEE
CDC Senior DBA/Developer

SENSITIVE/CONFIDENTIAL INFORMATION
The E-mail message body and attached information may be confidential. It
is intended only for the addressee(s) identified above. If you are not
the addressee(s), or an employee or agent of the addressee(s), please
note that any dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this E-Mail
in error, please destroy the document and all possible attachments and
notify the sender of the error. Thank you.

-----Original Message-----
From: Valerian Rodrigues
[Email address protected]
Sent: Friday, April 27, 2007 10:52 AM
To: LazyDBA Discussion
Subject: Restore Database Automatically using Schedule Jobs

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





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






MS Sql Server LazyDBA home page