Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Will doing a backup slow down the system Expand / Collapse
Author
Message
Posted Tuesday, July 23, 2013 3:38 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, October 15, 2016 12:40 PM
Points: 93, Visits: 305
Hi

I need to do a backup of our database I was just wondering if I could do it during normal working hours without bringing everything to a grinding halt.
Or should I wait until out of hours?

Thanks
Matt
Post #1476439
Posted Tuesday, July 23, 2013 3:51 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 5:18 AM
Points: 45,619, Visits: 44,147
A backup does a huge amount of IO. If your system is not bottlenecked on IO, if the additional load the backup puts in place doesn't impact queries trying to read data, then the impact may not be noticable.


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1476450
Posted Tuesday, July 23, 2013 3:55 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, October 15, 2016 12:40 PM
Points: 93, Visits: 305
Okay thanks Gail, I think I'll leave it until after hours to be on the safe side
Post #1476456
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse