How to reclaim the diskspace from SQL log file (.LDF)?
To reclaim disk space from SQL log file
- Detach the database using Enterprise manager or Stored procedure. - Delete the log file physically - Attach the database using Enterprise Manager which will create a new log file for the database
3 comments:
Anonymous
said...
Isn't deleting the ldf file makes the database inconsistent?
Hello !. You re, I guess , perhaps curious to know how one can reach 2000 per day of income . There is no need to invest much at first. You may commense to receive yields with as small sum of money as 20-100 dollars.
AimTrust is what you thought of all the time The firm incorporates an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.
It is based in Panama with structures everywhere: In USA, Canada, Cyprus. Do you want to become a happy investor? That`s your chance That`s what you really need!
I`m happy and lucky, I started to get real money with the help of this company, and I invite you to do the same. If it gets down to choose a correct partner utilizes your funds in a right way - that`s the AimTrust!. I make 2G daily, and what I started with was a funny sum of 500 bucks! It`s easy to get involved , just click this link http://axomomew.bigheadhosting.net/ibevyr.html and lucky you`re! Let`s take our chance together to become rich
3 comments:
Isn't deleting the ldf file makes the database inconsistent?
No when you attach the DB again the a new log file is created automatically.
Hello !.
You re, I guess , perhaps curious to know how one can reach 2000 per day of income .
There is no need to invest much at first. You may commense to receive yields with as small sum of money as 20-100 dollars.
AimTrust is what you thought of all the time
The firm incorporates an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.
It is based in Panama with structures everywhere: In USA, Canada, Cyprus.
Do you want to become a happy investor?
That`s your chance That`s what you really need!
I`m happy and lucky, I started to get real money with the help of this company,
and I invite you to do the same. If it gets down to choose a correct partner utilizes your funds in a right way - that`s the AimTrust!.
I make 2G daily, and what I started with was a funny sum of 500 bucks!
It`s easy to get involved , just click this link http://axomomew.bigheadhosting.net/ibevyr.html
and lucky you`re! Let`s take our chance together to become rich
Post a Comment