Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Decreasing data file

Hi,

i have 3 databse files on my sql server 2000 - (ecc6 is installed).

one of the files has the following size - 300GB ,30GB of it are free space.

i have 2 questions - first, can i decrease/shrink the 300GB file in about 20GB on account of the 30GB free space?

second what is the recommended structure for optimized performance - in which size of the datafile - should i add another new datafile ?

Regards,

Moshe

Former Member
Not what you were looking for? View more on this topic or Ask a question