Can someone please explain how hot backups work with sql server 2008 r2 and sql server 2005 at operating system level. Where available operating systems are windows server 2003 and windows server 2008 r2.
This information is required because when third party tool is used it freezes disk I/O during the time it takes hot backup (during its replication process). Due to frozen disk I/O users get timeouts on a heavily transactional system.
Your help and suggestions are appreciated.