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 |
|
0341
Starting Member
21 Posts |
 Posted - 2007-09-12 : 10:35:19
|
| I was able to shrink my trn log easily and quickly but my data file is 66 GB. It is taking forever to shrink from 66 GB to 2 GB. Is there another way around this. I once heard that you could detach the database and then delete the trans log file and it would recreate itself in a shrunken state. Will this work for the Data file as well or is there another way around it?-Phil |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-12 : 10:48:09
|
| if you've already shrunk your log file, then your problem is solvedif you want to shrink the data file, you need to determine how much space is used, that's the least size you can shrink it into--------------------keeping it simple... |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-12 : 14:32:40
|
| Something is probably blocking the Shrink. You might need to shrink it in small-steps, rather than all-in-one-go.Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-12 : 14:54:50
|
quote:
Originally posted by 0341
I once heard that you could detach the database and then delete the trans log file and it would recreate itself in a shrunken state. Will this work for the Data file as well or is there another way around it?
Do not do this with your data file!Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Large data file