We help IT Professionals succeed at work.

SQL Server 2005 and SQL Server 2008 R2 Hot Backups

536 Views
Last Modified: 2012-07-13
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.
Comment
Watch Question

lcohanDatabase Analyst
CERTIFIED EXPERT

Commented:
"...it freezes  disk I/O during the time it takes hot backup (during its replication process). "

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.

Author

Commented:
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.
lcohanDatabase Analyst
CERTIFIED EXPERT

Commented:
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.

Author

Commented:
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.
Database Analyst
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.