Welcome Guest, you are in: Login

Search:
There is not much you have to do once your wiki is up and running.

We suggest you to perform the following tasks:
  • Make sure you have configured email error notifications (more...)
  • Periodically check that the search index is not corrupted (more...)
  • Keep your wiki application and providers up-to-date (see Admin Home)
  • Regularly backup your data (see section below)

Data Backup

We suggest you to regularly backup your data, for example each night or evening. This task is very easy yet extremely important.

File-System Data Storage

A backup simply consists of a xcopy of the entire web application folder.

SQL Server Data Storage

A backup consists in a xcopy of the entire web application folder plus a backup of your database.

Misc

Some random help tips and tricks.

Changing Database Collation in SQL Server

ScrewTurn Wiki requires the database to be set with a case-insensitive collation. You can use the following script to change it.

alter database [ScrewTurnWiki] set single_user with rollback immediate
alter database [ScrewTurnWiki] collate <your collation>
alter database [ScrewTurnWiki] set multi_user

Replace with a case-insensitive collation, for example Latin1_General_CI_AS.

Defragmenting Indexes in SQL Server

The indexes of a high-write-traffic database can become fragmented, affecting performance. Run this script to defragment indexes in SQL Server 2005/2008.

/* BACKUP YOUR DATABASE BEFORE EXECUTING THIS SCRIPT */
/* If you run Enterprise Edition, you can rebuild the index with 'online = on' option */
/* In all other versions, this script locks tables being processed, so execute it when the system is not in use */

/* Pages */
alter index all on [ScrewTurnWiki].[dbo].[Namespace] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[Category] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[Page] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[CategoryBinding] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[PageContent] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[PageKeyword] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[Message] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[NavigationPath] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[Snippet] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[ContentTemplate] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[IndexDocument] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[IndexWord] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[IndexWordMapping] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);

/* Users */
alter index all on [ScrewTurnWiki].[dbo].[User] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[UserGroup] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[UserGroupMembership] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[UserData] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);

/* Files */
alter index all on [ScrewTurnWiki].[dbo].[Directory] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[File] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[Attachment] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);

/* Settings */
alter index all on [ScrewTurnWiki].[dbo].[Setting] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[Log] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[MetaDataItem] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[RecentChange] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[PluginAssembly] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[PluginStatus] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[OutgoingLink] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);
alter index all on [ScrewTurnWiki].[dbo].[AclEntry] rebuild with (sort_in_tempdb = on, statistics_norecompute = on);

Side Projects

  • RESX Synchronizer allows to synchronize multi-language .resx files (used for the development of ScrewTurn Wiki).
  • Pixel Picker enables to pick the color of pixels on your screen — very handy for day-to-day graphics-related activities.

About