ksr39 (9/11/2012)
Hi,Actually I am taking my backup from cmd window with a script it’s a general script to take a backup, but I am taking the backup file to a local drive/disk, as I do in general to a SAN drive/disk through maintenance plan. Will this cause any time variation in taking a backup to a local than to a SAN drive?
Yes. Backing up across the network will absolutely be slower than backing up to a local drive.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning