Network Drive Backup Solution

Network Drive Backup usually means backing up to a computer, connected via network. This is an effective and very simple way to protect especially important data from loss or corruption.

Network backup for drives might be a tricky thing. Let’s see the issues on the example of MS SQL database backup.

Configuring Network Drive Backup: MS SQL Databases

Using the inner SQL Server instrumentality instead of a specialized backup server software solution meant to manage the backing up of MS SQL databases, you might have data copying problems caused by:

• Impossibility of backing up to remote drives;
• No means for backup management for offsite servers;
• No backup data encryption and compression;
• Impossibility of copying of individual DBs objects.

Also, one of the most important issues of network drive backup is what type of schedule to use (the vital necessity of backup scheduling is supposed to be clearly obvious here). The choice depends on different factors:

• The DBs size (in case of big size it&8217s better to use differential backup in addition to full database backup);
• Intensity of the DBs overpatching (usually the network drive backup has to be as more frequent as bigger the size of overpatching is);
• Necessary speed of recovery.

According to the above said, the highly recommended backup network settings for relatively big (say, about 100 Gb) databases are:

• Weekly: full database backup
• Every 24 hours (at night optimally): differential backup
• Several times a day: transaction log backup

Backing Up MS SQL via Network: the Software

Handy Backup is a comprehensive software solution to back up network drives in a home LAN, or to organize an effective backup system for an entire enterprise network (with the super mighty Network Server edition).

The software provides a bunch of rather simple solution for most of network drive backup problems. Here are some of the features the program proves this with:

Among other notable features there are disk imaging, support of various storage media (local and external hard drives, optical disks, USB drives, FTP/SFTP/FTPS server), and others.

A network drive backup will help you to preserve and (if necessary) to recover your databases. Go for it with no delay with Handy Backup!