Re: How to do a backup with sqlmaint in a different directory
From: Carlos Eduardo Rojas (carloser_at_mindspring.com)
Date: 03/18/04
- Next message: Gary Whittle IT Support: "Simple SQL query - totally stuck."
- Previous message: Jerome Smith: "RE: Log Shipping Monitor"
- In reply to: Alfonso Gómez: "How to do a backup with sqlmaint in a different directory"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 18 Mar 2004 16:05:39 -0500
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 Gómez" <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?
- Next message: Gary Whittle IT Support: "Simple SQL query - totally stuck."
- Previous message: Jerome Smith: "RE: Log Shipping Monitor"
- In reply to: Alfonso Gómez: "How to do a backup with sqlmaint in a different directory"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
