jasonb007 Posted May 14, 2007 Posted May 14, 2007 I want to move our SIMS to a new server as the old server is so old and slow. Also will be replacing my SIMS workstations, so basically, starting from scratch. Can anyone advise how this is done, in particular the SQL side. I don't want to pay the extreme fees of my LEA if I can do it myself - fairly computer literate. Many thanks.
Ric_ Posted May 14, 2007 Posted May 14, 2007 The SIMS and SQL part of the install are like a new installation. You then use the DBATTACH tool to reconnect the database once you have restored it from a backup. I think that Capita (or your local support team) can give you instructions.
nicholab Posted May 15, 2007 Posted May 15, 2007 Will this work if you migrate from MS SQL 2000 to 2005 at the same time?
zag Posted May 16, 2007 Posted May 16, 2007 Its a very easy process, you just need to copy the sql data file to the new server and then use dbattach.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now