MIS Systems Thread, repairing SQL in Technical; Following a rebuild of the OS drive on our SQL server SQL is refusing to start. The data is held ...
-
9th November 2008, 05:33 PM #1 repairing SQL
Following a rebuild of the OS drive on our SQL server SQL is refusing to start. The data is held on another drive and is undamaged (in fact we have restored it to a temp server to keep things running) Can anyone advise me of the best way to rebuild SQL. Should I try running the repair options from the command line or should I just reinstall SQL and recreate the instance. Although not a complete novice I've never had to do much with the SQL apart from install it so any help would be welcome
-
-
IDG Tech News
-
9th November 2008, 06:34 PM #2 Easiest way is on your rebuilt server, set SIMS up from scratch with a blank database. run the upgrades to get it at the same version as your old one. On your old/temp server, run DB attach and detach your SIMS database (same for FMS if you have it on their too). Take the file and run dbattach on your new server to attach your SIMS database. Might have to run it twice if you get errors.
-
SHARE:
Similar Threads
-
By mac_shinobi in forum How do you do....it?
Replies: 5
Last Post: 6th February 2008, 03:42 PM
-
By tom_newton in forum Windows
Replies: 7
Last Post: 23rd January 2008, 06:10 PM
-
By thegrassisgreener in forum Windows
Replies: 3
Last Post: 3rd January 2008, 10:34 AM
-
By tomscaper in forum General Chat
Replies: 55
Last Post: 17th October 2007, 08:38 PM
-
Replies: 8
Last Post: 28th December 2006, 10:30 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
-
Forum Rules