Jump to content

Recommended Posts

Posted
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
Posted
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.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×
×
  • Create New...