Re: Database backup on remote server
- From: "Richard Mueller" <rlmueller-NOSPAM@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 6 Apr 2006 21:42:24 -0500
El wrote:
I am new to the world of script and have not created one myself so
appreciated if anyone can help me with the script I have been researching
and
reading douments for:
Here is what the script suppose to peform:
1. Schedule a daily backup of the databse on local computer (eg. computer
name - DD110) at about 12:00 midnight.
2. Destination of the daily backup is to be on another server (eg. server
name - DD111) on the same network.
3. Also create a log file that shows when backup created and status
Appreciated your assistance
Hi,
Depends on the DBMS. For example, SQL Server has T-SQL commands to backup
databases that can be executed in a script. You would use task scheduler to
schedule the script, assigning proper credentials so the scheduled task has
required permissions. The destination would be a share on the remote server.
If you have backup software, it should also have this functionality.
--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
.
- Prev by Date: [MSH] Script parameter without a value
- Next by Date: Re: (MSH) select -ExcludeProperty
- Previous by thread: [MSH] Script parameter without a value
- Next by thread: Re: [MSH] COM Object with indexed property collection - get errors setting property value?
- Index(es):
Relevant Pages
|
