Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Notifications
Login / Register
Community
Community
Notifications
close
  • Forums
  • Knowledge Center
  • Events & Webinars
  • Ideas
  • Blogs
Help
Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Login / Register
Sustainability
Sustainability

Join our "Ask Me About" community webinar on May 20th at 9 AM CET and 5 PM CET to explore cybersecurity and monitoring for Data Center and edge IT. Learn about market trends, cutting-edge technologies, and best practices from industry experts.
Register and secure your Critical IT infrastructure

Move / Backup / Restore a database on a Single User SQL2005 Express system

Building Automation Knowledge Base

Schneider Electric Building Automation Knowledge Base is a self-service resource to answer all your questions about EcoStruxure Building suite, Andover Continuum, Satchwell, TAC…

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Home
  • Schneider Electric Community
  • Knowledge Center
  • Building Automation Knowledge Base
  • Move / Backup / Restore a database on a Single User SQL2005 Express system
Options
  • Bookmark
  • Subscribe
  • Email to a Friend
  • Printer Friendly Page
  • Report Inappropriate Content
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close

Related Forums

  • Intelligent Devices Forum

Previous Next
Contributors
  • DavidFisher
    DavidFisher
  • PaulFr
    PaulFr
  • AdamSteele
    AdamSteele
  • Product_Support
    Product_Support

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague Invite
Back to Building Automation Knowledge Base
Options
  • Bookmark
  • Subscribe
  • Email to a Friend
  • Printer Friendly Page
  • Report Inappropriate Content
0 Likes
4729 Views

Link copied. Please paste this link to share this article on your social media post.

Trying to translate this page to your language?
Select your language from the translate dropdown in the upper right. arrow
Translate to: English
  • (Français) French
  • (Deutsche) German
  • (Italiano) Italian
  • (Português) Portuguese
  • (Русский) Russian
  • (Español) Spanish

Move / Backup / Restore a database on a Single User SQL2005 Express system

Picard Product_Support
‎2018-09-07 06:40 AM

Issue

Databases often have to be moved around or upgraded, especially on engineers laptops where they may do offline engineering. What is the best tool to use for this?

Product Line

Andover Continuum

Environment

  • Continuum Single User (Standalone) Version 1.82 and above with SQL Express (2005) Stand alone DB
  • SQL Server Management Studio Express

Cause

The WinSQL software as used with previous Continuum versions with MSDE (2000) does not operate with SQL2005 and another method of accessing the database is required.

Resolution

  1. After installing Cyberstation with a blank database and verifying correct operation, the next thing to install is the “SQL Server Management Studio Express” software a free Microsoft download, see link below and use the 32 bit version:
    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796
    This will provide the same user interface as provided on a full SQL2005 installation as used on a LAN system. For Continuum V2.0 and above SQL2012 Express is used, both 32 and 64 bit versions of this are available from the following Micosoft download: http://www.microsoft.com/en-us/download/details.aspx?id=35579
  2. There are 2 methods to transfer your database from one system to another, using a. Backup/ Restore or b. Detach/ Attach, both options are covered below. Alternatively you may already have one or other formats on backup media.
    To use Backup or Detach you will also need to install SQL Server Management Studio Express as per 1. above on the original computer.
    1. Backup Method - you will need to perform a full backup and then restore of the ContinuumDB on the original computer:
      Using SQLE Management Studio, Right-click on ContinuumDB -> Tasks -> Backup, add a destination where you want to save the .BAK file, Click OK.
    2. Detach Method – Detach (or stop the SQL) to allow the files to be copied on the original computer:
      Using SQLE Management Studio, Right-click on ContinuumDB -> Tasks -> Detach, Click OK.
  3. On your new system, make sure you have already created a new ContinuumDB using Database Initialization. If not, do this now - this creates the Database, SQL jobs, stored procedures, adds Andover97 as an admin and a lot of behind the scenes security settings. Stop Cyberstation if it is running.
    If you are using the Detach / Attach method b. then:
    Using SQLE Management Studio on the new computer, Right-click on ContinuumDB -> Tasks -> Detach, Click OK.
  4. Copy the backed up files to the Data directory your new server.
    It is advisable to take a copy of the blank database first.
    Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
  5. Using SQL Management Studio, now restore or attach the backed up database depending on which method is being used.
    1. Restore Method - Restore the backup over the top of the ContinuumDB on your new system:
      Right click on ContinuumDB -> Tasks -> Restore -> Database. Select "From device:" and add your Database file, making sure to tick the Restore checkbox to select the source. Next, go to the Options page and select "Overwrite the existing database" and press the "OK" button.
    2. Attach Method - Using SQLE Management Studio on the new computer, Right-click on Databases -> Attach, Press “Add” and select the ContinuumDev.mdf file, Press OK. The .mdf and .ldf files will be shown, press OK. The ContinuumDB will appear in the tree.
  6. Change the db owner with the below query using the sp_changedbowner stored procedure. Select "New Query" and copy the query text shown below. Run the query.
    use ContinuumDB
    go
    sp_changedbowner 'Andover97'
    go
  7. Run Database Initialization and update the newly restored database.
  8. Using Database Initialization from each Cyberstation, initialize your Workstations into the new Database.
  9. Run Cyberstation on all Workstations.
Labels (1)
Labels:
  • Andover Continuum
Tags (5)
  • Find more articles tagged with:
  • 4635
  • sqlmanagementstudio_x64_enu.exe
  • sqlmanagementstudio_x86_enu.exe
  • sqlserver2005_ssmsee.msi
  • sqlserver2005_ssmsee_x64.msi
Was this article helpful? Yes No
No ratings

Link copied. Please paste this link to share this article on your social media post.

To The Top!

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practice
  • Experts Leaderboard
  • Contact Support
Brand-Logo
Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Forum-Icon

Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account? Login

Terms & Conditions Privacy Notice Change your Cookie Settings © 2025 Schneider Electric

This is a heading

With achievable small steps, users progress and continually feel satisfaction in task accomplishment.

Usetiful Onboarding Checklist remembers the progress of every user, allowing them to take bite-sized journeys and continue where they left.

of