July 15, 2009 at 1:30 am
Hi there
I have a space issue i have to delete the .ldf (told by sys admin to save space) file i have never done this before
can i just do to the folder physically and delete it?
will it affect the database?
let me know the implications as well
pls let me know on how to go about
Cheers
July 15, 2009 at 1:33 am
Do not delete the log file. The transaction log is not an optional piece of the database, it's not an error log. It's critical in ensuring database integrity and there's a chance that if you delete it you will lose the database completely.
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
Can you explain your problem and we'll help you with an appropriate solution to it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2009 at 6:30 am
Are you kidding? somebody will say delete something and as a DBA you will do it? (It's good and save you as you didn't took any action)
Always refer BOL if case of any doubt.
Let me breaf you:
In SQL Server Database is made of Data files and log files; here log files extention is .ldf if you delete it DB will be in suspect mode and to recover it you must have good backup.
Be careful as a DBA!!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 15, 2009 at 7:13 am
You may want to consider hiring a DBA to come in and fix your issues or at least advise you before you do anything. You can study up on SQL Server in the mean time.
That is my advice not a flame.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply