Showing results 1 to 1 of 1

Thread: Restore project from SQL Database Folder

  1. #1
    Join Date
    20.08.2009
    Posts
    293

    Default Restore project from SQL Database Folder

    If there is no workspace or project backup projects can be restored via the following procedure:

    (In this specific case one computer crashed and the operating system was not operable anymore, but the SQL folders could be saved and backed up. The procedure could also be used for moving the SQL folders from one installation to another.)

    • From the old crashed PC, back up the SQL folders (folders with the GUID as name, like 9403a5ef-551d-4e61-a014-c3d4bc4e19cc) of your old projects from "C:\Documents and Settings\All Users\Application Data\COPA-DATA\SQL\..."
      (you have to open the DB.INI files in the several folders to identify the projects: NAME=PROJECTNAME)


    • On your new PC paste the GUID folders to your SQL directory "C:\Documents and Settings\All Users\Application Data\COPA-DATA\SQL\"


    • Start the tool testconnection.exe on your new PC -> Open Maintenance: On the left side the SQL folders are shown, your copied folders should be visible.


    • Select your folders and press the [ >> ] Button. The files are attached to the database on your new PC. (alternatively also the SQL Management Studio can be used for attaching the files)


    • Terminate the process zenDBSrv.exe (it is automatically restarted with the next start of the editor)


    • Start the zenon editor, open a workspace and select "Insert existing project...", your restored projects should be visible. Select the project you want to open.


    The testconnection tool can be found here:

    http://www.copadata.at/forums/showthread.php?t=785
    Last edited by bernhardf : 13th October 2009 at 09:23

Similar Threads

  1. SQL Database files
    By bmcbrita in forum zenon Supervisor
    Replies: 7
    Last Post: 17th June 2009, 14:26
  2. Missing 'Storage Card' folder
    By scotttee in forum zenon Operator
    Replies: 2
    Last Post: 15th May 2009, 13:06
  3. Could not restore backup in the editor
    By jegloco in forum zenon Supervisor
    Replies: 1
    Last Post: 2nd February 2009, 10:49
  4. Backup database
    By matholton in forum zenon Supervisor
    Replies: 1
    Last Post: 17th October 2008, 13:49
  5. Restore deleted links in elements
    By sebastiank in forum VBA
    Replies: 0
    Last Post: 28th August 2007, 09:58

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •