Skip to content

Reduce DataBase Size

Hosam EbrahimMember for 15 years
Created
1
2
0

Dear friends,

iam usin p6 v8.1, sql

the data base is very slowww. the MDF file size is 3.40 GB and LDF file size is 5kb . i tried to delete some projects to decrese the size of MDF file to make it more faster, but the surprise that after seleting 4 projects the size is increased to 3.5 GB. I made shrink for the data base but this dosn't help. there is one file on these forums oncluding some queries like:

update statistics project with fullscan ,all
update statistics task with fullscan ,all

&

exec sp_updatestats

But also this doesn't help. and the problem is the data base became more slower after deleting these projects.

Please i need quick help

Thanks

1 reply

Oldest first
  1. 0
    Alexandre Faulx-Briole ·

    Hosam,you should ask the

    Hosam,

    you should ask the question on a microsoft sql server newsgroup

    Alexandre

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?