cant backup at others directory | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

cant backup at others directory

i already create a new maintenance plan for backup my date files and transaction log….
i schedule the task every day…..but now i face a problem… The problem is when i request backup all this files at others server but it failed…because it just allow me backup at my local pc only….
May be sql agent service don’t have the access to to write the backup file to other location.
Make sure sql agent have the acess and use UNC name for backup… exec xp-cmdshell ‘dir <Newbackup folder with path>’ and see what error you get…
Moderator All postings are provided “AS IS” with no warranties for accuracy.

I believe it is one of the best practice to create backup locally and use another process to copy that backup file to another location, than using a direct backup on network location. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.