Help with Backup Best Practices
1) Any suggestions on how to best run backups when there is a possibility of a huge file being imported? Will the backup take significantly longer if this happens? We have noticed the import does take much longer during a backup.
2) Is there a graceful way to kill the RedGate backup process? Should certain things be tried first?
3) How can we check if a backup process is in place before starting the import process? If we could stick some code in a procedure (or check in an SSIS package) to delay the import, that would probably be ideal.
Thanks for any help.