Re: Using maint plan to backup db to network drive
- From: "Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 11 Sep 2007 22:58:12 +0200
This should be a good starting point: http://support.microsoft.com/kb/555128/en-us
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ehren" <Ehren@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:C92C0638-0CAC-4292-BAAF-641AEDB0337F@xxxxxxxxxxxxxxxx
Hello-
In setting up our system imaging software I wanted to move our database
backup files off of the actual database system and move them to a data
warehouse server. I would like to use the database maintenance plan to put
the .bak file for each database on either a mapped network drive or more
preferrably a UNC path to a network share.
I see that when I click browse to select the backup location it allows you
to only select a local disk. If I type in a mapped network drive path or a
UNC path it says its invalid but lets me enter it anyway, however when the
job runs it fails.
is there a way to make the backups to a remote system or is the only option
to back it up to a local disk and then manually move them elsewhere?
Thanks much in advance!
.
- Prev by Date: Re: Generate SQL scripts in Management Studio
- Next by Date: ANN: MS SQL Field Box 1.7
- Previous by thread: Re: SQL Profiler 2000
- Next by thread: ANN: MS SQL Field Box 1.7
- Index(es):
Relevant Pages
|
