How to Backup All MSSQL Databases on a VPS at Once

Last Updated on Wednesday, 27 February 2013 08:51 Written by Khaleel Demeri Friday, 1 March 2013 12:00

Have you ever wondered if you can back up all your databases at once? In this post I will discuss how to do this with one script. A separate file will be created for each database.

Let’s start!

1) Please make a directory where you want the backup files to be created. I will use C:\DB_Backup\ as my directory in this post.

Note: Step one is an important thing to do. We will use the path of that directory later in our script.

Checking Collation of Your MojoPortal Databases

Last Updated on Thursday, 30 June 2011 01:18 Written by Ian McIntosh Thursday, 30 June 2011 12:00

This article builds on the previous post in the series about how to setup local and remote working environments for MojoPortal.

Background

Collation settings in SQL Server affects character set, sort order and case sensitivity.

How to Reduce the Amount of System Logs Stored in the Elgg Database

Last Updated on Friday, 8 July 2011 11:22 Written by Rodolfo Hernandez Thursday, 28 April 2011 08:55

Elgg by default keeps a system log. This can be useful when it comes to know what changes has been done to elgg. However, if you don’t control this, the loading speed of your elgg site could be affected because such logs are stored in the database.

How to Clean Up Your Elgg Database with Garbage Collector

Last Updated on Friday, 8 July 2011 10:53 Written by Rodolfo Hernandez Friday, 15 April 2011 10:20

In this article I am going to show how to clean your elgg database with nice tool that comes by default in elgg called Garbage Collector.

How to Setup Secure Folders in WebsitePanel

Last Updated on Sunday, 8 May 2011 12:53 Written by Arian Jahansouz Thursday, 20 January 2011 11:00

This article will give you a step by step guide on how to setup secure folders from your WebsitePanel. Sign into your WebsitePanel and follow these steps:

1) Go to Web and click Web Sites