Linked Questions

18
votes
5answers
80k views

SQL Server Database Not Shrinking [duplicate]

I have an SQL Database with a lot of unused space. However when I run Tasks | Shrink | Database And Tasks | Shrink | Files from Management studio it isn't freeing up any space. Unfortunately the ...
7
votes
6answers
49k views

SQL Server log shrinking Issue [duplicate]

Possible Duplicate: Why Does the Transaction Log Keep Growing or Run Out of Space? I have a 300 GB database log in our SQL Server. I want to shrink all the logs but it is not allowing me to do so....
5
votes
2answers
6k views

Transaction Log Files Larger Than Data Files [duplicate]

I'm an accidental DBA and need help determining a course of action regarding transaction log files on several databases. I ran Brent Ozar's sp_blitz to see what areas of concern there might be on an ...
5
votes
2answers
35k views

How to disable ldf file or limit its size [duplicate]

Possible Duplicate: Why Does the Transaction Log Keep Growing or Run Out of Space? My .ldf file size keeps increasing. I already tried to shrink it but after that it just grows again. How can I ...
6
votes
4answers
12k views

Why Can't I shrink log file in full recovery mode [duplicate]

I have a log file that is 302MB. I have done a log backup which has left the log file mostly free (I can see this through the Disk Usage standard report) If i try to run DBCC SHRINKFILE (N'...
7
votes
5answers
6k views

Managing Transaction Log Size using a Maintenance Plan [duplicate]

Are there any best practices for configuring a Maintenance Plan in SQL Server 2008? Currently, I'm removing database backups and transaction logs greater than 40 hours old, then backing them up. ...
-1
votes
1answer
14k views

How can I change the Initial Size of my sql log LDF file? [duplicate]

Somehow it's been created with a minimum size of 32gb. The actual database is ~2gb in size. The database is wiped and recreated every day from an external datasource, and thus doesn't need any logs ...
1
vote
1answer
16k views

How to reduce the size of ldf file? [duplicate]

We take full backups of the DB every day (in full recovery mode) and keep them for 10 days. Because of our requirements, we don't want to take incremental or differential backups of the DBs. Now we ...
3
votes
2answers
10k views

Transaction log exploding during index reorganization [duplicate]

Possible Duplicate: Why Does the Transaction Log Keep Growing or Run Out of Space? My client is running SQL Server 2005 x64 Standard on a beefy server with 16 GB of RAM, and separate drives for ...
3
votes
2answers
10k views

Does a database backup reduce size/increase free space of the log file? [duplicate]

I have a SQL Server database where the log file is massive and keeps growing every day. I've archived data from the database and then done a full backup. I was expecting the log to then be basically ...
2
votes
2answers
3k views

how to reduce transaction log size automatically? [duplicate]

Possible Duplicate: Why Does the SQL Server Transaction Log Keep Growing or Run Out of Space? how can i reduce the size of Transaction log programatically and automatically, because no one knows ...
0
votes
3answers
3k views

Whether Logfile Shrinking is good or bad one for Performance in SQL? [duplicate]

I am using SQL Server 2008 R2 database and on our SQL Server instance we have more than 70 databases. In a few databases I can see that the transaction log file size is more than 10 GB. I am shrinking ...
0
votes
2answers
5k views

SQL Server log file is too big [duplicate]

We are using SQL Server 2008 with full recovery model, the database size is 10 GB and the log file is 172 GB, we want to clear up the space of the log file internally ,we did transaction log file ...
3
votes
2answers
981 views

Transaction Log 16GB on 2MB database [duplicate]

Possible Duplicate: Why is My SQL Server Transaction Log Growing or Running out of Space? The transaction log in one of my client's databases is 16GB, when the database itself is only 2MB. I have ...
1
vote
1answer
2k views

Cannot shrink transaction log [duplicate]

Bit of a headscratcher here. I have a db that has less than 1GB of data, but a 40GB log file. Transaction logs are backed up daily, and there is not a lot of activity on this database; approximately ...

15 30 50 per page