Is it true that you cannot save a backup using the
Database Maintenance Plan to a different server ?
You can type a unc path in the "use this directory" box
when setting up the maintenance plan. The SQL Server service
account needs to be a domain account with appropriate
permissions to the other server, directory.
Backing up to a network location is not necessarily a good
idea. You may want to consider backing up to a local drive
and then copy the backup file to the network location.
-Sue
On Wed, 21 Apr 2004 01:37:27 -0700, "Lucy"
<anonymous@.discussions.microsoft.com> wrote:
>Is it true that you cannot save a backup using the
>Database Maintenance Plan to a different server ?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment