Solved

ms SQL server 2005 not saving logs

Posted on 2014-02-19
6
217 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server 2005 running VERY slow on Virtual Machine 18 62
T-SQL: Wrong Result 7 34
Search Text in Views 2 24
SQL - Subquery in WHERE section 4 27
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

738 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