Showing posts with label Backup. Show all posts
Showing posts with label Backup. Show all posts

Friday, 21 March 2014

[YLN] System Image Backup using Windows Backup ( Windows 8.1) to Linux NAS

Windows 8.1 comes with System Image Backup but it needs to be manually run and cannot be scheduled from GUI.

If you have purchased Linux NAS storage that uses sparse file allocation and does not have root privilege, you will encounter error when running Windows System Image Backup directly into Linux NAS share folder.

Since you have purchase it, I advise make use of it and create a system image backup with VHD for recovery in case.

You decide!!

Wednesday, 19 March 2014

[YLN] System Image Backup using Windows Server Backup (2012/2012 R2) to Linux NAS

Windows Server Backup is backup software that comes with Windows Server with no additional cost.

It supports Bare metal backup but it only supports disk backup only.

Organization that has little budget for backup storage may purchase Linux NAS appliance but Windows Server Backup cannot write when Linux NAS installed with file system that uses sparse file allocation such as ext4/XFS.

If the organization already purchased this NAS, it is better to make full use of it rather than no backup being performed at all.

You decide!

To read further System Image Backup using Windows Server Backup (2012/2012 R2) to Linux NAS

Monday, 6 January 2014

Admin Script: Backup SQL Server Databases with Week Of Month Timestamp

This is my collection of generic database backup script for SQL Server using SQLCMD.exe.

The purpose of the script is to backup SQL Server database in the Week Of Month format. The script is invoked via task scheduler to perform database backup (System and User database) weekly

This script consists of two files:
1. SqlServerBackup_WeekOfMonth.cmd
    Script to setup configuration and the script invocation from Task Scheduler

2. SqlServerBackup_WeekOfMonth.sql
    T-SQL Script to perform the database backup


This script works for SQL Server Database (Express or Full Version) from version 2008 and above.

If the setup is done properly, the final result is as follows: