Re: Backup on a remote server
From: Roger Svensson (roger.svensson_at_fyrklovern.se)
Date: 02/18/04
- Next message: tradmusic: "what is MSSQL NEWID() in Access?"
- Previous message: Christian Smith: "Re: => Data Transformation Services"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 18 Feb 2004 17:03:08 +0100
Hi,
It works fine to backup to a remote server with a maintenance plan! Just map
a network drive to the remote server share and manually type (browsing won't
work) this drive letter in the "Use this directory" field on the maintenance
plan property page. Don't forget to make the sql server service use an
account with sufficient permissions on the remote server though.
/Roger
"Jun Soriano" <anonymous@discussions.microsoft.com> wrote in message
news:4C041E6F-D81D-471A-A27F-C8E501674E41@microsoft.com...
> I'm using SQL 7.0 in win2k. I'm using 2 harddisks partitioned into 2 and
both partitions are mirrored. One is for system and the other one I'm using
for database. I'm doing a comlete daily backup of 2 critical databses which
eats up 500MB per database. My question is, is it possible to use a remote
server or storage and configure SQL to automatically backup those databases
there? Because when I tried to map a storage that I want to use forthe
backups, I didn't see it in the "choose backup destination". What I'm
basically doing now is to backup the databases in the system partition on
the SQL server and move it to the remote storage manually from time to time.
Do you know of any simpler method?
>
> Thank you.
>
- Next message: tradmusic: "what is MSSQL NEWID() in Access?"
- Previous message: Christian Smith: "Re: => Data Transformation Services"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
