Dave Burke : Freelance .NET Web Developer specializing in Online Communities

CS Nuglet: Stop, drop and take a database snapshot

A question appeared on Community Server Forums that I've seen before asking how to delete temporary users, forums and other CS objects created while testing a new site.  The simple answer is that there is no user or data purge script to remove data created while setting up a new CS site.  User deletion was added in Community Server 2.1.  The user's data is not deleted however, and authorship is transferred to the anonymous user.  Personally I think this is a good policy.

If we wanted to remove a dummy user's forum posts, we could mass copy them to the Deleted Posts forum, then purge from there.  For Files, Photos and Blogs we can simply delete those objects, no one will ever see the data and they will by no means affect system performance.  Or we could run a SQL script, sure.

So I was thinking (NUGLET!), why not take a database snapshot prior to mucking up a pristine Community Server database with a lot of test data, then restoring the database when testing is complete?  Hey, it's an option.

Comments (2) | Post RSS RSS comment feed

Posted on 3/3/2007 8:15:17 PM by Dave Burke
Categories: Community Server
Tags:

Related posts

Comments (2) -

3/10/2007 11:52:38 AM Permalink

Well, since I have developed a conversion tool, form phpBB to CS2.x, I probably have been doing the backup/restore dance counteless of times when debugging.
It is quite quickly performed, thankfully.
One thing worth mention is that the IIs process is rather quick on grabbing a connection to the SQL Server engine, so bringing up the Activity Monitor and kills that process must be done before invoking a DB restore.

www.bassictech.com/content/ForumConverter.aspx

/Magnus

Magnus J |

3/10/2007 12:04:17 PM Permalink

Good point, Magnus.  Thanks!  And I'll definitely be looking into your phpBB to CS 2.x conversion tool.

daveburke |


Powered by BlogEngine.NET 2.0.0.36
Theme by Dave Burke