Knowledgebase Home | Glossary | Favorites | Contact | Login Knowledgebase Home | Glossary | Favorites | Contact | Login
Search the Knowledgebase Browse by Category

[Advanced Search]
Create a new log file from a command line
Article Details

Last Updated
11th of June, 2010
Would you like to...
Print this page Print this page
Email this page Email this page
Post a comment Post a comment
Subscribe me
Add to favorites Add to favorites
Remove Highlighting Remove Highlighting
Edit this Article Edit this Article
Edit this Article Quick Edit
Export to PDF
User Opinions (4 votes)
100% thumbs up 0% thumbs down
How would you rate this answer?
Helpful
Not helpful
If the log file is too large and you want to create a new log.  Detach the database.  Then from Management Studio, open a new query and enter the command:

create database [jpegger] on (FILENAME = 'C:\jpegger.mdf') for attach_rebuild_log

where jpegger is the name of the database and 'C:\jpegger.mdf is the path for the mdf file.
Visitor Comments
  1. Comment #1 (Posted by )
    Great article.
Post Comment for "Create a new log file from a command line"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.
   Your Name:
   Email Address:
* Your Comment:
* Enter the code below:
 
Related Articles
No related articles were found.
Attachments
No attachments were found.

Continue

Knowledge Management Software by Interspire

Untitled Document