Call Savance Workplace Call Us: (248) 478-2555

Support Suite

User Login



 

Main

Knowledgebase: Technical
How do I restore an EIOBoard backup database?
Posted by Savance on 17 December 2010 08:44 AM

To restore an EIOBoard backup database, the first thing you want to do is to locate your database backup file (by default is SolutionSavant.bak) in the backup location that you specified during login.  If you don’t know where this is, follow these instructions, “How to Find my Backup Location".

  1. Stop IIS to prevent the database from being locked (Click Start, Run, type “cmd” and hit Enter, then type “iisreset /stop” at the command prompt).
  2. Install Microsoft SQL Management Studio Express from http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en and install it.
  3. Launch SQL Management Studio Express and Login to the server using COMPUTERNAME\EIOBOARD (replacing COMPUTERNAME with the actual computer name), then use Windows Authentication (which does not require you to enter a username or password and instead uses your Windows Login) or choose SQL authentication and specify the EIOBoard default of "sa" for the username and "EBwebs@vant" as the password.
  4. Then follow these directions to restore the database:
    http://msdn.microsoft.com/en-us/library/ms177429.aspx
  5. Restart IIS (Click Start, Run, type “cmd” and hit Enter, then type “iisreset /start" at the command prompt)