1 of 10 1/31/2014 4:08 PM

Transcription

1 1 of 10 1/31/2014 4:08 PM copyright 2014 How to backup Microsoft SQL Server with Nordic Backup Pro Before creating a SQL backup set within Nordic Backup Pro it is first necessary to verify that the settings of the SQL server are correct. It is important that the database Recovery Model be set to "full" and that you create an account within your SQL Server to be used exclusively for Nordic Backup. Begin by opening the SQL Server Management Studio, then expand your server as shown on the right. Then expand "Databases", and then right click on the database you would like to backup and click "Properties". In the "Database Properties" screen, click on "Options" in the left pane. Then click on the drop down box next to "Recovery Model". This should be set to "Full". The default on a new SQL installation is "Simple" which will cause the backup job to fail. Click "OK" and repeat this procedure for each database you intend to back up. This will not affect any users accessing the database.

2 2 of 10 1/31/2014 4:08 PM Now we will create the user account for Nordic Backup Pro to have access to the databases. The account needs to be setup with SQL only anuthentication, having the "sys-admin" role for full access to the databases. Expand the "Security" section below databases, then right-click on "Logins", then left-click on "New Login" in the pop-up menu. In the "Login - New" screen, first select the radio button to use "SQL Server Authentication". Then enter the account user name you wish to use in the top box. We recommend "Nordic Backup SQL". Enter the account password of your choice. Then uncheck the box to "Enforce Password Policy". This will ensure the account password will not expire and there are no complexity requirements.

3 3 of 10 1/31/2014 4:08 PM Click on the "Server Roles" in the left pane to change the roles for the account. Check the box for the "sys-admin" role. Click "OK" when complete, then close SQL Server Managent Studio. You are now ready to create a SQL database backup set in Nordic Backup Pro.

4 4 of 10 1/31/2014 4:08 PM Open Nordic Backup Pro, then click on the "Backup Setting" button at the bottom. At the top of the Backup Setting screen, click on the Plus (+) sign to create a new backup set. Nordic Backup is designed to maintain a separate backup job for each type of backup (File, Database, System State, etc.) and run them simultaneously if their backup times overlap.

5 5 of 10 1/31/2014 4:08 PM Enter a descriptive name for the backup set, for example SQL backup. Change the backup type to MS SQL Server Backup. Then the SQL server connection info will appear below the Backup Set information. This specifies the server and login information to connect to the local server. **By default, it will be populated with the local server name and SA account, however it is important to change the account information to the account that was entered in the "Login - New" screen (our example was Nordic Backup SQL). Click Next.** Select the databases to backup by clicking on the box next to it, then click Next. **If there are no databases shown, an incorrect Login ID or Password was supplied in the previous screen.**

6 6 of 10 1/31/2014 4:08 PM Set the schedule options for the database backup set. By default, the Transaction logs are scheduled to be backed up Monday through Thursday at 21:00 hours (9pm). The full database backup is scheduled on Fridays at 21:00 hours. To modify these schedules, click on the schedule and then click Properties as shown. Change backup times and days to run as you would like. We recommend running the transaction log backups several times a week and the full database at least once a week. If the database you are backing up is less than 5 GB in size, it is not necessary to perform the "Transaction Log Backup," because the full backup is compressed so well that it can be uploaded with modest bandwidth during a weeknight. In this case, remove the schedule for the transaction log backup, then modify the "Database Complete Backup Schedule" to run daily. Click Ok when done, then Next in the New Backup Set Wizard. Note: You can have more than one schedule in a backup set, i.e. you can perform intra-day backups by adding more than one daily backup schedule to your backup set.

7 7 of 10 1/31/2014 4:08 PM On this screen you may set the encryption for this backup set. You can choose between Default and Custom". If you choose "Default your files will be encrypted with the password you use to log into the Nordic Backup Pro. **Note that the encryption key then is fixed and does not change if you subsequently change the password of your account.** We recommend that you select "Custom" and enter an encryption key of your choice in the 2 bottom boxes. It is important that you choose an encryption key which only you know, thus assuring that you are the only who can access your files through Nordic Backup. **Please note that your databases cannot be restored without the encryption key. It is important that you keep it in a safe location, in case you lose your computer. Nordic Backup does not store encryption keys.** We recommend that you select the following options for encryption: AES algorithm CBC mode 256 bits Your encryption key must be at least 8 characters including upper case letters and lower case letters and at least one number. Click "OK" to continue. Click "OK" to finish creating the backup set.

