Using maint plan to backup db to network drive

11 Sep 2007 7:28 PM

Ehren

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!

11 Sep 2007 8:58 PM

Tibor Karaszi

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

Show quote

"Ehren" <Eh***@discussions.microsoft.com> wrote in message
news:C92C0638-0CAC-4292-BAAF-641AEDB0337F@microsoft.com...
> 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!