October 1, 2014 at 12:09 am
Hi All,
We have a maintenance Plan on our production environment, which basically performs backup up on our Databases to a drive in the machine.
Now, due to rapidly growing Database size, we have to shift Backup Store Location from Machine to a Storage drive offered by the IT Team. I.e. instead of Storing Backup file first on Machine and then move it to storage location, we want Maintenance Plan job directly to save backup file to Storage location.
I see in Backup Database Task a Property for DestinationAutoFolderPath. Is this property can handle Storage Path location or there is any other approach.?
Machine has all rights to access Storage Location.
Will appreciate Quick Response from you guys.
Thanks and Regards
October 1, 2014 at 4:38 am
In Backup Database Task a property Folder set to Storage Location.
The account under which SQL Server is running must have access to the Starage Location.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply