Category Archives: maintenance

maintenance

How to automate maintenance of your databases

database, Knowledge Base, maintenance

Maintenance of your databases is as important as regular backups. Once scheduled backups are set, the thought may appear that your data is safe and sound and it is, until a problem appears.

As a rule, databases don’t crash completely, but there may be a sharp decrease in performance because of server laсk of disk space or any other issues that can corrupt databases. That’s why it’s highly recommended not only to perform regular backups of your databases but also maintain them. Continue reading How to automate maintenance of your databases →

How to perform SQL Server maintenance

maintenance, SQL Server, sqlbackupandftp, , , ,

sbf maintenance

SQL Server maintenance is just as important as creating backups of your databases. 
Without a doubt, there are a lot of organizations that install a SQL Server database or more without setting their maintenance plans up first 
Things generally go smoothly and at the beginning, there is no problem, that is, until a problem appears.
Continue reading How to perform SQL Server maintenance →

Migration from MS SQL 2008 to 2012

maintenance, SQL Server, sqlbackupandftp

Are you interested in learning how to migrate your database from MS SQL 2008 to 2012? If your current Cloud site is running the older version of MS SQL and you would like to update it to the newest 2012 feature-rich version, you have come to the right place. Here is a step-by-step process detailing how you can migrate your database from MS SQL 2008 to 2012:

Tasks to Complete Prior to Migration

Continue reading Migration from MS SQL 2008 to 2012 →

MS SQL Recovery Models

maintenance, recovery, SQL Server, ,

Recovery models serve very important roles when it comes to MS SQL Server backup. The purpose of an MS SQL Recovery Model is to control how transactions are logged, whether it allows and requires backing up and the types of restore operations that are available. By controlling transaction log maintenance, databases are able to be converted from one recovery model to another at any time. The three types of recovery models are simple, full, and bulk-logged, with most databases using either the simple recovery model or full recovery model. Whichever model is used, there are differences between the three. Continue reading MS SQL Recovery Models →