https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 22:36:52 +0000 Thu, 16 Mar 2006 15:35:15 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18729 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101488.html#101488 Author: Ozoyo
Subject: 18729
Posted: 16 March 2006 at 3:35pm

BoRg, that's brilliant, I will do that 

Thanks again!


]]> Thu, 16 Mar 2006 15:35:15 +0000 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101488.html#101488 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101484.html#101484 Author: WebWiz-Bruce
Subject: 18729
Posted: 16 March 2006 at 3:05pm

The reason why I mention SQL 2005 Express is because is is FREE.

It's basically a cut down version of SQL Server 2005 with some limitations such as a 4gig database size limit and 1 CPU, but none of the other limitations of the Express version will effect the running of Web Wiz Forums as they are the more complex tools that are not required for Web Wiz Forums.

I plan on moving this site across to SQL Server Express 2005 very soon as currently the site is running on MSDE which is a free cut down version of SQL 2000 which has an 8 concurrent user limitation which is occasionally is coursing issues when under heavy load. SQL Express 2005 doesn't have this limitation.

Have a look on the Microsoft site, you can download it from there and it explains what the differences are between the Express version and the full version of SQL Server 2005.

I personally believe that MS bought the Express version out for things like web sites in response to loosing so much ground at this type of level to mySQL.


Edited by -boRg- - 16 March 2006 at 3:09pm]]> Thu, 16 Mar 2006 15:05:50 +0000 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101484.html#101484 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101475.html#101475 Author: Ozoyo
Subject: 18729
Posted: 16 March 2006 at 1:47pm

boRg, thanks a million for your answers.

If I have to go for the dedicated option I would have to pay thelicence but I am willing to do that to get the site out of trouble.Then I will have to think on how to generate revenue...
What's the MSSQL 2005 Express licence cost?

There is new version of the site coming (soon I hope) but for themoment, the site will keep generating 0€ a month. That is why I wastrying to solve that size problem to please my host.

If the licence is reasonable enough I will do what you said. Then I will have the proper rights to manage the DB as I wish.


]]> Thu, 16 Mar 2006 13:47:44 +0000 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101475.html#101475 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101473.html#101473 Author: WebWiz-Bruce
Subject: 18729
Posted: 16 March 2006 at 1:36pm

You can change how your SQL Database is setup (if you have the correct permissions) in the Enterprise Manager by right clicking on your database and selecting properties. All the growth blocks, recovery model, and auto-shrinking features are in there.

Transferring one SQL Database to another is quite simple as the Enterprise Manager has DTS import/export tools built in to do this exact job.

If you need to go down the dedicated server root, it maybe worth looking at having a dedicated server for your entire site and installing SQL 2005 Express on the server for your database, you would then have full control over the whole server.

I would also go for a dedicated server with at the very least 1gig of memory.
]]> Thu, 16 Mar 2006 13:36:58 +0000 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101473.html#101473 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101471.html#101471 Author: Ozoyo
Subject: 18729
Posted: 16 March 2006 at 1:17pm

385441 Posts in 12760 Topics in 8 Forum(s). But only 1678 members (heavy posters!)

The size of your forum seems much more reasonable...

That block thing seems interesting, is that complicated to do?
I think we agree on the fact that 1.5 gigs is not normal, I will try to ask an IT guy on my forum for advice.

The DB has never been shrunk since it was created and I think this is the main problem.

My host proposed to put the DB on my dedicated server with a 79€licence /month. but I am faraid moving it is not going to be verystraight forward. I still remeber the hell it was to transfer data fromAccess to SQL .



]]> Thu, 16 Mar 2006 13:17:46 +0000 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101471.html#101471 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101470.html#101470 Author: WebWiz-Bruce
Subject: 18729
Posted: 16 March 2006 at 1:08pm

Sorry I'm not an expert on managing SQL server, this is something that an SQL Server Admin would need to do for you.

1.5G does seem like allot, but then you haven't mentioned how many posts, members, etc. you have in the database!! Would be interesting to know.

All I can tell you is that the forum on this site has an SQL Server database of 95Mb and has 93,000 posts and 9,000 members, as well as having another 20 tables in the database for other ASP applications running on this site.

I have the SQL Database set to grow in blocks on 5Mb, to auto shrink, and using the simple recovery model.

Unless you have around 1 million posts 1.5Gig seems like allot, so I would think that your SQL Server database is not setup correctly and would ask the SQL Server Admin to have a look at the issue as your forum will not be performing as fast as it should.


Edited by -boRg- - 16 March 2006 at 1:09pm]]> Thu, 16 Mar 2006 13:08:20 +0000 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101470.html#101470 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101469.html#101469 Author: Ozoyo
Subject: 18729
Posted: 16 March 2006 at 12:55pm

Hi, I have the same problem, only on a larger scale.

My MSSQL database is now 1,5 Gigas!!!

I have issue with my host who wants to throw me out of the shared MSSQL server (and I can understand why).

boRg, I have always been using your method (simple recovery) and thelogs are only 1 Meg. So it is really the data part that is over 1.5gigs.
I have been deleting regularily posts older than 6 months but, from what I understand (that is little ) it is no use cleaning up without shrinking the DB.

So I would have two questions:

> Is 1,5G a reasonable size for 6 months or more of posts. If not, what is the approximate standard?

> Would shrinking and setting up an automatic shrink solve this problem?

Thanks

]]> Thu, 16 Mar 2006 12:55:52 +0000 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101469.html#101469 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101464.html#101464 Author: WebWiz-Bruce
Subject: 18729
Posted: 16 March 2006 at 12:13pm

Make sure that you have setup the SQL Database to use the 'simple recovery model' and that you have set the log files to be only a maximum of around 2Mb.]]> Thu, 16 Mar 2006 12:13:08 +0000 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101464.html#101464 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101396.html#101396 Author: GeorgeB
Subject: 18729
Posted: 15 March 2006 at 8:22pm

Hi,

I have upgraded my access database to ms sql. My access db was around 15 mb. After converting the database to ms sql, its size has increased to 50 mb. Also i m not receiving to much post in these days , but database is increasing heavly (82 mb now). What can i do to decreasly db size?

Thank you. ]]> Wed, 15 Mar 2006 20:22:43 +0000 https://forums.webwiz.net/ms-sql-db-size-problem_topic18729_post101396.html#101396