How to remove old SQL Server backups – quick tutorial:
Managing storage space occupied by your backups is a task that should not require a DBA’s time. With SQLBackupAndFTP you can easily remove old SQL Server backups, periodically.
In this article, we will show you how to do this, step by step, so you will never have to worry about old backup files filling up your storage space.
Continue reading How to remove old SQL Server backups
Everyone knows that the most important task that any DBA has to be able to do is to take safe and reliable database backups.
Large organizations or companies usually have a team of Database Administrators (DBAs) which execute these tasks and keep their data safe and easily accessible. Continue reading SQLBackupAndFTP: the SQL Backup master
As you might know already if you’re creating backups and also monitoring your server’s resources you have seen that the CPU is used intensively during the compression phase of the backup operation.
Find out in this article how to set 7zip CPU priority to LOW.
Continue reading Set 7zip CPU priority to LOW
Please see the more recent and detailed articles:
Remote SQL Server backups explained or
How to backup remote SQL Server database using SQLBackupAndFTP
Original article:
In this article, we will talk about the remote backups option which is provided as a Beta feature in SQLBackupAndFTP. Continue reading this article to find out more details. Continue reading SQL Server Remote Backup
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
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?