+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, Old SQL DB in Technical; So a while ago I upgraded my SQL server to 2008 from 2005 however as part of the process i ...
  1. #1

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    1,675
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    45

    Old SQL DB

    So a while ago I upgraded my SQL server to 2008 from 2005 however as part of the process i left the old SQL in place.

    What's the easiest way to stop it running? Can I just stop and disable the instanaces in services MMC?

    SQL Server (SIMS2005)
    SQL Server Agent (2005)
    SQL Server FullTexstSearch (2005)

    Ideally i want to do cause the minumum disruption to the 2008 DB.

  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
    SIMS will not now be using 2005. You can safely disable in Services or uninstall. I can't speak for anything else that might be using it.

    Disable, see how it goes then uninstall after a reasonable period.

  3. #3

    Join Date
    Jan 2007
    Posts
    100
    Thank Post
    0
    Thanked 34 Times in 23 Posts
    Rep Power
    21
    .... and completely delete the old database for security (I like Eraser for this)

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,376
    Thank Post
    368
    Thanked 636 Times in 518 Posts
    Rep Power
    158
    Quote Originally Posted by Greg View Post
    .... and completely delete the old database for security (I like Eraser for this)
    Don't tend to bother, data is still on the server but in a new database so no real benift only problems - cause they have to access the disc at the raw level can sometimes cause problems. We erase the discs when the server gets recycled anyway, like everyone does

SHARE:
+ Post New Thread

Similar Threads

  1. Vmdk's or iscsi For SQL db and exchange db
    By ful56_uk in forum How do you do....it?
    Replies: 4
    Last Post: 26th April 2011, 09:30 AM
  2. SIMS <--> SQL DB relationship schema
    By Gdn in forum MIS Systems
    Replies: 38
    Last Post: 7th September 2010, 07:30 PM
  3. SQL Express Db and shadow copies
    By cookie_monster in forum Windows
    Replies: 7
    Last Post: 21st August 2008, 01:58 PM
  4. Web based questionnaire to Access/SQL express dB
    By joe90bass in forum How do you do....it?
    Replies: 4
    Last Post: 23rd June 2008, 02:46 PM
  5. Old SIMS SQL Services
    By enjay in forum MIS Systems
    Replies: 5
    Last Post: 27th February 2008, 01:55 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
  •