+ Post New Thread
Results 1 to 5 of 5
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 ...
  1. #1
    marekbrad's Avatar
    Join Date
    May 2006
    Location
    Bradford
    Posts
    137
    Thank Post
    25
    Thanked 38 Times in 31 Posts
    Rep Power
    23

    move sims sql database to new partition

    Hi folks

    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

  2. #2

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    173
    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.

  3. #3

    Join Date
    Mar 2010
    Location
    UK
    Posts
    163
    Thank Post
    0
    Thanked 16 Times in 15 Posts
    Rep Power
    16
    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.

  4. #4
    L3o
    L3o is offline
    Unvalidated User
    Join Date
    Jan 2010
    Location
    England
    Posts
    20
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    10
    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.

    Leo

  5. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,382
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    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.


    Quote Originally Posted by L3o View Post
    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.

    Leo
    Use dbattach, it'll do a backup when it deattaches, plus it keeps Capita happy.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 1
    Last Post: 26th April 2010, 02:56 PM
  2. Move to SQL 2008 and backups
    By thesthelensman in forum MIS Systems
    Replies: 2
    Last Post: 13th April 2010, 02:16 PM
  3. Replies: 3
    Last Post: 4th November 2009, 11:28 AM
  4. Migrate SIMS database to SQL 2008
    By speckytecky in forum MIS Systems
    Replies: 8
    Last Post: 10th October 2009, 09:43 AM

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
  •