how to design a database for log ?

Question

Dear everyone.

i am a biginner to use a sql.

i don't have a idea how to design a database.

i need to write a log from device like serial , tcp/ip to a database.

could you teach me how to design a database ?

for example) if the log size is bigger , Do i need to create other database file ?
if i create a several table in same database , is it ok if the log size is bigger

---- A database file -------------------------------------------------------------------
|                                                                                                              |
|   B Table,                           C Table ...... N Table                                      |
|                                                                                                              |
------------------------------------------------------------------------------------------
i want to use linq to manage a database
how to manage a database like this kind of project.?

---

lightdoll

Answer 1

You can create a database from Management Studio Object Explorer.

You can set the database file size to autogrowth or set a fixed limit.

After creating the db, you can also design and create a table in Object Explorer.

---

Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com

Answer 2

Hi,

Adding to Kalman Toth's suggestion,

You can find a lot of useful informatin about SQL Server in Books Online, it is a basic SQL Server reference book.

Download SQL Server 2005 Books Online here:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f

Download SQL Server 2008 Books Online here:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=765433f7-0983-4d7a-b628-0a98145bcb97

---

ChunSong Feng
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 3

Thank you for your reply.

My application will write lots of log to db, because we need to write  datas from Serial, and tcp/ip to db under 100ms?
so i don't know how to manage a db file.
what is an advantage if i chose autogrowth?

can i make a database from linq or C# by programming?

can i use linq if i chose vs2005?

do you know any sample like this kind of situation?

thanks...^^

---

lightdoll

Answer 4

Hi lightdoll,

--> how to manage a db file.
It is not easy to manage a database, you need to consider security, performance and many other things. I found some learning resources here:
http://www.microsoft.com/Sqlserver/2005/en/us/learning-resources.aspx

-->what is an advantage if i chose autogrowth?
A KB article talks about it, see here:
http://support.microsoft.com/kb/315512

--> can i make a database from linq or C# by programming?
Yes, have a look at SQL Server Management Objects (SMO), see here;
http://msdn.microsoft.com/en-us/library/ms162169.aspx

-->can i use linq if i chose vs2005
LINQ is a feature of .NET Framework 3.5, so you may need to use Visual Studio 2008, see here:
http://msdn.microsoft.com/en-us/library/bb386976.aspx


Hpe this helps! If you have any concern, please feel free to let me know.

---

ChunSong Feng
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 5

Dear ChunSong Feng

Thank you for your reply.

It will be help me learn SQL ,and make a my project.

Thank you very much...^^

---

lightdoll