All posts by Mike

How to send SQL Backup confirmations through my GMail, Hotmail or Yahoo account

If you have an active Full-Service subscription, then by default your mail server is set to Automatic (it is actually sent through our servers) and you don’t need to configure anything.  But if you use a free version of SQLBackupAndFTP, or your subscription has expired or you just want to configure your own mail servers – below are the instructions on how to do so. Continue reading How to send SQL Backup confirmations through my GMail, Hotmail or Yahoo account

How to run SQLBackupAndFTP v11 from a command line

SQLBackupAndFTP runs database backups automatically and most of the users schedule it via windows interface/GUI. But you can also start a backup job manually via a command-line interface. One of the examples, when you may need it, is a complex scheduling scenario when the options provided in the program interface are not enough. In this case you may build more complicated schedule with Windows Schedule. Continue reading How to run SQLBackupAndFTP v11 from a command line

SQL Server Express Backup

While it’s easy to create SQL Server Express backup with SQL Server Management Studio it’s quite difficult to run it regularly since SQL Server Express edition lacks handy job scheduler maintenance options in comparison with the full version of SQL Server. Here is where third-party backup utilities like SQLBackupAndFTP enter the stage. Continue reading SQL Server Express Backup

Migration from MS SQL 2008 to 2012

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

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

Why choose Sql Server Express?

Sql Server ExpressWhen you choose Microsoft Sql Server Express, you’re opting for the most practical way to go when it comes to getting database software that is versatile and effective. The best advantage to the Sql Server Express is the fact that it’s free. No matter what web application framework you prefer, this edition gets the job done. You’ll also find that it’s streamlined to function with your top picks in applications as well. This is a database that can grow with you, sufficient to meet all of your needs. You’ll also find that its capacity for expansions is more than you would expect. In a time when you need to be savvy and watch your budget, Sql Server Express Edition is the answer you’ve been looking for all along. Continue reading Why choose Sql Server Express?