Solved

Need to move SmarterTrack to another server

Posted on 2015-02-12
8
215 Views
Last Modified: 2015-05-06
Hi there,

I must move a locally hosted SmarterTrack 9.5 to another server.

Also, on the new server, I need to upgrade to the latest version.

Can you please provide me with he instructions?

Thanks
0
Comment
Question by:ReneGe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 13

Expert Comment

by:Rizzle
ID: 40606418
0
 
LVL 10

Author Comment

by:ReneGe
ID: 40606463
Hi Roshan,

Thanks for your prompt reply.

However, in this installation iinstruction, it is not mentionned how to backup and restore the curent system in detail (Database and everything).

Thanks and cheers
0
 
LVL 13

Expert Comment

by:Rizzle
ID: 40606468
How is your database currently hosted? SQL Express or SQL Dedicated standalone?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 10

Author Comment

by:ReneGe
ID: 40606474
Microsoft SQL Server
0
 
LVL 13

Assisted Solution

by:Rizzle
Rizzle earned 100 total points
ID: 40606485
In your scenario I think it would be more safer to log a call directly with Smarttrack to ensure the database migration is done correctly.
0
 
LVL 40

Accepted Solution

by:
footech earned 400 total points
ID: 40606577
I don't know how much guidance they would provide for managing databases.

Typically you'll connect with SQL Management Studio, select the SmarterTrack database, right-click and choose Tasks >  Back Up.
On the new server, you'll install SQL, create a new database named SmarterTrack, then right-click on Databases and choose Restore to restore to your newly created database using the file created previously, and selecting the option to replace the database.  I have a note that I had to add “NT Authority/Network Service” as a login, but that might have been because I was using IIS and that's what my App Pool for the SmarterTrack site was using.

Then run the SmarterTrack install and during the configuration choose your existing database and it will be upgraded.
0
 
LVL 10

Author Comment

by:ReneGe
ID: 40606601
Thanks Footech

I'll try that later and let you know if I have any questions.

Cheers
0
 
LVL 10

Author Comment

by:ReneGe
ID: 40762901
Sorry for taking so long to reply.
Thanks for your assistance.
Cheers
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Multi-threading long-running processes can have a significant increase in overall performance and drastically decrease over time it takes for a process to complete. Unfortunately, not all applications support native multi-threading, some by design a…
Postmortem reporting allow us to examine mistakes in a way that focuses on the situational aspects of a failure’s mechanism and the decision-making process of individuals proximate to the failure. Read our guide on how to handle IT post-mortem repor…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
Suggested Courses

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question