+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    21

    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

  2. #2
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    29
    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:
+ Post New Thread

Similar Threads

  1. SQL
    By mac_shinobi in forum How do you do....it?
    Replies: 5
    Last Post: 6th February 2008, 02:42 PM
  2. MS SQL 2005 - Dump SQL
    By tom_newton in forum Windows
    Replies: 7
    Last Post: 23rd January 2008, 05:10 PM
  3. Repairing AD and SAM
    By thegrassisgreener in forum Windows
    Replies: 3
    Last Post: 3rd January 2008, 09:34 AM
  4. Repairing student home machines
    By tomscaper in forum General Chat
    Replies: 55
    Last Post: 17th October 2007, 08:38 PM
  5. Replies: 8
    Last Post: 28th December 2006, 09: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
  •