Solved

ms SQL server 2005 not saving logs

Posted on 2014-02-19
6
215 Views
Last Modified: 2014-04-13
ms SQL server 2005 not saving logs, i see 5 log files in sql 2005 express version. but they are empty. Using sql management studio.

How do i get it to save events in the sql log??

thanks
john
0
Comment
Question by:john
  • 3
  • 2
6 Comments
 
LVL 35

Expert Comment

by:David Todd
ID: 39872508
Hi,

If in simple recovery mode, and not much current activity in the database, of course the transaction logs would be empty.

Whereabouts in SSMS? Can you provide a screenshot of what exactly you are looking at?

Many thanks
  David
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39880057
Are you referring to the SQL Server Error Logs?
0
 

Author Comment

by:john
ID: 39885156
attached is the logs I am looking at. it does full backup nightly.
I am looking for sql errors.
all log files are empty show in attachment.
sqlerrorlogs.GIF
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 35

Expert Comment

by:David Todd
ID: 39886594
Hi,

Can you navigate to the actual logs and open them from windows instead of SSMS?

What do you get then?

Regards
  David

PS Logs are in the log folder off the instance directory.
0
 

Accepted Solution

by:
john earned 0 total points
ID: 39967389
all log files are empty, see screen shot earlier.
0
 

Author Closing Comment

by:john
ID: 39997101
No attempt to make viable suggestions from know information and my responses.
Had to take server down and install new OS.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now