ezkhan
asked on
SQL Server 2005 and SQL Server 2008 R2 Hot Backups
Hi,
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.
Thanks.
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.
Thanks.
ASKER
Actually i have to explain to senior management how hot backup works at operating system and sql server level and in what sequence resources are locked and released during hot backup process. As we are investigating "I/O Freeze" issue.
Your valuable comments and suggestions are appreciated.
Thanks.
Your valuable comments and suggestions are appreciated.
Thanks.
Ok lets clarify few things here:
1. "This information is required because when third party tool is used it freezes disk I/O during the time it takes hot backup" - What IS the third party tool?
2. What IS the "third party tool" doing? Replicating your SAN SQL Backup files OR...
3. Your "third party tool" is backing up SQL DB's by Replicating SAN LIVE DB files?
In case of the 3.rd to be true you should in my opinion:
A. Read "third party tool " documentation and find how to use "throttling" or to avoid IO issues
B. Check with the Vendor of the tools and ask them what you can do to eliminate the IO Freeze issues.
1. "This information is required because when third party tool is used it freezes disk I/O during the time it takes hot backup" - What IS the third party tool?
2. What IS the "third party tool" doing? Replicating your SAN SQL Backup files OR...
3. Your "third party tool" is backing up SQL DB's by Replicating SAN LIVE DB files?
In case of the 3.rd to be true you should in my opinion:
A. Read "third party tool " documentation and find how to use "throttling" or to avoid IO issues
B. Check with the Vendor of the tools and ask them what you can do to eliminate the IO Freeze issues.
ASKER
Sorry for late reply, FalconStor is the software used for replication and network member of staff suggesting there is no throttling option available. Any reflection on that please.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did you checked the network bandwidth in Task Manager for instance?
Also usually 3rd party backup tools have a neat feature like "throttling" where you can "push" your backups to go "faster" or "slower" depending on your IO bandwidth.