Monday 27 February 2012

STEPS TO DELETE LOG FILE OF A DATABASE...

LOG FILE OF A DATABASE... 

 

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

0 comments:

Post a Comment