In rare cases, some operations in SQLBackupAndFTP don’t fit standard timeouts and fail. For this reason, in version 12.3.3 we added a possibility to define custom timeout values by creating C:\ProgramData\Pranas.NET\SQLBackupAndFTP\Service\Timeouts.xml with the following contents: Continue reading How to increase timeout values
Choosing a database backup strategy is crucial because it determines how data in your SQL Server database is protected. You can read more about database backup strategies, but here we are going to present you some statistics on how SQLBackupAndFTP users backup their databases. The numbers are based on a sample of about a thousand users. Continue reading What are the most common backup strategies?
Making scheduled SQL Server database backups you can receive the following error message:
DETAILED LOG: 10/10/2016 11:32:40 Creating backup of Adventureworks to C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup (full) 10/10/2016 11:32:40 ERROR: A nonrecoverable I/O error occurred on file "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\Adventureworks201610101132.bak:" 112(failed to retrieve text for this error. Reason: 15105). BACKUP DATABASE is terminating abnormally.
Making scheduled SQL Server database backups with the help of SQLBackupAndFTP you can face some issues. Here we are going to discuss one of them. Let’s assume you created a scheduled database backup job and made all necessary settings, even clicked the “Run Now” button to check the backup job and everything works perfectly. But when a time comes to make a backup according to the schedule you receive the following error message: Continue reading Access denied for user “Server\User”
The best way to backup your SQL Server databases is to use SQLBackupAndFTP. But if you still backup your SQL Server database with the help of SQL Server Management Studio you can face the following issue. Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512. Before solving this case let’s recreate the same error message. Continue reading Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512