1
vote
1answer
954 views

security_error_ring_buffer_recorded in system health log - what does it mean?

Our company is running a few servers for a couple of websites. The server are running Windows Server 2012 and for databases we have MS SQL Server 2012. Today I was checking the log files located in: ...
1
vote
4answers
13k views

55GB LDF file in C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data? How can I clear it?

It seems I had someone trying to perform brute-force login attempts on my SQL 2005 server. As a result, the log file has grown to about 55 gigs and sits in ...
1
vote
3answers
131 views

Is having a 92MB .mdf with a 58MB .ldf okay? How do I manage the log to keep things running well?

I have jobs in place to trim tables used for history and logging to keep them trim. I want to make sure I don't neglect the log file. How and what can I or should I do to keep the log file in ...
2
votes
2answers
281 views

Just discovered a log file occupying over 12Gb, what do I do?

trying to figure out how come my disk space was so low I discovered a log file occupying over 12Gb... is this normal? how do I prevent this from happening again if not? do I just delete it? Any ...
1
vote
4answers
324 views

Managing Log File in SQL Server 2008

These are my current settings: Recovery mode: Simple Logfile initial size: 10 mb Logfile autogrowth: None Database auto shrink: Off The logfile autogrowth is set to None because I don't want the ...
1
vote
4answers
608 views

SQL Database Log file just keeps on growing

Problem Solved (Kind of...) I am slightly embarrassed to admit that this behaviour was caused by a stored procedure called as part of an inhouse app. However, even having fixed the bug I still don't ...
1
vote
3answers
1k views

does SQL server have the equivalent of MySQL query logs

I have used MySQL for a long time and have found the general query log and slow query log to be very useful in finding out what is happening on the server, and in identifying bottlenecks. Now I need ...
1
vote
2answers
215 views

How to truncate SQL Server log file

I tried to shink database log file but it is still huge. My database is 200mb and log is 30Gb USE [databasename]; BACKUP LOG [databasename] WITH TRUNCATE_ONLY; DBCC SHRINKFILE ('databasename_log', 1, ...
0
votes
2answers
495 views

how to consolidate multiple log files into one ldf file in sql2000

I'm in the process of copying databases from SQL 2000 to a 2008 instance on another server using DETACH, copy windows file to 2008 server, then finally ATTACH. I've come to a database where the LOG ...
3
votes
3answers
395 views

SQL Server Log File Size Management

I have all my databases in full recovery and have the log backups happening every 15 minutes so my log files are usually pretty small. question is if there is a nightly operation that causes lots of ...
10
votes
3answers
4k views

How do I shrink the size of a SQL Server log file

I can't figure out how to shrink the size of the databases ldf file. The DBA says I should use backup log dbname with truncate_only And while that looks like it executed correctly in SQL Query ...
2
votes
2answers
627 views

Do we have a ratio between DB data and log file?

OK we all know that a big log file crumbles DB performance. Today we were analyzing a client's server and saw some log files about 3900% bigger than the data file. And that made me curious if is ...
1
vote
3answers
2k views

SQL Server 2008 log file grow ultra huge even in simple recovery

We have a database in SQL Server 2008 for which the Recovery model is set to Simple. Periodically, we run a big update on a big table (15 million rows to update). To accomplish this, we run a Stored ...
1
vote
1answer
515 views

Viewing previous query results from SQL Server Management Studio

I left my computer last night running a batch delete in the Query Editor of Sql Server Management Studio. I was running this to test the speed of the delete on a large database before we used the ...
2
votes
2answers
1k views

Re-assigning / changing the Primary Log File - SQL 2000

I've got a large db (called Navision4) which currently has 2 log files: Navision4_Log Navision4_Log3 There was a log called Navision4_Log2, but i managed to remove this. Navision4_Log is located on ...
0
votes
1answer
686 views

Moving / Consolidating SQL Log (ldf) and Data (mdf) files

Currently, our SQL install has many files listed in the database properties - files section. Here is a screenshot: http://twitpic.com/q8ktj/full Is there any way i can consolidate these files into a ...
0
votes
4answers
834 views

How to find out where or if MYSQL5 logs are stored on a machine WHM/Cpanel

I have a WHM/Cpanel re-seller hosting account on a virtual private server (Linux). I have root access to the machine via SSH I am trying to locate a file that contains information that will help ...
1
vote
1answer
41 views

How fine grained of an association can I make between SQL Server log files and CPU?

On a multi cpu, multi disk, server, I am looking to associate CPUs with particular log files. I am wondering if is possible, and how, to dedicate CPU power to specific log file work, in SQL Server ...
0
votes
1answer
2k views

How do you switch an active SQL Server database into Simple Recovery Mode

I've had some logging problems and based on the way the application works we don't need full recovery mode, which will help us with our logging. How do I switch the database into simple recovery ...
3
votes
5answers
5k views

Is there a risk to running a DBCC SHRINKFILE command against a log while db is being used

We can handle a performance hit. This is also a one off as there was a new index created which caused a massive log file to be created. I need to shrink this file back down. I just wanted to know ...
0
votes
2answers
251 views

If my transaction log backup fails will it still clear my log file?

One of the databases that I've taken over monitoring is set to full recovery mode but there is no plan to have the transaction log backed up. Naturally this has caused the log file to grow to a fairly ...