Due to security reasons, most admins will prefer to create accounts for any system with minimum privileges.
So now you might wonder how to create a user for Amazon S3 service that has minimum permissions in order to backup databases with SQLBackupAndFTP in a certain bucket and folder? It’s quite easy…
Continue reading Set Amazon S3 access policy to minimum permission
Let’s assume you have a large database and SQLBackupAndFTP is using 7-zip to compress your database’s backups. You might notice that during the compression phase of the backup operation, the CPU utilization of your server is about 100% and in order to reduce this, you will just have to …
Continue reading How to lower the priority of 7-zip process
What is WARNING: Database <db-name> is SUSPECT?
You have probably seen databases marked as SUSPECT in SSMS and you don’t know what it represents.
Read the below article to find out more details about this!
Continue reading What is WARNING: Database db-name is SUSPECT?
When using SQLBackupAndFTP with Google Drive as your cloud storage for your backup files, you might encounter an error that reports “Invalid credentials”.
Read the below article in order to find out what to do in order to quickly solve this. Continue reading Set TraceLog attribute of Google Drive destination to TRUE value
Does uploading your backup to Amazon S3 with SQLBackupAndFTP take a long time?
This article will show you what to do to drastically reduce the time it takes.
Continue reading Amazon S3 destination chunk size configuration
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:
If you have been using SQLBackupAndFTP with the advanced options to schedule the automatic creation of your backups, there is a possibility that during the backup operation, someone manually stops the process.
In the event that such a thing happens, there is a chance that trying to re-run the operation through a schedule you are going to encounter a problem with the schedule not being initiated.
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
When 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?