Sunday, February 19, 2012

How to do a backup with sqlmaint in a different directory

Somobody know how to say to sqlmaint in which directory do the backup to avo
id use the default directory?Go to database maintenance plans in enterprise manager and edit your plan
there. There's an option to specify the directory where you want your
backups stored. If you're storing backup files on a different server, use a
UNC path, for example \\remoteserver\sharename
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Alfonso Gmez" <anonymous@.discussions.microsoft.com> wrote in message
news:61C9EEB0-9639-48A2-B0E4-6C2AAC7A9330@.microsoft.com...
> Somobody know how to say to sqlmaint in which directory do the backup to
avoid use the default directory?

No comments:

Post a Comment