Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
gow75
Starting Member
2 Posts |
Posted - 2010-05-05 : 12:12:47
|
I am really confused on all the different sql installs, what i mean is you have server, the sql agent sql express. what i understand is that sql server runs on a server the agent installs on a desktop like xp to access the DB on the server and the management studio accesses the db as admin tool from a administrators pc. correct me if i am wrong. i need some overview of all the different install components of sql. |
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-05-05 : 16:03:26
|
No, you've got the SQL Server Agent confused with the concept of a client. The SQL Server Agent is a Windows service, which is installed with SQL Server, no matter where you install it. I have SQL Server Developer edition on my laptop. If I set jobs to perform backups or some other task, these jobs are managed and run by the SQL Server Agent. http://msdn.microsoft.com/en-us/library/ms189237.aspxManagement Studio can be installed anywhere. And it is one way, probably the most common, that you might manage SQL Server. You may want to look at the SQL Server Wiki page. http://en.wikipedia.org/wiki/Microsoft_SQL_Server But the best description I have ever read of the architecture of SQL Server was in the book SQL Server 2008 Internals.===http://www.ElementalSQL.com/ |
 |
|
gow75
Starting Member
2 Posts |
Posted - 2010-05-05 : 16:14:33
|
ok thanks for the tidbit, what is sql server express? also when you say that sql uses the agent for a service does that mean exactly, does it not access the server well than what is the server for, is that only for ODBC connections. |
 |
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-05-06 : 08:41:18
|
The wikipedia article should have information on the editions of SQL Server. You can find more information here: http://www.microsoft.com/sqlserver/2008/en/us/editions.aspxA service is any program that runs in the background on a server or other computer and provides some sort of "service." If you install a web server, for example, the web server program will sit in the background and wait until there is a connection on TCP port 80. When it knows some one is trying to connect on that port it will serve the web page requested.If I have configured a back up on my SQL Server, the SQL Server Agent service waits until the time I have set and then issues the required backup commands. And it would interact with the SQL Server service to accomplish this. Here are some other links you should read:http://en.wikipedia.org/wiki/Client%E2%80%93server_modelhttp://en.wikipedia.org/wiki/Windows_servicehttp://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspxThis PDF has some architectural information:http://media.wiley.com/product_data/excerpt/40/04702570/0470257040.pdfBut from the sounds of things you really need to read an introductory book. What sort of IT related experience do you have so I can point you in the right direction?===http://www.ElementalSQL.com/ |
 |
|
|
|
|
|
|