Is it true that you cannot save a backup using the
Database Maintenance Plan to a different server ?Yes see http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dbmntwiz/dbmntwiz_8ovt.asp
>--Original Message--
>Is it true that you cannot save a backup using the
>Database Maintenance Plan to a different server ?
>.
>|||Dang
Thanks
>--Original Message--
>Yes see http://msdn.microsoft.com/library/default.asp?
>url=/library/en-us/dbmntwiz/dbmntwiz_8ovt.asp
>
>>--Original Message--
>>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