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 ...
4th April 2008, 11:31 AM #1
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 11:38 AM.
4th April 2008, 12:01 PM #2
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
4th April 2008, 12:17 PM #3
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.
Originally Posted by ittech
4th April 2008, 03:22 PM #4
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.
8th April 2008, 11:39 AM #5
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).
By interele in forum MIS Systems
Last Post: 30th January 2008, 05:49 PM
By timbo343 in forum Windows
Last Post: 11th January 2008, 08:08 PM
By nicholab in forum MIS Systems
Last Post: 9th November 2007, 07:42 PM
By Uraken in forum MIS Systems
Last Post: 6th March 2007, 01:25 PM
By SimAda00 in forum MIS Systems
Last Post: 10th January 2007, 12:27 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)