0
votes
2answers
78 views

Maintaining SQL Log Files

I get an email today stating that we have a log file that's grown to 278GB, and asking if anyone is maintaining it. I already know the answer to that is no because we don't have a dba (other than ...
3
votes
1answer
566 views

Can I safely delete MS SQL Server Error Log?

I have some huge log files, which are taking up all the space on a PC's hard drive. Is ok to simply delete the log file: C:\Program Files\Microsoft SQL ...
0
votes
1answer
415 views

SQL log file growing rapidly

I encountered SQL Database log file growing rapidly and filled up the Hard Disk space, the growth was approximately 190MB per day. there is Sharepoint running in the server, how can I check what ...
0
votes
4answers
373 views

Minimizing SQL transaction log file size on developer box running simple recovery model

We have a lot of SQL servers on development environment where we never take backup of the databases (TFS for code is enough). The (SharePoint) databases are all set to simple recovery model, but the ...
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 ...
0
votes
1answer
111 views

SQL Server 2008 Backup not increasing FreeSpace

OK so I've seen tons of information around about shrinking and free space and similar, but what I've not been able to see is just the basics for SQL Server 2008 on free space in the logfile. I was ...
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
1answer
272 views

SQL Server complete log file view

I made a backup maintenance plan in SQL server 2008. When I run the maintenance plan it fails with an error. When I go to the SQL protocol viewer I can look at the log which has been generated. But ...
3
votes
2answers
1k views

SQL 2008 - Transaction log is full

We have some issues with the transaction log files We have SQL Server 2008 Our situation: Every night, we have many jobs that runs on the server by SQL Agent Some jobs stop because the transaction ...
0
votes
2answers
469 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 ...
0
votes
2answers
1k views

IIS 7.5 log to: sql server vs file

I want to know if get IIS to log directly to the sql server is resource costive, and a better solution maybe generate log files, and each hour import this files to sql server. Does it VERY big cost ...
2
votes
2answers
396 views

Disaster Recovery for SQL 2008 with only the log file

When you read this, you just might cry... We wrote a SharePoint intranet app for the one of our clients that keeps track of files and manages them through various levels of approval. Several files ...
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 ...