Tag Archives: sqlbackupandftp

How to backup a SQL Server database to NAS drive

backup a sql server database to nas
 Backing up your database is one of the most important tasks a DBA should have set. There are multiple options in terms of backing up a database, for instance you could backup a SQL Server database to NAS drives.
If you prefer this option or if your organization requires you that you backup your databases on your local network then you can count on SQLBackupAndFTP to assist you with this and make the job much easier!
Continue reading How to backup a SQL Server database to NAS drive

SQLBackupAndFTP: the SQL Backup master

SQLBackupAndFTPEveryone 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

Configure SQLBackupAndFTP NLog

Configure SQLBackupAndFTP NLog
If you encounter a situation in which you run a job to backup your database to Dropbox for example or to another storage service you get an error saying: SBFDS5006″: Dropbox exception > Failed to upload file”; “Status: 0. Description: The operation was cancelled
Although the application might try multiple times to run this job, but without success.

Continue reading Configure SQLBackupAndFTP NLog

Client with IP not allowed access-Azure SQL error

Connect to Azure SQL error-Client with IP not allowed access

Client with IP not allowed access” is not a very common error, but still it does not let you do your job.
Sometimes when using SQLBackupAndFTP you might encounter an error saying that you cannot connect to your Azure SQL Database.
The error looks like: “Cannot open ‘<server>’ requested by the login. Client with IP address ‘<ip-address>’ is not allowed to access the server” 

Continue reading Client with IP not allowed access-Azure SQL error

Set TraceLog attribute of Google Drive destination to TRUE value

Set TraceLog attribute of Google Drive destination to TRUE value
When using SQLBackupAndFTP with Google Drive as your cloud storage for your backup files, you might encounter an error that reports “Invalid credentials”.
Read the below article in order to find out what to do in order to quickly solve this.
 

Continue reading Set TraceLog attribute of Google Drive destination to TRUE value