4
votes
6answers
17k 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 ...
7
votes
5answers
22k 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 ...
4
votes
2answers
21k 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 ...
5
votes
5answers
4k 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. ...
-2
votes
1answer
9k 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 ...
2
votes
2answers
6k 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 ...
2
votes
2answers
2k 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 ...
5
votes
1answer
270 views

My log file is large, what should I do? [duplicate]

My transaction log is larger than I'd like it to be, and I want to know how I can fix that.
1
vote
2answers
3k views

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

Novice question, sorry! Got a SQL Server database and 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 ...
2
votes
2answers
2k views

SQL Server 2008 - Log file out of control & cant shrink it [duplicate]

Possible Duplicate: Why Does the Transaction Log Keep Growing or Run Out of Space? I am having trouble with my database, the log files is currently 250GB in size, I need to shrink this down ...
3
votes
2answers
694 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. ...
0
votes
3answers
615 views

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

I am using SQL Server 2008 R2 database and in that we have more than 70 databases. In a few databases I can see the log file size is more than 10GB. I am shrinking the log file size on a daily basis ...
2
votes
1answer
711 views

Size of the ldf file increasing [duplicate]

Possible Duplicate: Why Does the Transaction Log Keep Growing or Run Out of Space? I have some sql server database for which recovery model is set to full.Now for some databases the ldf ...
1
vote
1answer
693 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 ...
5
votes
2answers
903 views

SQL Server 2008 transaction log full [duplicate]

We have a large database, with a size of approx 400GB. We are using bulk insert (from upstream system) with the following parameters: `Driver=/IIS/Appl/Server/branded_odbc/lib/VMsqls24.so` ...

15 30 50 per page