Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Tuesday, August 12, 2014 7:44 AM
Points: 93, Visits: 299
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 @ 8:36 AM
Points: 40,615, Visits: 37,080
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 2008, MVP
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: Tuesday, August 12, 2014 7:44 AM
Points: 93, Visits: 299
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