[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 793
  • Last Modified:

SQL Server Logs empty/blank

If I go to Enterprise manager, in SQL 2000, expand management and then expand SQL Server Logs, all my logs are empty with 0 bytes.  I lookin the log folder on the storage drive and they are empty as well. How can I fix this?
0
argservices
Asked:
argservices
  • 4
  • 3
  • 2
  • +2
1 Solution
 
DonKronosCommented:
In Enterprise Manager, right-click on each database and select Properties.  On the Options tab change the Recovery Model to Full.  It is probably set to Simple right now.
0
 
luaniCommented:
You don't have any log file or your log files are empty?
if you don't have any log files on the SQL Server Logs right click and select "Configure" see if the is a limit on the number of log files (may be set to 1 or 0)
0
 
luaniCommented:
If the files on the LOG dir has been deleted the log archive on EM also disappears.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
argservicesAuthor Commented:
DonKronos, all the databases are set to full.

Luani, I do have files in the log directory but they have 0 bytes.
0
 
mastooCommented:
Are the dates and times in EM for the logs looking right?
You might check your startup parameters on Sql Server to see if you have a "-e" parameter specified, and if you do make sure it points to a directory that exists and has room.  Startup parameters are on properties of the server, general tab, button near the bottom.
0
 
argservicesAuthor Commented:
mastoo, all dates and times are correct. A new log file is generated every time I restart the server as well.  I took out the parameter and added it back just to make sure last night but still no luck.  
0
 
argservicesAuthor Commented:
Any other suggestions?
0
 
Kevin3NFCommented:
try the "type' command in DOS

c:\>type c:\errorlog

0
 
mastooCommented:
Hmmmm.  Maybe try changing the location to something like C:\ just to see if they show up.  Is Sql sticking things in the event log?  If so, is it saying anything interesting?  Is it running under the local system account?
0
 
Kevin3NFCommented:
or:

exec master..xp_readerrorlog
0
 
luaniCommented:
Check your event viewer  for any notifications regarding SQL Server.
0
 
argservicesAuthor Commented:
Mastoo, that was it. I changed the location and the logs started to work thanks.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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