PANTHEON™ Help

 Toc
 Početna stranica - PANTHEON uputstva
[Collapse]PANTHEON
 [Collapse]PANTHEON priručnici
  [Expand]Vodič po Datalab PANTHEON FarmAccounting
  [Expand]Vodič po PANTHEON Retail
  [Expand]Vodič po DataLab PANTHEON™
  [Expand]Vodič po PANTHEON VET
 [Collapse]PANTHEON korisnički priručnici
  [Expand]Korisnički priručnik za DataLab PANTHEON
  [Expand]Korisnički priručnik za PANTHEON Vet
  [Expand]Korisnički priručnik za PANTHEON Maloprodaju
  [Expand]Korisnički priručnik za PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Vodiči po PANTHEON Web
  [Expand]Vodič za PANTHEON Web Terminal
  [Expand]Vodič po PANTHEON Web Light
  [Expand]Vodič za PANTHEON Web Legal
  [Expand]Arhiva starih proizvoda
 [Collapse]Korisnički priručniki za PANTHEON Web
  [Expand]Kako započeti s programom PANTHEON Web
  [Expand]Korisnički priručnik za PANTHEON Web Light
   Korisnički priručnik za PANTHEON Web Terminal
  [Expand]Korisnički priručnik za PANTHEON Web Legal
  [Expand]Arhiva starih proizvoda
[Collapse]PANTHEON Granule
 [Collapse]Vodič za PANTHEON Granule
  [Expand]Granula Kadrovi
  [Expand]Granula Putni nalozi
  [Expand]Granula Dokumenti i zadaci
  [Expand]Granula Nadzorna ploča
  [Expand]Granula B2B naručivanje
  [Expand]Granula Servis na terenu
  [Expand]Inventar Fiksne Imovine Granula
  [Expand]Granula Inventura skladišta
 [Collapse]Korisnički priručnik za PANTHEON Granule
   Početak
   Primjer korištenja PANTHEON Granula u fiktivnom preduzeću
  [Expand]PANTHEON Granule i aktivacija
  [Expand]Granula Kadrovi
  [Expand]Granula Putni nalozi
  [Expand]Granula Dokumenti i zadaci
  [Expand]Granula B2B Naručivanje
  [Expand]Granula Nadzorna ploča
  [Expand]Granula Servis na terenu
   PANTHEON Granule - česta pitanja i odgovori
  [Expand]Inventar Fiksne Imovine Granula
  [Expand]Inventar u skladištu granula
  [Expand]Arhiva
[Collapse]Korisničke stranice
  Test 2
  Test 3
  Test 5
  TEST_Kreiranje noveg zaposlenika 1000003067
  TEST_Kreiranje noveg zaposlenika 1000003067-MK
  TEST3_Kreiranje novog dokumenta 1000003410-SL
  TEST2_Uređivanje kontaktnih podataka 1000003415-SL
  Test
 [Collapse]Test za CG
   Test podređeni 1
  TEST_Kreiranje noveg zaposlenika 1000003067-BA
  TEST_Kreiranje novog zaposlenika 1000003067-SR
  TEST_Kreiranje noveg zaposlenika 1000003067_EU_ORIG
 [Collapse]Pantheon hosting
  [Expand]Hosting robot
  [Expand]DEMO hosting
  Porez ( cookies )
 [Collapse]Prijava na korisničke stranice
   Registracija za Pantheon korisnike
   Glavna stranica
   Prva posjeta korisničkom sajtu
  Novosti
  Uvod u Wiki
  Upute za stranicu izbornika
 [Collapse]Potpora
  [Expand]Tehnička podrška
   Podrška na daljinu za Host korisnike
  [Expand]Daljinska podrška
  Kako upotrebljavam i dopunjujem wiki ?
 [Collapse]Pomoć
   Pantheon Hosting
   Uporedba verzija pantheona
  [Expand]Dokumentacija
   Vsa navodila
   Video uputstva
   Video novosti
   Pitaj druge korisnike
   Postanite PANTHEON svetovalec
   Sve vijesti
   Svi događaji
   Pregled opomb i planova
   Plan
 [Collapse]Informacije
   Obavijesti
  [Expand]Nastavitev deviznih tečajev
 [Collapse]Moji podaci
   Ugovor o osvježavanju
   Podaci o kompaniji
  [Expand]Pooblaščene osobe
   Dovoljenja
   Lični podaci
   Kontaktni podatci
   Osveževalna pogodba
 [Collapse]Forum
   Spremljanje foruma
 [Collapse]Video
   Instruktivni videozapisi
   Video Ažuriranja
  Portal za razvijače
  Tržnica
 [Collapse]Wiki uputstva
  [Expand]Uvod u wiki
  [Expand]Pretraga po Wikiju
  [Expand]Uređenje Wiki-a
   Pripenjanje dokumentov

Load Time: 374,9864 ms
"
  6613 | 1 | |
Label


Restoring Database onto SQL Server

The following instructions present how a user can restore a database onto the SQL server.

Table of contents

  1. Downloading and Expanding Database from FTP Server
  2. Restoring (mounting) Database onto SQL server via the Management Studio
  3. Checking the Database Version via SQL Editor

1. Downloading and Expanding Database from FTP Server

Through the File Explorer or any internet browser, the user opens the link http://ftp.datalab.eu/databases/.

By clicking the correct database from the list below, the user can download different databases.

EU_FA.zip An empty farming database with English collation.
EU_FA_DEMO.zip A DEMO farming database with English collation.
EU_LT.zip An empty database with English collation for owners of LT licenses.
EU_LT_DEMO.zip A DEMO database with English collation for owners of LT licences.
EU_MF.zip An empty database with English collation for owners of other PANTHEON licences.
EU_MF_DEMO.zip A DEMO database with English collation for owners of other PANTHEON licences.
EU_VET.zip An empty database with English collation for owners of VET licenses.
EU_VET_DEMO.zip A DEMO database with English collation for owners of VET licenses.

 

The file is normally downloaded to the Downloads folder (computer setting).

After downloading the database from the FTP server, it must be expanded from the archive with a suitable archiver.

00001.gif
WARNING

For quick decompressing of archival files, the free archiver 7zip is recommended.

 

The user saves the downloaded and decompressed backup copy of the database (ending .bak) from the archive to the place set when installing the SQL server – the backup folder.

In this case, the user selects the file C:\#sql\backup.

HINT

See the link for installing SQL server – the Database Engine Configuration step.

2. Restoring (mounting) Database onto SQL server via the Management Studio

In the Start menu, the user finds Management Studio and runs it. When the program is running, the user logs into the SQL server.

00001.gif
WARNING

For more information about installing, running, and logging into the SQL server via Microsoft SQL Management Studio, see the chapter Microsoft Management Studio – Download and Installation.

 

After logging into the SQL server, the user expands the instance (usually .\DATALAB) by clicking the plus in the Object Explorer.

The user marks and right-clicks the Databases and selects the menu Restore Database.

A new Restore Database window opens.

In the menu, under Source, the user selects the checkbox Device, then selects ..., to open a new chat window Select backup devices.

By clicking the Add button, the user finds the database, which was previously downloaded from the FTP server and expanded with a suitable archiver.

The user finds the decompressed database on the hard drive (usually named SI_XX.bak), marks it and confirms the choice by clicking the OK button.

After selecting the database, the user confirms it by clicking the OK button in the Select backup devices window.

The Restore Database window offers the user the option to name the database on the SQL server in the Database field of the Destination section.

Normally, the database is named with the short name of the company for which the new database is being mounted.

When naming a database, you can confirm the restoration of the database on the SQL server with the OK button in the Restore Database window.

00001.gif
WARNING
  1. Management Studio restores the database to the path set when installing the SQL server (data, log). For more information, see the chapter Download and Installation.
  2. If you want to change the location of the restored (.mdf and .ldf) files, you can change the location in the Select a page | Files section.
  3. The database can also be restored manually, through the SQL editor with the command:

    RESTORE DATABASE [SI_MF] FROM DISK = N'C:\#sql\backup\SI_MF.bak'

    WITH FILE = 1,

    MOVE N'DataLab_Data' TO N'C:\#sql\data\MOJA_PRVA_PRAZNA_BAZA.mdf',

    MOVE N'DataLab_Log' TO N'C:\#sql\log\MOJA_PRVA_PRAZNA_BAZA_1.ldf',

    NOUNLOAD,

    STATS = 5

    GO

 

If your database is successfully restored onto the SQL server, it is visible in the Object Explorer window, in the Databases section.

3. Checking the Database Version via SQL Editor

The user wants to check the database version. The user selects and right-clicks the database and selects New Query.

In the SQL editor, the user enters the command: select * from tpa_sysparamsys

In the anBuildNo. column on the Results tab, the user reads the database version.

The user must know the database version to download the correct PANTHEON program package from the FTP server.

00001.gif
WARNING

After restoring the database, the users must be transferred from the database to the server level. For more information, see the chapter Adding Users to Server Level (AddUser_PAX).

 

  

     


Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!