STEPS TO DELETE LOG FILE OF A DATABASE..

Sunday, 26 February 20120 comments

1.Backup the database
2.Detach the database, either by using Enterprise Manager or by executing : *Sp_DetachDB [DBName]*
3.Delete the transaction log file. (or rename the file, just in case)
4.Re-attach the database again using: *Sp_AttachDB [DBName]*
5.When the database is attached, a new transaction log file is created.

SOURCE: SADOP

Share this article :

DISCLAIMER

All the information published in this webpage is submitted by users or free to download on the internet. I make no representations as to accuracy, completeness, currentness, suitability, or validity of any information on this page and will not be liable for any errors, omissions, or delays in this information or any losses, injuries, or damages arising from its display or use. All information is provided on an as-is basis. All the other pages you visit through the hyper links may have different privacy policies. If anybody feels that his/her data has been illegally put in this webpage, or if you are the rightful owner of any material and want it removed please email me at"naushadhardoi@gmail.com" and I will remove it immediately on demand. All the other standard disclaimers also apply.