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 |
|
bluecosta
Starting Member
1 Post |
 Posted - 2006-03-22 : 15:01:30
|
| Hello guys, I need help, because i'm executing a shrink database file (file with 189 GBytes of size), and i need to stop before it finish. If I stop the shrink process exist any possible that data corruption occurred.Thanks.Best regards,Fernando Costa |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-03-22 : 15:08:27
|
| No, it can't possibly cause corruption. What led you to believe the possibility existed?Side question - why are you shrinking your database?Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine + SQL Express(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-03-22 : 15:10:49
|
| Will it need to rollback Paul? (and thus possibly take as long to rollback as it has done to get to this stage?)Kristen |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-03-22 : 15:20:49
|
quote:
Originally posted by Kristen
Will it need to rollback Paul? (and thus possibly take as long to rollback as it has done to get to this stage?)Kristen
Nope - very common question. All pages are moved in individual system transactions so the most that would have to be rolled back is a single page. Same deal for DBCC INDEXEDFRAG.Assuming he's using SQL 2000+ of course.Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine + SQL Express(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-03-23 : 00:31:17
|
| Thanks Paul, good to know. Hopefully I will never need to power-cycle to stop a long-running shrink!Kristen |
|
|
|
|
|
|
Stop execution of Shrink database