When you delete, update or insert the data, the SQL Server Database Engine updates the indexes automatically. Over time such changes lead to the data in the index being scattered all over the database, in other words – fragmented.
How to Manage Backups with Your Team
Now with the help of SqlBak, you can manage backup jobs and maintenance jobs with your team members separately or even with an entire team. That has become possible due to a brand new “Users” feature available on the “My Account” page. This option can be useful when you need to add one or more users with Read-Only or Manager privileges to your account.
How to run “DBCC SHRINKDATABASE”
The DBCC SHRINKDATABASE is used when it is necessary to shrink the size of the log and data files in a particular database.
How to Run SQL Server Maintenance Jobs
Now you can run regular SQL Server maintenance jobs with the help of SqlBak. This feature can be useful if you regularly need to make some changes to your database. All these changes can be made by adding any SQL Server command (using T-SQL) or adding Windows batch (*.cmd, *.bat).
How to manage multiple SQL backups in one place
Let’s assume that you have to administer over 100 databases that are stored on multiple servers. How can you make sure that every backup job is done as scheduled?
How often should I backup my database?
For almost any DBA, the question “How often should I backup my database?” is undoubtedly one of the most important to ask and answer. The answer, as with so many other questions in life, is “It depends”. Depends on what? Let’s discuss this.
Your data is secure with SqlBak
The safety of our customers’ data is always our priority above any of the features we have. We are constantly working on security improvements here at SqlBak. And the only data that is ultimately secure is the data that you never had in the first place. That is why we do not send, nor store your DBMS credentials on sqlbak.com at all. This means that your server login and password will never leave your server. This change will be especially welcomed by organizations whose privacy policy does not allow passing DBMS login and passwords to any third-party websites.
How to Backup SQL Server Database to Amazon Glacier
Amazon Web Services (AWS) offers a large, sometimes bewildering array of server, storage, networking, and analytics cloud offerings, as seen here. One of their storage products is Amazon Glacier, in addition to the older storage solutions – S3 and Elastic Block Store (EBS). Glacier is a very affordable solution intended as a write-once, retrieve-seldom storage medium for long-term storage. Think of it as a storage locker that’s far away from your home, as opposed to your at-home garage or cabinet locker. It is also a good choice for your SQL Server backups …
Why Transaction Log backups are important
When backing up your SQL Server database, you have the option of taking transaction log backups. These are quick, small backups containing a sequence of all your database’s changes. Transaction log backups are mightily useful for point-in-time recovery.