How to specify backup’s lifetime
When you are going to save backups on any storage destination (on local storage or on a cloud service), the first questions most likely are “How long should I keep backups here and how can I specify backup’s lifetime in SQLBackupAndFTP?” Continue reading How to specify backup’s lifetime
Set 7zip CPU priority to LOW
Sql Server Remote Backup
Please see the more recent and detailed article:
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
Cannot perform the requested operation on an item that does not exist. Type: Xceed.FileSystem.DiskFile
If you run a backup job manually, it successfully works, however, when it runs as a scheduled job it fails with the error message: “Cannot perform the requested operation on an item that does not exist. Type: Xceed.FileSystem.DiskFile”, you can around this issue with one of the below solutions. Continue reading Cannot perform the requested operation on an item that does not exist. Type: Xceed.FileSystem.DiskFile
[DBMS-MSSQL:11006#916] The server principal “NT AUTHORITY\SYSTEM” is not able to access the database under the current security context
If you encounter the error message:
[DBMS-MSSQL:11006#916] The server principal "NT AUTHORITY\SYSTEM" is not able to access the database <database-name> under the current security context
you will find the solution below:
Go to the “SQL Server” sections and click on the gear button. At the opened “Connect to Server” window you need to select “Microsoft SQ: Server (local) as your Server type, choose “Windows Authentication” and enter User Name and Password. Press “Test Connection” to make sure that you have specified the correct data and then click on “Save & Close” to save and apply new settings. Continue reading [DBMS-MSSQL:11006#916] The server principal “NT AUTHORITY\SYSTEM” is not able to access the database
Configure SQLBackupAndFTP NLog
Set Amazon S3 access policy to minimum permission
Continue reading Set Amazon S3 access policy to minimum permission
How to lower the priority of 7-zip process
What is WARNING: Database db-name is SUSPECT?
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?