Avatar of ezkhan
ezkhan
Flag for United Kingdom of Great Britain and Northern Ireland 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.
Microsoft SQL Server 2008Windows Server 2008Windows Server 2003

Avatar of undefined
Last Comment
lcohan

8/22/2022 - Mon
lcohan

"...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.
ezkhan

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.
lcohan

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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ezkhan

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
lcohan

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question