Scrubbing a DotNetNuke Database for user info and passwords

By
Scrubbing a DotNetNuke Database for user info and passwords

If you’ve ever needed to send a backup of your DotNetNuke database to a developer for testing, you likely trust the developer enough to do so without scrubbing your data, but just to be safe it is probably best that you do take the time to scrub.

Before you do anything with the SQL below, make sure you have a backup of your website! I would recommend you do the following.

  1. Backup your existing production database
  2. Restore a backup of your production database as a NEW database
  3. Run the scripts below on the NEW database
  4. Shrink the NEW database
  5. Backup the NEW database
Tags: DotNetNuke;Database;Administration;Admin;SQL;DB;Shrink;Backup
Category: Reference
Category: User Experience
Category: Development
Category: Security

Recent Comments

There are currently no comments. Be the first to make a comment.

Add Comment

Please add your comment by filling out the field(s) below. Your comment may need to be approved before it becomes visible.
Enter your first name for display with the comment
Enter your last name for display with the comment.
Enter your comment here.
If you can't type DNNRocks in, you can't post, plain and simple.
Submit Comment Cancel

Chris Hammond

Chris Hammond is a father, husband, leader, software developer, photographer and car guy. Chris focuses on the latest in technology including artificial intelligence (AI) and has spent decades becoming an expert in ASP.NET and DotNetNuke (DNN) development. You will find a variety of posts relating to those topics here on the website. For more information check out the about Chris Hammond page.

Find me on Twitter, GitHub and LinkedIn.