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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2007-06-20 : 03:47:47
|
| After removing data from a data base to a archive database my data file did not decrease in size would you susgest that I shrink the data file with truncate only, I've done this on the log file because I was doing a lot of transaction on the database moving data out of it so the log file did grow but not is back to a normal size |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-20 : 05:13:39
|
| See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Database%20Shrinking,Shrink,Shrinking |
 |
|
|
|
|
|
shrink data file and log files