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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-11-14 : 11:28:45
|
| suresh writes "Dear sir,MDF file running on SQL 2000 Server is growing rapidly in our server. Which is unable for us to feed the data quickly. Presently it is 3 GB has no picture or diagram data only customer information. If it grows lik this, it even touches 1 TB within one year.Kindly help me out to control the database and work easily." |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-14 : 11:51:36
|
| Suresh, if you live in India, do not set USA as country.Is it the database or the log file that is growing? Take backups regurlary.Otherwise the only solution is to either buy more/larger disks, or move the database to a SAN.Peter LarssonHelsingborg, Sweden |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-14 : 12:04:52
|
| ... or purge stale data |
|
|
|
|
|
|
database