| Author |
Topic |
|
boni
Starting Member
9 Posts |
 Posted - 2009-07-29 : 14:06:10
|
| I entered to the logs in the SQL manager and all of them are empty.I also tries to define defualt log files directory but nothing help.The server is working and I login using sa account.SQL server 2005 exspress.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
boni
Starting Member
9 Posts |
Posted - 2009-07-29 : 15:22:54
|
Hi,Thanks for your response.I am looking for the basic logs file: activity log, who log on, to which port the server is listinning and all the other logs.something like this [url]http://www.mssqltips.com/tip.asp?tip=1021[/url].I try reach it by open: "SQL Server Management Studio Express" log in using sa account, in the object explorer under the BD instance I press on "Managment" and then "SQL server Logs".there are 7 "logs": current and archive #1-#6 all are empty with creation date of the two last days.Thanks (and sorry for the multi question publish, i did not know which forum is the right one).quote:
Originally posted by tkizer
What logs are you referring to?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong."
|
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-07-29 : 18:36:47
|
| You've probably got a job setup that is cycling through the logs and that's why you don't see any data in them. If you didn't have this cycling happening, then you'd at least see startup information which would include the port number.For activity, you'd use activity monitor, sp_who/sp_who2 or master..sysprocesses.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
boni
Starting Member
9 Posts |
Posted - 2009-07-30 : 02:03:17
|
Thanks for your response.1. What do you mean in: "job setup that is cycling"?2. "at least see startup information", I do not see it (that what I search from the beginning).3. "use activity monitor" - when I double click on it, there are two activities (defualt filter), but nothing informative.4. Whare to find "sp_who/sp_who2 or master..sysprocesses", I cannot find it at the activity monitor.Thanks.quote:
Originally posted by tkizer
You've probably got a job setup that is cycling through the logs and that's why you don't see any data in them. If you didn't have this cycling happening, then you'd at least see startup information which would include the port number.For activity, you'd use activity monitor, sp_who/sp_who2 or master..sysprocesses.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong."
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-07-30 : 12:46:31
|
| If your error log is empty, then you've got some process that is cycling it. Cycling of the error logs are done with sp_cycle_errorlog, so you'll need to find out if that is scheduled as a job somewhere.You don't see the startup information because something or someone is cycling the log.Activity monitor doesn't show much information because there's nothing happening on your server.sp_who/sp_who2/ and master.sysprocesses are run via queries. Do you have a DBA that you can work with?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
boni
Starting Member
9 Posts |
Posted - 2009-07-30 : 13:50:40
|
| I realy do not know what to do.This is regular installation. Maybe I will reinstall? (I cannot uninstall and install again because I cannot export the tables in the express version)."Process that is cycling it" - How can I find it? Who can run it? There is any relevant log? Maybe password change will help?BTW, as I wrote, I defined defuald log dirrctory but it is alwayes empty.I run sp_who/sp_who2/ and master.sysprocesses queries but did not find something interesting (should I look for something special).And, I do not hava a DBA to work with.Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-07-30 : 16:22:43
|
| A password change will not help. Check the SQL Agent jobs to see if you have a job cycling the log. You said you wanted to look at the activity log, so that's why I directed you to the activity monitor which provides similar information that sp_who/sp_who2/sysprocesses show. I don't know what you want to do with the activity, so I can't tell you what to look for.Who setup this system?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
boni
Starting Member
9 Posts |
Posted - 2009-07-31 : 02:41:19
|
I setup the software.I am looking for log activity - which user login and when.Thanksquote:
Originally posted by tkizer
A password change will not help. Check the SQL Agent jobs to see if you have a job cycling the log. You said you wanted to look at the activity log, so that's why I directed you to the activity monitor which provides similar information that sp_who/sp_who2/sysprocesses show. I don't know what you want to do with the activity, so I can't tell you what to look for.Who setup this system?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong."
|
|
|
|
boni
Starting Member
9 Posts |
Posted - 2009-08-06 : 12:50:40
|
quote:
Originally posted by boni
I setup the software.I am looking for log activity - which user login and when.Thanksquote:
Originally posted by tkizer
A password change will not help. Check the SQL Agent jobs to see if you have a job cycling the log. You said you wanted to look at the activity log, so that's why I directed you to the activity monitor which provides similar information that sp_who/sp_who2/sysprocesses show. I don't know what you want to do with the activity, so I can't tell you what to look for.Who setup this system?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong."
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cyoungbe
Starting Member
2 Posts |
Posted - 2009-08-12 : 20:46:15
|
| Sometimes when people think they know everything they over look the simple. I hope this answers you question.You can not view " SQl Server Logs" from Sql Server Management Studio Express. It's a limitation from the product. Paraphrased from another source - The SQL Server Management Studio Express version of Object Explorer is limited compared with its equivalent incorporated in SQL Server 2005 Standard. Among the most prominent examples of this disparity is the lack of Log File Viewer (which complicates the task of monitoring SQL Server logs).To view the logs you need to install a full version of SSMS.Good Luck |
|
|
|
boni
Starting Member
9 Posts |
Posted - 2009-08-13 : 01:48:28
|
Thanks for your answer.When you wrote: SSMS did you mention to this http://www.ssmstoolspack.com/? or the full version of Server Management Studio.In other words the express version us lacking this feature?Thanksquote:
Originally posted by cyoungbe
Sometimes when people think they know everything they over look the simple. I hope this answers you question.You can not view " SQl Server Logs" from Sql Server Management Studio Express. It's a limitation from the product. Paraphrased from another source - The SQL Server Management Studio Express version of Object Explorer is limited compared with its equivalent incorporated in SQL Server 2005 Standard. Among the most prominent examples of this disparity is the lack of Log File Viewer (which complicates the task of monitoring SQL Server logs).To view the logs you need to install a full version of SSMS.Good Luck
|
|
|
|
cyoungbe
Starting Member
2 Posts |
Posted - 2009-08-13 : 11:52:39
|
| The full version of studio. |
|
|
|
datherton
Starting Member
1 Post |
Posted - 2011-02-07 : 12:12:45
|
| Hey All,Couple of points..1) @Tara, SQL 2005 Express does not have Agent Services2) Simple way to read logs is to dig into the SQL install directory, find the log folder and open via notepad or other text reader...old school.HTHDave |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-02-07 : 17:22:31
|
| Hey Old School, couple of points1) express with advanced services does2) did you notice this topic was 18 months old? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
SQL logs are empty!