Backup / migration of a Coffalyser.Net database

Transcription

1 Backup / migration of a Coffalyser.Net database There are two main procedures for backup or migration of your Coffalyser.Net database. One of these procedures makes use of the SQL management studio software and is not explained in this document. Installation and usage of this software for backup or migration of Coffalyser.Net databases is described in another document. Using the SQL management studio is recommended for advanced users who are using SQL database clusters and/or want to perform regular backup of the Coffalyser.Net database. This document describes how to perform a manual backup of a SQL database using no additional software. Coffalyser.Net components In general, Coffalyser.Net uses 3 components to function. First we have the Coffalyser.Net end-user (or client) application, which runs on desktop machines and can connect to any Coffalyser.Net server application, local or remote. The second component is what we call the Coffalyser.Net server application, which communicates with the clients on one side and the database on the other. Lastly we have the database itself, which can run on any version of Microsoft SQL, on any computer in the network. When the Coffalyser.Net needs to run in a large scale environment we commend that you install the database on a high capacity/performance SQL server. Most enterprise environments have a dedicated server for this purpose.

2 Step 1 Locating and copying the database files Step 1.1 Open computer management Open the computer management console on the machine which is currently hosting the database by right clicking on the My Computer icon and then selecting manage from the context menu.

3 Step 1.2a Stop active Coffalyser.Net SQL server Expand the Services and Applications node and select services. Locate the Coffalyser.net Server item and stop it by right clicking on it and then selecting stop from the context menu.

4 Step 1.2b Stop active Coffalyser.Net SQL server (COFFALYSER) Now locate the SQL Server (COFFALYSER) item and stop it by right clicking on it and selecting stop from the context menu. The SQL server should now shut down and release its lock on the database files, after which we can perform normal file operations like copy.

5 Step 1.3 Copy the database files Open Windows Explorer and navigate to C:\Program Files\Microsoft SQL Server\MSSQL10_50.COFFALYSER\MSSQL\DATA. In this folder you will find two files that contain all the data, the Coffalyser.mdf and Coffalyser_log.ldf file. To make a backup of the data, simply copy these files and placing it on an alternative location. If you only want to make a backup of your data, you are finished and you only need to restart the SQL server as described at step X. If you want to move the database to a different computer then copy these files over the network or use an external hard drive / USB thumb drive.

6 Step 1.4a Restart active Coffalyser.Net SQL server If you want to continue using the Coffalyser.Net on the computer where you have just made a copy of the database files then you need to restart the Coffalyser.Net server. Open the computer management console on the machine which is currently hosting the database by right clicking on the My Computer icon and then selecting manage from the context menu, as shown at step 1. Expand the Services and Applications node and select services. Locate the Coffalyser.net Server item and start it by right clicking on it and then selecting Start from the context menu.

7 Step 1.4b Restart active Coffalyser.Net SQL server (COFFALYSER) Now locate the SQL Server (COFFALYSER) item and start it by right clicking on it and then selecting start from the context menu. The SQL server should now restart and the Coffalyser.Net database can again be used on this computer.

8 Step 2 Restoring the database The next steps are not required if you only want to make a backup of the Coffalyser.Net database, but explain the procedure how you can use the copied database at step 1 and restore it at a different computer without the use of any additional software. Step 2.1 Install Coffalyser.Net First install the last version of Coffalyser.Net on the new Computer. Please use the most recent version of our Coffalyser.Net by downloading it from your MyMLPA account on In case you already have a MyMLPA account you can also directly download the file from: During installation you will be asked to create a new database. Follow all the steps as described in the installation manual. When you get to the point that you can create a new database and you can fill in the database name, then give it EXACTLY the same name as the database you have copied from the other computer and complete the installation as you would have done earlier on the computer that is currently hosting the database. Step 2.2 Stop active Coffalyser.Net SQL server Open computer management and stop the Coffalyser.Net SQL server. After completing the installation a new server is running on that computer. You first need to stop this server through computer management as described at steps 1.1 and 1.2. Step 2.3 Replace the database files Open the windows file browser and navigate to C:\Program Files\Microsoft SQL Server\MSSQL10_50.COFFALYSER\MSSQL\DATA. Now copy the old database files and paste them in the location of the SQL server that you have just opened and replace the two database files. Step 2.4 Replace the database files When the files are replaced, and then restart the SQL server, by undoing the previous action in Services and Applications, as described at step 1.4.

9 Step 2.5 Reconfigure Coffalyser.Net Restart the Coffalyser.Net and start the configuration. Follow the steps of the configuration as described in the installation manual. Pass through all the steps, as also described in the installation manual. After this you should be able to view the data from the old database.

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

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

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

Hyperoo 2.0 A (Very) Quick Start Download and install the Hyperoo 2.0 beta Hyperoo 2.0 is a client/server based application and as such requires that you install both the Hyperoo Client and Hyperoo Server

PCS Axis Database Backup and Restore Best Practices October 2014 Introduction This document explains how to backup and restore a PCS Axis database using Microsoft SQL Server Management Studio (SSMS). The

Print Audit 6 - How to Move Print Audit 6 and a SQL Server 2005 Express Database to a New Server Overview This document includes the steps to move Print Audit 6 and a SQL Server 2005 Express database to

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

Connecticut Hazardous Waste Manifests Database Due to limitations inherent to Microsoft Access, the Department has migrated this database to Microsoft SQL Server. The user interface will remain the same.

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

