• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

ms SQL server 2005 not saving logs

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
john
Asked:
john
  • 3
  • 2
1 Solution
 
David ToddSenior DBACommented:
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
 
Anthony PerkinsCommented:
Are you referring to the SQL Server Error Logs?
0
 
johnAuthor Commented:
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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
David ToddSenior DBACommented:
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
 
johnAuthor Commented:
all log files are empty, see screen shot earlier.
0
 
johnAuthor Commented:
No attempt to make viable suggestions from know information and my responses.
Had to take server down and install new OS.
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now