Linked Questions

21 votes
5 answers
116k 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 ...
DermFrench's user avatar
11 votes
6 answers
59k 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....
kuldeep verma's user avatar
8 votes
4 answers
31k 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'...
SE1986's user avatar
  • 1,970
7 votes
2 answers
9k 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 ...
JeffRob's user avatar
  • 71
7 votes
2 answers
40k 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 ...
Adam's user avatar
  • 245
7 votes
5 answers
7k 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. ...
Neil Knight's user avatar
2 votes
2 answers
16k views

How can I reduce the size of a huge LDF file? [duplicate]

We are a small trading company. We use a software for invoicing and stock keeping which uses SQL Server as a database. Our SQL Server database is 3.3 gb in size. However our LDF file is 173 gb. Both ...
Subliminal Hash's user avatar
-1 votes
1 answer
15k 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 ...
NibblyPig's user avatar
  • 661
4 votes
2 answers
12k 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 ...
BlueChippy's user avatar
1 vote
1 answer
19k 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 ...
Anni's user avatar
  • 21
1 vote
4 answers
4k views

How to shrink large LDF [duplicate]

I have a client with a SQL2016 DB with a 100Gb MDF and a 4Gb LDF. The DB is set to Simple. I can't get it done to shrink the LDF to a minimum. How can I shrink the LDF to a normal level? Does this ...
Florian's user avatar
  • 31
3 votes
2 answers
12k 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 ...
rjean99's user avatar
  • 31
2 votes
2 answers
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 ...
user avatar
0 votes
3 answers
4k 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 ...
RickyRam's user avatar
0 votes
2 answers
7k 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 ...
mimiKh's user avatar
  • 9

15 30 50 per page
1
2 3 4 5
14