How To Set Up Dataprotect This document will show you how to install and configure your computer for a Typical installation. If you have questions about configuring a Custom installation please contact

SELF SERVICE RESET PASSWORD MANAGEMENT BACKUP GUIDE Copyright 1998-2016 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

Database Operations (Backup/Restore/Move/Manage) Technical Support Engineering Rosslare Security NA For more information please see www.axtraxng.com Database management operations may be performed to insure

Technical Bulletin SQL Express Backup Utility May 2012 Introduction This document describes the installation, configuration and use of the SATEON SQL Express Backup utility, which is used to provide scheduled

Installation / Backup \ Restore of a Coffalyser.Net server database using SQL management studio This document contains instructions how you can obtain a free copy of Microsoft SQL 2008 R2 and perform the

Sharing ManagePro Databases in a Small Workgroup from your local PC without a server This document describes how to setup a pc to function like a server and enable sharing of your ManagePro 11 database

for Networks Installation Guide for the application on the server August 2014 (GUIDE 2) Lucid Exact Version 1.7-N and later Copyright 2014, Lucid Innovations Limited. All Rights Reserved Lucid Research

1 INTRODUCTION This document provides a high-level overview of the DBCrystal installation process. There are two major tasks required. First, the host computer is checked for prerequisites like Microsoft.Net

How to Back Up and Restore a Dynamics NAV 2015 Database Using SQL and PowerShell: Prerequisite: NAV Server Instance: In these instructions, I do not cover how to configure a NAV Server Instances. However,

Database Back-Up and Restore Introduction To ensure the data held in People inc. is secure regular database backups of the databases must be taken. It is also essential that the procedure for restoring

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,

QlikView 11 Upgrade & Migrations QlikView Technical Brief Published: November 2011 qlikview.com Introduction This guide is provided as a reference and best practices for upgrading and migrating an existing

How to Back Up and Restore an ACT! Database Answer ID 19211 Please note: Answer ID documents referenced in this article can be located at: http://www.act.com/support/index.cfm (Knowledge base link). The

for Networks Installation Guide for the application on a server September 2015 (GUIDE 2) Memory Booster version 1.3-N and later Copyright 2015, Lucid Innovations Limited. All Rights Reserved Lucid Research

A VA LA N C HE U PGRA D E PROCESS If you already have Avalanche servers installed, then you will want to perform an upgrade to preserve existing data. The installer for Avalanche 6.0 migrates the profiles,

DocAve Upgrade Guide From Version 4.1 to 4.5 About This Guide This guide is intended for those who wish to update their current version of DocAve 4.1 to the latest DocAve 4.5. It is divided into two sections:

Xactimate v.27 Network Installation Requirements Like all networked software applications, Xactimate Version 27 must be installed on a workstation connected to a network that has been properly set up and

Online Backup by Mozy Restore Common Questions Document Revision Date: June 29, 2012 Online Backup by Mozy Common Questions 1 How do I restore my data? There are five ways of restoring your data: 1) Performing

Installing ManagePro 12.1 in Shared Database (Workgroup) Mode Overview 1 ManagePro 12.1 can be operated in Workgroup (also known as remote client ) mode where it accesses a shared SQL database in a LAN

Overview Thank you for choosing to install FLEETMATE, low-cost fleet maintenance management software that can help you become proactive with fleet maintenance, extend the useful life of your fleet assets,

Adding Outlook to a Blackberry, Downloading, Installing and Configuring Blackberry Desktop Manager The following instructions work for the District provided Blackberrys from Sprint, but I think it should

EVE5 Hardware and Software Requirements EVE5 is a Client/Server program. i.e. there are 2 components to the program: 1/ The Server: this controls your database and will be installed on one computer only.

NovaBACKUP xsp Version 15.0 Upgrade Guide NovaStor / November 2013 2013 NovaStor, all rights reserved. All trademarks are the property of their respective owners. Features and specifications are subject

FAQ How does the new Big Bend Backup (powered by Keepit) work? Once you establish which of the folders on your hard drive you ll be backing up, you ll log into myaccount.bigbend.net and from your control

Moving a CIMPLICITY SQL Database using Detach/Attach Proficy HMI/SCADA CIMPLICITY Introduction The purpose of this document is to outline the minimal steps required to move a Microsoft SQL Server Express

Using Remote Web Workplace Version 1.01 Remote web workplace allows you to access your Windows XP desktop through Small Business Server 2003 from a web browser. 1. Connect to the Internet in your remote

Resolving errors when restoring databases Problem: User receives an Unhandled Exception Error when attempting to restore a database. This error is usually caused by one of three issues. If the Exception

ilaw Installation Procedure This guide will provide a reference for a full installation of ilaw Case Management Software. Contents ilaw Overview How ilaw works Installing ilaw Server on a PC Installing

Best Practices for Backup of Microsoft SQL 2000 Databases with Unitrends Backup Professional Introduction The information presented in this document is a supplement to the SQL Server Agent chapter in the

16.4.3 Optional Lab: Data Backup and Recovery in Windows Vista Introduction Print and complete this lab. In this lab, you will back up data. You will also perform a recovery of the data. Recommended Equipment

Step by Step HOW TO Transfer a Library File from one PC to Another This How To article explains how to move a library file from one PC to another For a complete list of available How To documents visit

Backing up FRS: Method 1 Only Files Needed You can backup only the file that you ll need to restore FRS during a new install using the instructions below. Things to remember: Backing up FRS does NOT mean