| Author |
 Topic  |
|
|
realnus
New Member
Turkey
77 Posts |
 Posted - 27 November 2005 : 18:51:38
|
Hi , My forum database has reached to 54 Mb and There are about 40000 posts in the forums . So , I decided to convert my access Db to mssql db.
My Questions :
1) My database has reached to 54 Mb in one year and it will keep on increasing . So , If I convert my database I will make it 250 Mb . If one day it reaches to 250 Mb , Am I able to increase it again ? (logically this must be done , but I need confirmation ,I am trying to learn mssql )
2) What does log file do ? With database I must use a log file as I see. What must be the size of the log file ... How will I decide its size ?
3)I have comverted my access database to mssql database , it works well but while creating categories I get an error
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'FORUM_ID', table 'snitz_mssql.dbo.FORUM_FORUM'; column does not allow nulls. INSERT fails.
/yeni_site/post_info.asp, line 1349
and in post_info.asp the code block is this
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
So , As I have understood according to mssql database logic the fields properties must be set properly .No null entries allowed
As you see , I am a starter with mssql and still reading articles about it. If you answer my questions I will be glad ...
Thanks. |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
realnus
New Member
Turkey
77 Posts |
Posted - 27 November 2005 : 20:25:36
|
Thanks for the answers ruirib ,
I have read more articles and started to understand more about the settings .
I am posting some images and I want to talk about thoose ones.
As you see it shows "Number of users" as 1
Does this mean only 1 user can connect the db at the same time (users of my forum) ? (or the determined admin account for the db is 1.)
When I converted the db , automatically "unrestricted file growth" had been selected.So I dont worry about the db limit .It will always grow (is this true?)
And one more question about this. Is there an advance of making the database with limited size ?
As I read in articles , for example if a data is inseted to database , firstly this action is recorded to translaction logs and then the operation (or writing/deleting to db) is done.So the log file size seems to be importent .If the log file is exceeded the db will stop working.(Am I wrong about this? Do I need to delete translaction logs with a period?
Do you advice me to change any setting with this screen? For ex. "Auto Close" is used for what .Does it automatically close the connections in 20 minutes (I thought about this as default timeout)
Thanks and sorry for too many questions 
|
Edited by - realnus on 27 November 2005 20:30:37 |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 28 November 2005 : 04:00:03
|
1. It means you have added permissions for a single user to access the database. Quite likely that's the user you've specified in your connection string. Whenever someone uses the forum, the user accessing the database is the one you specified in the connection string.
2. Yeah, size will always grown unless there is no more free disk space.
3. Yeah, logs are important. Do not mess with them. Let SQL Server handle it.
4. I would select Auto shrink. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 28 November 2005 : 05:06:59
|
quote:
Originally posted by ruirib
3. Yeah, logs are important. Do not mess with them. Let SQL Server handle it.
Excellent 
As it happens, realnus, there are some AWESOME articles in 'Books Online' (Help for SQL Server) located probably in the 80\Tools\Books\ folder of your SQL install. If you want to understand logging etc properly, try reading through these - you'll quickly see why Rui suggests they're important! Fact is SQL Server is an enterprise-grade db engine, so it does some things way in advance of what Access can handle/do, and it's as well to start learning about the differences.
Slightly off-topic (as is my way...) - We have people here come for interview believeing themselves to be 8 or 9 /10 at 'SQL Server', yet the true expert will never estimate themselves above a 6-7...there is a lot to learn in there |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 28 November 2005 : 06:00:43
|
quote:
Originally posted by pdrg
[quote][Slightly off-topic (as is my way...) - We have people here come for interview believeing themselves to be 8 or 9 /10 at 'SQL Server', yet the true expert will never estimate themselves above a 6-7...there is a lot to learn in there
That is so true. There is so much to know about SQL Server... I couldn't live without a very good reference book near me, and I resort to it quite frequently, specially on matters I deal with less frequently. And with the 2005 version out, a lot more to learn yet. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
realnus
New Member
Turkey
77 Posts |
Posted - 28 November 2005 : 19:47:21
|
Thanks for the replies ruirib. I know that this is a sea and there are too many miles to swim and I started. Tomorrow I will buy a mssql book and start to read from the beginnig.
I may ask some general questions and I will need your experiences .
Let the MSSQL be with u |
Edited by - realnus on 28 November 2005 20:41:36 |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
|
| |
Topic |
|
Topic Locked