8 8 of 10 1/31/2014 4:08 PM After the SQL backup set has been created, there are some advanced settings to check. You will need to ensure that the temporary location for storing the backup has enough free space and is not included in a regular file backup. You should also verify the Retention and In-File Delta settings are to your satisfaction. By clicking the "Backup Settings" button on the main screen, you can see and change settings for each backup set. In the "Backup Setting" screen you can modify any of your backup sets. To select which backup set to modify, click on the drop-down arrow button on the main screen, you can see and change settings for each backup set. If you have backup sets that belong to another machine you are backing up, do not adjust settings except from the client software directly on that machine. **It is also important NOT to have more than one instance of Nordic Backup Pro open that are connected to a single account. When you have completed the configuration of the backup client, save the settings and close the software.**

9 9 of 10 1/31/2014 4:08 PM Options Here you can select the temporary work directory for Nordic Backup. Before uploading your backup set to Nordic Backup, your data is first encrypted and compressed to ensure confidentiality. This is a disk-intensive process and a substantial amount of space is needed, therefore we recommend that you place the temporary folder on a drive which has the most free disk space. You may use an external drive as your temporary folder, but this drive must be connected during every backup or the backup will fail. Retention policy Retention is an important part of any backup because it specifies how long a changed, deleted, or older backup image is retained on our backup servers. By default, Nordic Backup is configured to retain old backup data for 7 days. However, Nordic Backup Pro can retain all previous backup data for as long as you specify, but be advised that all data is counted toward your backup storage usage. If you would like to increase or decrease your data storage limit, it can be managed through the Nordic Backup website or the Retention Policy tab of the Backup Setting screen at any time. For most backup sets, we recommend you set Retention time to 30 days minimum.

10 10 of 10 1/31/2014 4:08 PM In-File Delta Delta Block mode is very useful for backup of large files, as it only takes a backup of the changes within the file itself. Even if a file is 1 GB, it can easily change as little as 50 MB. After the initial full backup, during subsequent backups only the parts of the file that have changed will be backed up. We recommend that you adjust the default settings by clicking on the "Advanced" button. Adjusting the In-File Delta settings are recommended for large databases where you want to control the backup behavior on select days. With the In-File Delta technology enabled by default, 100 delta backups are permitted before a new backup file is created and takes the place of the previous backup file. By setting a monthly override of the delta upload, it ensures that the database will be backed up in full at Nordic Backup on certain days. Another benefit of the monthly override is to reduce the number of delta blocks and reduce the restore time. For example, check all the boxes for each month then select the radio button for the specific day. We recommend choosing the last weekday of the month. In this example, no matter how many delta backups were performed, the last weekday will always do a full backup of a new backup file. US copyright 2014

QUANTIFY INSTALLATION GUIDE Thank you for putting your trust in Avontus! This guide reviews the process of installing Quantify software. For Quantify system requirement information, please refer to the

Upgrading from MSDE to SQL Server 2005 Express Edition with Advanced Services SP2 Installation and Configuration Introduction This document will walk you step by step in removing MSDE and the setup and

Installing LearningBay Enterprise Part 2 Support Document Copyright 2012 Axiom. All Rights Reserved. Page 1 Please note that this document is one of three that details the process for installing LearningBay

NovaBACKUP Storage Server NovaStor / May 2011 2011 NovaStor, all rights reserved. All trademarks are the property of their respective owners. Features and specifications are subject to change without notice.

Microsoft SQL Server Guide Best Practices and Backup Procedures Constellation HomeBuilder Systems Inc. This document is copyrighted and all rights are reserved. This document may not, in whole or in part,

SQL Server Setup for Assistant/Pro applications Compliance Information Systems The following document covers the process of setting up the SQL Server databases for the Assistant/PRO software products form

IBM/Softlayer Object Storage for Offsite Backup How to use IBM/Softlayer Object Storage for Offsite Backup How to use IBM/Softlayer Object Storage for Offsite Backup IBM/Softlayer Object Storage is a redundant

HELP DOCUMENTATION E-SSOM BACKUP AND RESTORE GUIDE Copyright 1998-2012, Tools4ever B.V. All rights reserved. No part of the contents of this user guide may be reproduced or transmitted in any form or by

HELP DOCUMENTATION E-SSOM BACKUP AND RESTORE GUIDE Copyright 1998-2013 Tools4ever B.V. All rights reserved. No part of the contents of this user guide may be reproduced or transmitted in any form or by

Backup/Restore Microsoft Exchange Server This chapter will describe in details how to use FileTwin to backup your Microsoft Exchange Server 2000 / 2003 / 2007 and how you can restore your Microsoft Exchange

How to Copy A SQL Database SQL Server Express (Making a History Company) These instructions are written for use with SQL Server Express. Check with your Network Administrator if you are not sure if you

Article ID: 22953 SQL Tuning and Maintenance for the Altiris Deployment Server express database. Question Now Deployment Server is installed how do I manage the express database? Topics that will be covered

System Area Management Software Tool Tip: Integrating into NetIQ AppManager Overview: This document provides an overview of how to integrate System Area Management's event logs with NetIQ's AppManager.

