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 - 2003-07-03 : 07:33:31
|
| Jean writes "Hi, Excuse the simplicity of the question but I am relatively new to SQL. I have set up a database with unrestricted growth and have a DTS package that takes data from another system and copies it into my database. The database data file grew to 14GB yesterday and so I had to delete the database and re-create it. I created a new database and unchecked the box 'automatically grow database' however when I tried to run any DTS' it stated that "there was no more pages in filegroup PRIMARY". I found a way to increase the filegrop primary but I thought it might be a better idea to COMMIT and then truncate the data file each night? This would prevent it from reaching 14gb. What do you think? if so how do I committ and truncate the data file i.e. what is the sql statement? Any help is appreciated.Cheers, Jean" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-03 : 13:42:40
|
| I would imagine as soon as DTS ends a COMMIT is performedYour losing me on the TRUNCATE bit though. TRUCATE is a very specfic word in sql server. What do you mean by TRUNCATE?Brett8-) |
 |
|
|
|
|
|
Commit and truncate the data file (.mdf)