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 |
|
wided
Posting Yak Master
218 Posts |
 Posted - 2010-06-11 : 05:28:27
|
| helloi use SQL 2000My database became very bigI know how to decrease the log file(I use, DUMP and DBCC SHRINK DATABASE)how about the file .MDFI risk to have problems with my data?Thanks |
|
|
wided
Posting Yak Master
218 Posts |
Posted - 2010-06-11 : 05:30:44
|
| Which is the equivalent of DUMP transaction with file(MDF)How to delete(eliminate) the not used spaces |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SHRINK FILE