Centrally managed backup solution User Manual Contents Desktop application...2 Requirements...2 The installation process...3 Logging in to the application...6 First logging in to the application...7 First

Doors.NET v3.5.1.21 includes a new automatic backup feature that allows you to quickly and easily schedule a full system backup. By default, this backup is performed every week on Friday at 23:00 hours

Restoring Sage Data Sage 200 [SQL 2005] This document explains how to Restore backed up Sage data. Before you start Restoring data please make sure that everyone is out of Sage 200. To be able to restore

This chapter will describe in details how to use No-Backup Software to backup Windows System State and how you can restore your Windows System State from backup. Table of Content 1. Requirements 2. Overview

MadCap Software Upgrading Guide Pulse Copyright 2014 MadCap Software. All rights reserved. Information in this document is subject to change without notice. The software described in this document is furnished

Notes: STATISTICA VERSION 9 STATISTICA ENTERPRISE INSTALLATION INSTRUCTIONS FOR USE WITH TERMINAL SERVER 1. These instructions focus on installation on Windows Terminal Server (WTS), but are applicable

Using TLS encryption with OS X Mail This guide assumes that you have already created an account in Mail. If you have not, you can use the new account wizard. The new account wizard is in the Accounts window

Getting Started with MozyPro Online Backup Online Software from Time Warner Cable Business Class A Guide for Users MozyPro is an online backup service with an easy to use interface so you can start backing

Introduction EASYLABEL 6 has several new features for saving the history of label formats. This history can include information about when label formats were edited and printed. In order to save this history,

Archive the data in the Output Manager: Setup from the Old Server 1. On the old server go to the output manager (F4) and highlight all print jobs and click the Archive button. This will compress your print

SELF SERVICE RESET PASSWORD MANAGEMENT BACKUP GUIDE Copyright 1998-2015 Tools4ever B.V. All rights reserved. No part of the contents of this user guide may be reproduced or transmitted in any form or by

Introduction Microsoft SQL Server 2005 How to Create and Restore Database (GRANTH3) Manually To use the e-granthalaya Software for automation of your library, you need to install the database management

Installation Instruction STATISTICA Enterprise Small Business Notes: ❶ The installation of STATISTICA Enterprise Small Business entails two parts: a) a server installation, and b) workstation installations

How to Add a Server/Disksafe/Volume The following document will guide you through the steps for adding a server to your HBizzDRP backup manager as well as the needed and associated aspects. Log In: Navigate

Print Audit 6 - SQL Server 2005 Express Edition Summary This is a step-by-step guide to install SQL Server 2005 Express Edition to use as a database for Print Audit 6. Pre-Requisites There are a few pre-requisites

Use the below instructions to configure your wireless settings to connect to the secure wireless network using Microsoft Windows Vista/7. 1. Click the Windows Start button, then Control Panel How-To-WCC-Secure-Windows-7-11/4/2010-4:09

Preparing to Install SQL Server 2005 Depending on your requirements, Microsoft SQL Server 2005 Setup installs a new instance of SQL Server. The following topics address important considerations for the

Instructions for Configuring a SAS Metadata Server for Use with JMP Clinical These instructions describe the process for configuring a SAS Metadata server to work with JMP Clinical. Before You Configure

Setup and configuration for Intelicode SQL Server Express Due to overwhelming demand and the increased load on support, we are providing a complete SQL Server installation walkthrough document. SQL Server

STATISTICA VERSION 12 STATISTICA ENTERPRISE SMALL BUSINESS INSTALLATION INSTRUCTIONS Notes 1. The installation of STATISTICA Enterprise Small Business entails two parts: a) a server installation, and b)

Introduction Microsoft SQL Server 2005 How to Create and Restore Database (GRANTH3) Manually To use the e-granthalaya Software for automation of your library, you need to install the database management

TSM for Windows Installation Instructions: Download the latest TSM Client Using the following link: ftp://ftp.software.ibm.com/storage/tivoli-storagemanagement/maintenance/client/v6r2/windows/x32/v623/

InformationNOW SQL 2005 Database Backup and Restoration Backing up a SQL 2005 Database Users are advised to create an hourly or nightly database backup maintenance plan. Occasionally, it may be necessary

SOS Online Backup USER MANUAL HOW TO INSTALL THE SOFTWARE 1. Download the software from the website: http://www.sosonlinebackup.com/download_the_software.htm 2. Click Run to install when promoted, or alternatively,

3 Setting up Databases on a Microsoft SQL 7.0 Server Overview of the Installation Process To set up GoldMine properly, you must follow a sequence of steps to install GoldMine s program files, and the other

This document describes how to configure, implement, and manage a local archive for your SonicWALL CDP appliance. It contains the following sections: Feature Overview section on page 1 Using Local Archiving