+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Restore sims database in Technical; Should be an easy one but I wanted to check. How do I restore a Sims database? I have the ...
  1. #1
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,530
    Thank Post
    815
    Thanked 380 Times in 317 Posts
    Blog Entries
    12
    Rep Power
    80

    Restore sims database

    Should be an easy one but I wanted to check.

    How do I restore a Sims database? I have the zip file it took as a backup and I am logged into dbattach.

    Question is what do I put in the database name field and what do I attach?

    Neither .bak or the .zip show up when I open the attach [...] dialogue box.
    Last edited by zag; 4th April 2008 at 10:38 AM.

  2. #2
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,530
    Thank Post
    815
    Thanked 380 Times in 317 Posts
    Blog Entries
    12
    Rep Power
    80
    Answering my own question....

    You need to run dbattach /RESTOREUI from the sqlserver binn folder.

    This brings up an extra box where you can restore the .bak file.

    One thing I noticed was the zip files seemed to be corrupted but installing winrar I managed to unzip it with no problems.

    Sims is up again, wahoo, now I can go to the pub

  3. #3
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,386
    Thank Post
    10
    Thanked 483 Times in 423 Posts
    Rep Power
    110
    Quote Originally Posted by ittech View Post
    Answering my own question....

    You need to run dbattach /RESTOREUI from the sqlserver binn folder.

    This brings up an extra box where you can restore the .bak file.

    One thing I noticed was the zip files seemed to be corrupted but installing winrar I managed to unzip it with no problems.

    Sims is up again, wahoo, now I can go to the pub
    windows doesn't like the zip files containing the full path, including drive letter and blocks them. I find 7zip will open them fine too.

  4. #4
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    432
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    30
    Look at the thread on Backing up SIMS posted a few days ago as well.

    This details some of the problems you may come accross if you are only using system manager for the initial backup.

    Best to use DBAttach to backup as well as restore.


  5. #5
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,530
    Thank Post
    815
    Thanked 380 Times in 317 Posts
    Blog Entries
    12
    Rep Power
    80
    I actually use backupexec's sql agent to back it up but in this case wanted to test the backup made by sims when it upgrades (as that's where most of the problems seem to come from).

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS database engine
    By interele in forum MIS Systems
    Replies: 11
    Last Post: 30th January 2008, 04:49 PM
  2. DHCP restore database
    By timbo343 in forum Windows
    Replies: 3
    Last Post: 11th January 2008, 07:08 PM
  3. Can I restore a SIMS server to a VM
    By nicholab in forum MIS Systems
    Replies: 11
    Last Post: 9th November 2007, 06:42 PM
  4. sims restore
    By Uraken in forum MIS Systems
    Replies: 7
    Last Post: 6th March 2007, 12:25 PM
  5. New Sims Database
    By SimAda00 in forum MIS Systems
    Replies: 0
    Last Post: 9th January 2007, 11:27 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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