3 Kicks

How to Attach a database without a transaction log file (.ldf)(sqlprof.com)

submitted by ericvaillancourtericvaillancourt(90) 4 years, 1 month ago

If you ever lose the drive that contains your log file, your database will become suspect and will stop working. You do not need to restore the backup in such a crash. If you do, you will lose everything since your last BACKUP. All you have to do is to detach the database and reattach it without the log. SQL Server 2005 does allow you to do this. You can reattach the database by following these simple steps...

add a comment |category: |Views: 11

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
mdoppmdopp(856) - locrainlocrain(400) - ericvaillancourtericvaillancourt(90)
Comments:

No comments so far

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?