Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2010-01-14 : 18:33:30
|
| Can anyone clarify that during Business hours executing the DBCC CHECKDB and SHRINKING is possible. If so, What are the repurcussions.Thanks all |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2010-01-14 : 22:07:08
|
| Thanks.Can you expand what kind of Blocking will occur? |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-15 : 03:02:06
|
| Likelihood is that tables will be locked by the CHECKDB task, and updates to the table whilst it is locked will be blocked Q.E.D.I think that SHRINKING will block all access to the transaction log ... so that will block all inserts / updatesSo READS should be OK - might be a bit slower though. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2010-01-17 : 17:50:10
|
| Thanks all It worked for me to ascertain with schedules. |
|
|
|
|
|
|
Business hours execution