Here we are going to discuss how to solve the error message “Failed to update database because the database is read-only” that you can face with working with SQL Server. Below the complete text of this error:
Msg 3906, Level 16, State 1, Line 10
Failed to update database "MyData" because the database is read-only.
Of course, experience DBA can say that your database is read-only and you don’t have any way to write into it. All you need is simply mark the database as read-write. That’s it. But still, we are going to show you, how you can solve this issue using simple T-SQL Commands or SQL Server Management Studio . Continue reading Failed to update database because the database is read-only
In this blog post, we are going to discuss how to solve the following error “Cannot bulk load because the file could not be opened. Operating system error code 5 (Access is denied.)”. Below you will find the reason why this error happened and the way to solve it. Continue reading Cannot bulk load because the file could not be opened. Operating system error code 5 (Access is denied.)
Let’s imagine the following situation. You have SQL Server database and you perform backups from time to time. Something went wrong and now you need to restore your SQL Server database. You start to do it with the help of SSMS (SQL Server Management Studio) but face with the following error message: “No Backupset Selected to be Restored“. Continue reading No Backupset Selected to be Restored
After you have passed registration process it’s time to connect your computer to SqlBak. This is done in three simple steps. Continue reading How to Connect Computer to SqlBak
After you have passed registration process and connected SqlBak to your Server go to your Dashboard page and create your first backup job. Continue reading How to create SqlBak backup job in 2 minutes
Since we have launched a new feature called Automatic Health Check from SqlBak, users might be curious what data do we collect during this process? Continue reading What Data Do We Collect During the Automatic Health Check
As you probably know, SqlBak recently announced an Automatic SQL Server Health Check feature that adds significant value to SqlBak as a database backup service allowing it to monitor such vital parameters of your server as database size, transaction log size, file stream, free disk space and folder size. Continue reading How the Automatic SQL Server Health Check affects Server Performance?
Today there are several methods of how to backup SQL Server 2016 database. In this article we will review how to backup SQL Server 2016 and what features have been added. Continue reading How to backup SQL Server 2016
One of the most popular ways how to create SQL Server database backup is to use SSMS or T-SQL Commands. But what if your backup plan is full backups twice a day, differential backups every 4 hours and transaction log backups every 30 minutes and you prefer to store all SQL Server database backup on FTP Server. How much time will you spend each day to complete such scenarios? You can simple tune SqlBak backup job just in few minutes, which will make SQL Server database backups according to your schedule and send them to FTP Server. Continue reading How to Backup SQL Server to FTP Server
Do you make your SQL Server database backups with the help of SSMS or by using T-SQL Commands, or in any other way? How much time do you usually spend every day to make backups and store them to Local or Network Folder? With the help of SqlBak, you can create a backup job which will make SQL Server backup on a regular basis and store them to your local or network folder. Continue reading How to Backup SQL Server to Local or Network Folder