SQL Database too big?

[sebastiaan]

Hello,

We are running a ADMS 2008, which is working fine. But I just checked the properties of our database and I noticed that our file size is 26 GB but out database is 38 GB big.

I read something about a MS SQL Maintenance Plan, is that a good idea and does this help to increase the database size?

Looking in the database I can find that the file database is only 2,2 GB, but the transaction log is 37 GB big.

The reason I am asking how to make this smaller is because we only have 850mb left on the sever for the database 😞

If someone can help me out, I would be thankful!

[Anonymous]

Hi Sebastian,

Alternative to do downsize the database: setting up of remote file store
server to host ur files.

ADMS 2008 support remote file store, where user could utlilise another
machine to mange the files. This will greatly reduce the hard disk space by
having ADMS 2008 + file store + database kept in a physical machine.
You may refer to following guide, section "managing a remote file store" for
instruction/steps.
http://usa.autodesk.com/adsk/servlet/ps/dl/item?siteID=123112&id=9594013&linkID=9240618

hope it helps.

rgds,
Chear Huat.

"sebastiaan" wrote in message news:5936900@discussion.autodesk.com...
> Hello,
>
> We are running a ADMS 2008, which is working fine. But I just checked the
> properties of our database and I noticed that our file size is 26 GB but
> out database is 38 GB big.
>
> I read something about a MS SQL Maintenance Plan, is that a good idea and
> does this help to increase the database size?
>
> Looking in the database I can find that the file database is only 2,2 GB,
> but the transaction log is 37 GB big.
>
> The reason I am asking how to make this smaller is because we only have
> 850mb left on the sever for the database 😞
>
> If someone can help me out, I would be thankful!

[sebastiaan]

Hi Chear,

thanks for the suggestion. It is an option, but we don't have a spare server left on that location 😞 So for now we have to work on one server.

Is there any way to downsize the logfile of the database?

Thanks.

[cube1972]

Sebastiaan,

It looks that your SQL Recovery model is not right. Use Simple instead of Full on your specific Vault database. Shrink the database after setting the correct value. This will downsize your log file. Take a look at the advanced configuration guide to implement these changes.

This guide will also help you to implement a maintenance plan for your SQL database.

[Anonymous]

Hi there,

YES! This is too big... There should be no reason it's this large. Please
check out the "Maintenance Plan" as you mentioned.

It's fully documented in this guide:
http://usa.autodesk.com/adsk/servlet/ps/item?siteID=123112&id=5477548&linkID=9261340

Also note in this document there are two differnet versions. One for if you
have full SQL (which you must) and one for SQL Express via a script. Please
follow the apporpriate version.

Report back to us the size changes. I'm feeling like it will decrease
dramatically!

[Anonymous]

Addtional comment is:

After run the maintance plan to clean the log file, we can upgrade the SQL
Server 2005 to SP2; otherwise, the log will increase sharply after few days.

Thank you,
Frank Ran

; "Inc.)" wrote
in message news:5938062@discussion.autodesk.com...
Hi there,

YES! This is too big... There should be no reason it's this large. Please
check out the "Maintenance Plan" as you mentioned.

It's fully documented in this guide:
http://usa.autodesk.com/adsk/servlet/ps/item?siteID=123112&id=5477548&linkID=9261340

Also note in this document there are two differnet versions. One for if you
have full SQL (which you must) and one for SQL Express via a script. Please
follow the apporpriate version.

Report back to us the size changes. I'm feeling like it will decrease
dramatically!

[sebastiaan]

Solved! Thanks for all suggestions and replies.

After setting up the Maintainance Plan the database log file shrinked back to 2GB.