MIS Systems Thread, move sims sql database to new partition in Technical; Hi folks
After a bit of advice for netman collegue.. He has a crockety old sims server running server 2000 ...
5th July 2010, 03:06 PM #1
move sims sql database to new partition
After a bit of advice for netman collegue.. He has a crockety old sims server running server 2000 and sql 2005 express and no money for new server. He asked how to move the sql 2005 databse onto a new partition on the same server (more disc space).. Has anyone done this and if so can you give me a step by step? or at least point in the right direction
5th July 2010, 03:26 PM #2
You need to be moving/migrating to SQL Express 2008. I don't see it matters what partition it is on as long as you can map a drive.
Take a look a the migration utility, it might solve your/his/her problem.
5th July 2010, 03:35 PM #3
- Rep Power
That OS isn't supported anymore, this could be more trouble than it's worth. Discover will add an extra load to the servers at the end of the year, best advice is to replace it, or upgrade the OS.
6th July 2010, 05:25 PM #4
- Rep Power
Could always detach the database, move it and attach it again... This is done in the SQL management program, of course make backups! I would check with a SIMs user on this too... I don't work with it any more but a database is a database at the end of the day.
6th July 2010, 08:45 PM #5
Migrate to SQL2008 would be best, you need to do it by the end of this year anyway. Not sure how Discover will affect the server performance, workstation without a doubt, server won't be that much (famous last words). Still what's the point of not using SIMS to it's full potential.
Use dbattach, it'll do a backup when it deattaches, plus it keeps Capita happy.
Originally Posted by L3o
By sidewinder in forum Windows
Last Post: 26th April 2010, 03:56 PM
By thesthelensman in forum MIS Systems
Last Post: 13th April 2010, 03:16 PM
By superatticman in forum Windows
Last Post: 4th November 2009, 12:28 PM
By speckytecky in forum MIS Systems
Last Post: 10th October 2009, 10:43 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)