+ 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,679
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    46

    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,258
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    183
    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
    101
    Thank Post
    0
    Thanked 35 Times in 24 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,485
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    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, 10:30 AM
  2. SIMS <--> SQL DB relationship schema
    By Gdn in forum MIS Systems
    Replies: 38
    Last Post: 7th September 2010, 08:30 PM
  3. SQL Express Db and shadow copies
    By cookie_monster in forum Windows
    Replies: 7
    Last Post: 21st August 2008, 02: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, 03:46 PM
  5. Old SIMS SQL Services
    By enjay in forum MIS Systems
    Replies: 5
    Last Post: 27th February 2008, 02: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
  •