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 - 2007-03-12 : 09:28:02
|
| Mahen writes "Hi,I have a SQL server 2000 database which is on Windows 2003. Its data file size is about 20gb. Everything on primary data files and transactional log file is about 500MB. Currently I have two problems,1. As the primary data file keeps growing, do I need to create secondary datafiles and minimise the primary data file growth. Would be there any issue on recovery if the primary data file is very big?2. In this database only two files are taking up more space. the below is detailsTable No of Allocated Used Unusedname Rows Space(KB) Space(KB) Space (KB) ________________________________________________________________table1 51085 10047008 5607376 4439600table2 8442013 4820064 4546704 258936In this table1 allocated space @10GB out of which @4GB was unused. Will these space been used up by the new rows which are inserted to table1. But my database keeps growing everyday.How to release these space to the database. So that it would be reallocated again for the primary datafile.thanks N advance.rgds,Mahen" |
|
|
|
|
|
To use unused space