Category Archives: network drive

network drive

SQLBackupAndFTP v11 – What’s New?

differential, network drive, sqlbackupandftp

Have you seen our brand-new version 11 of SQLBackupAndFTP?  If yes, then you have also noticed that its looks and feels very different from its predecessor (compare features in the new & old versions). That’s right – this release is built from scratch based on our eight-year experience creating SQL Server backup software and close to 1,000,000 installations of the previous versions.

If you have used the old version, this post will help you to quickly grasp the main points that make the new version better. If you are new to SQLBackupAndFTP, you can read this as a quick introduction. Continue reading SQLBackupAndFTP v11 – What’s New? →

How Tos – SQLBackupAndFTP

amazon, network drive, sqlbackupandftp

Licensing

Database Backups

Backup Storages

Database-related settings

Security & Reliability

Errors

Cannot Open Backup Device Operating System Error 5(Access is Denied)

adventureworks, network drive, SQL Server

Sometimes when you backup your SQL Server using SQLBackupAndFTP, SSMS or T-SQL Commands you can face the following issue Cannot Open Backup Device Operating System Error 5(Access is Denied). This has to be the most famous issue in taking SQL Server database backups. There are several reasons for this error and there are various ways to solve it. Some time ago we met this issue and for a time we were creating a backup and discovered a very helpful resolution to the issue. The issue was as described beneath:

Msg 3201, Level 16, State 1, Line 4
Cannot open backup device 'D:\Adventureworks.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 4
BACKUP DATABASE is terminating abnormally.

Continue reading Cannot Open Backup Device Operating System Error 5(Access is Denied) →

SQL Server Express Backup

network drive, SQL Server, sqlbackupandftp

While it’s easy to create SQL Server Express backup with SQL Server Management Studio it’s quite difficult to run it regularly since SQL Server Express edition lacks handy job scheduler maintenance options in comparison with the full version of SQL Server. Here is where third-party backup utilities like SQLBackupAndFTP enter the stage. Continue reading SQL Server Express Backup →

How to Make SugarCRM Backup

amazon, network drive, Uncategorized

sugarcrm logoToday over 50,000  companies use SugarCRM globally for their customer management, sales automation, and other CRM needs. SugarCRM can be installed as an on-premise solution or as a SaaS (Software-as-a-Service) solution. Managing SugarCRM means that you have to work with a huge flow of information that is stored in large databases. Clearly, when working with databases one has to take care of their security, and that implies making backups on a regular basis. Now let’s check how to use SQLBackupAndFTP for regular SugarCRM backups.
Continue reading How to Make SugarCRM Backup →

How to backup SQL Server to UNC Path

network drive, SQL Server, sqlbackupandftp, , , , ,

If you have limited access to SQL Server’s file system, getting the .bak file back may be an issue. In this case, you can send database backup to some network folder if both you and the SQL Server have access to it.

We will show how to do it with SQLBackupAndFTP. Continue reading How to backup SQL Server to UNC Path →

How to backup a SQL Server database to NAS drive

network drive, SQL Server, sqlbackupandftp, , ,

backup a sql server database to nasBacking 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 →