Decrease size of the .ldf in C#

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008

Dear all,

How to decrease size of the .ldf file (ldf log in sql 2008) in c#. No script, how to make to code in c#.

Thanks for all

Posted 13-Feb-14 12:22pm

Member 10145136

Add a Solution

Comments

ZurdoDev 13-Feb-14 21:13pm

Your code will have to execute script.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Joshi, Rushikesh · Answer 1 · 2014-02-13T16:56:00

If I understand your question then decreasing size of LDF file through C# code is not doable.

Reason: LDF file is getting generated by database instance. This transaction logs file's format is getting maintain by SQL server instance. This is like, can you reduce size of PDF file, Doc file through just C# code without any vendor component.

Yes for sure you can write a program which connects to database instance and can perform below actions.

C#

SQLDatabase.TransactionLog.Truncate();
SQLDatabase.Shrink(5, SQLDMO.SQLDMO_SHRINK_TYPE.SQLDMOShrink_NoTruncate);
SQLDatabase.TransactionLog.Truncate();
SQLDatabase.Shrink(5, SQLDMO.SQLDMO_SHRINK_TYPE.SQLDMOShrink_Default);

If you are decreasing file size to archiving it then simply write a program to Zip (Compress) it, it will work and will be easy also.

-- Thanks Rushi

Member 10145136 · Answer 2 · 2014-02-17T11:59:00

Solution 2

Hi Rushi and thanks for your solution, but when put this code, make the error:
{"This method or property is only accessible to work with an earlier version a SQL Server 2008."} System.Exception {Microsoft.SqlServer.Management.Smo.UnsupportedVersionException}

Posted 17-Feb-14 11:59am