Is it possible to run a backup while the DB is in use?
Normally I would avoid this, but I know that the native SQL backup allows for backups while the DB is in use and I've seen no performance problems when doing that.
I tested this with SQL Backup 6 on maximum compression and found the test server became completely unusable. Is there a set of options that would allow this? Is it just that maximum compression is eating up so much CPU that the server stalls out?
Thanks for your help.
EDIT: I also tried a test backup set at compression level "1" and while it was certainly less intensive than "4" it still made the server essentially unusable.
SQL 2008 x64, virtualized with VMware ESX vSphere 4.1 - the VM has 16GB RAM and the physical server has 2x Quad-Core AMD Opterons.