10 votes

SQL BackUp

OVERVIEW:

This package adds a tab to the developer section and provides simple functionality to allow the user to create a full backup of their Umbraco database.

For MSSQL Server installations, a .bak file is created and placed in a new folder called SQLBackUp within the App_Data directory of the Umbraco website.

For SQL CE installations, a duplicate of the live .sfd file is created and placed in a new folder called SQLBackUp within the App_Data directory of the Umbraco website.

Previous backup files are listed and can be downloaded or deleted individually, or all files can be downloaded as a compressed .zip file.

Note: This package does not currently support MySQL installations.

COMPATIBILITY:

Currently tested with SQL CE and MSSQL Server 2012 and 2008 R2 on;

Umbraco 7.2.x, 7.1.x, 7.0.x, 6.2.x, 6.1.x and 6.0.x

HISTORY:

This package was originally thrown together to assist during development of websites, providing a quick and accessible way to perform backups without needing to log onto the MSSQL server directly. I'm hoping this will be useful to others.

+++ Be aware it is not best practice to leave db backups within the website files on a production server +++

CHANGE LOG:

v1.1:
Small bug fix to allow full-stops (dot convention) in database name. Thanks to Kim Thomsen for this quick find.

 

v1.2:
Moved the backup folder to underneath App_Data folder for increased security.

 

v1.3:
Fixed issue to timeouts on larger DBs.

Added file backup for SQL CE - to allow backup of live flat file db without the need to stop IIS or take application offline.
Added file size and type information to table.
Fixed Zip download folder structure - now collates all files into a single folder within the zip file.

Recommend uninstall of previous versions before installing v1.3

 

Package URL: http://www.alliancemedia.co.uk/sqlbackup/

Screenshots

Package owner

Adam Maidment

Adam Maidment

Adam has 163 karma points

Package Compatibility

This package is compatible with the following versions as reported by community members who have downloaded this package:
Untested or doesn't work on Umbraco Cloud
8.3.x (untested)
8.2.x (untested)
8.1.x (untested)
8.0.x (untested)
7.15.x (untested)
7.14.x (untested)
7.13.x (untested)
7.12.x (untested)
7.11.x (untested)
7.10.x (untested)
7.9.x (untested)
7.8.x (untested)
7.7.x (untested)
7.6.x (100%)
7.5.x (100%)
7.4.x (100%)
7.3.x (100%)
7.2.x (100%)
7.1.x (100%)
7.0.x (100%)
6.1.x (100%)
6.0.x (100%)

You must login before you can report on package compatibility.

Package Information

  • Package owner: Adam Maidment
  • Created: 07/11/2014
  • Current version 1.3
  • .net Version 4.5
  • License MIT
  • Downloads: 1871