+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
MIS Systems Thread, SIMS Server Cleanup in Technical; I'm looking to make some space on my SIMS server. Is it ok to delete the old SQL folders (MSSQL.1 ...
  1. #1

    Join Date
    Jan 2008
    Location
    South West
    Posts
    1,842
    Thank Post
    219
    Thanked 271 Times in 219 Posts
    Rep Power
    69

    SIMS Server Cleanup

    I'm looking to make some space on my SIMS server. Is it ok to delete the old SQL folders (MSSQL.1 and MSSQL$SIMS) leaving just the MSSQL10.SIMS2008 folder. Also deleteing some of the older .bak files ok?

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    774
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    This sort of stuff always scares me, not matter how much you're told it's okay. So i would say, yes it should be, but make decent backups before hand.

    Make sure you don't run anything on the older SQL. I take it this is a relic of the move from 2005 to 2008. Part of that process should have been to turn off the old services, which will be a good indication that it's all safe to remove. Rather than delete, you should actually uninstall the old SQL, but that could be scary, in case it removes something shared that the current one requires. I know that i just went for a clean install on a new machine to make sure it was all clear. I noticed that the SQL 2k8 R2 install on Server 2k8 R2, still created a load of files in the Program Files (x86) folder and some of them were required for comms, so it's not as easy as 'delete what looks old'. If it's space you want, and you still have the old SIMS present, you could remove the SIMS mdf / ldf from the old folder, and any other .bak files. Hopefully that will clear some.

    Removing old .bak files is okay, so long as you're happy with what you're left with in case you need access to old data. You can zip others, i normally reduce 3.5GB to 1GB ish, which saves a fair amount.

    I'd look to moving to a new (ideally virtual) server. It's also a good test of what you might do in a disaster recovery situation.

  3. Thanks to vikpaw from:

    chazzy2501 (13th February 2012)

  4. #3
    CAM
    CAM is online now

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Reigate Area, Surrey
    Posts
    4,423
    Thank Post
    884
    Thanked 416 Times in 316 Posts
    Blog Entries
    61
    Rep Power
    328
    Can you get some external storage and move old files instead of deleting them? That way if something does screw up you have a lifeline.

  5. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Quote Originally Posted by chazzy2501 View Post
    I'm looking to make some space on my SIMS server. Is it ok to delete the old SQL folders (MSSQL.1 and MSSQL$SIMS) leaving just the MSSQL10.SIMS2008 folder. Also deleteing some of the older .bak files ok?
    Go into Add\Remove programs, remove Microsoft SQL 2005, when the uninstaller loads, remove the sims2005 instance, leave the workstation components, then repeat for MSDE - if you miss the service manager get this -> SQL 2005 Service Manager

    Once it's uninstalled - remove the mssql.1 and mssql$sims folders.

  6. 2 Thanks to matt40k:

    chazzy2501 (13th February 2012), vikpaw (13th February 2012)

  7. #5

    Join Date
    Jan 2008
    Location
    South West
    Posts
    1,842
    Thank Post
    219
    Thanked 271 Times in 219 Posts
    Rep Power
    69
    I removed the workstation components, (oops) is that a big deal?

    I've got the server snapshotted should I role back?

  8. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Should be ok, check FMS. If it doesn't work install the SQL 2005 Native client then run FMSApplicationSetup.exe again.

    (Can't remember if Native client comes under workstation tools).

  9. #7

    Join Date
    Jan 2008
    Location
    South West
    Posts
    1,842
    Thank Post
    219
    Thanked 271 Times in 219 Posts
    Rep Power
    69
    I just rolled back, the first time I've ever used it properly. I am impressed! Even the icons are back where I left them. It took just 30 seconds

    I'll uninstall again and read the advise fully this time.

  10. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Good test then, it did what it said on the tin

  11. #9

    Join Date
    Jan 2008
    Location
    South West
    Posts
    1,842
    Thank Post
    219
    Thanked 271 Times in 219 Posts
    Rep Power
    69
    BTW what is FMS? I don't think we use it.

  12. #10

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,523
    Thank Post
    527
    Thanked 2,645 Times in 2,047 Posts
    Blog Entries
    24
    Rep Power
    924
    Quote Originally Posted by chazzy2501 View Post
    BTW what is FMS? I don't think we use it.
    FMS is a financial management system by Capita. Its separate to SIMS.net.

  13. #11

    Join Date
    Jan 2008
    Location
    South West
    Posts
    1,842
    Thank Post
    219
    Thanked 271 Times in 219 Posts
    Rep Power
    69
    Couldn't find a MSDE and 2005 is out but I can't delete either of the mssql$sims or the mssql.1 folders. I get an access denied on a opends60.dll

    reboot?

  14. #12

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Microsoft SQL Server Data Engine - Might have SIMS in the name, can't remember, it's been so long since I've last seen it!!

  15. #13

    Join Date
    Jan 2008
    Location
    South West
    Posts
    1,842
    Thank Post
    219
    Thanked 271 Times in 219 Posts
    Rep Power
    69
    wowser, the backup files have grown in the last few years, 200mb ~ 300mb each in 2007 to 2.2gb each in 2011.

    got rid of 5 (leaving 5) new ones and created over 10GB of space. (I was down to my last 600mb) few, Time to install discover.

  16. #14
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    991
    Thank Post
    39
    Thanked 180 Times in 145 Posts
    Rep Power
    97
    Quote Originally Posted by chazzy2501 View Post
    wowser, the backup files have grown in the last few years, 200mb ~ 300mb each in 2007 to 2.2gb each in 2011.

    got rid of 5 (leaving 5) new ones and created over 10GB of space. (I was down to my last 600mb) few, Time to install discover.
    have you got @matt40k's Tidybackup routine running. This will zip the backups down and can be set to delete after a certain time

  17. 2 Thanks to Mcshammer_dj:

    chazzy2501 (13th February 2012), matt40k (13th February 2012)

  18. #15

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    774
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    I thought MSDE was the free pseudo SQL thingy that came with Office Pro, or something like that. OR is that just what SQL Express installs as.
    I'm really hoping the backups you're talking of are just the ones that SIMS does when you upgrade. Don't really need much management. Hopefully you have daily backups going somewhere safe, like a shared drive that then gets dumped to tape. That's where it's really useful to have TidyBackups.



SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [SIMS] SIMS Server Hardware for a large School
    By Johan in forum MIS Systems
    Replies: 32
    Last Post: 26th June 2011, 12:04 PM
  2. [SIMS] SIMs Server Migration - Documents Server Issue
    By Andynonymous in forum MIS Systems
    Replies: 34
    Last Post: 29th May 2011, 08:16 AM
  3. [SIMS] New SIMS Server RAID 5 or 10
    By fiza in forum MIS Systems
    Replies: 10
    Last Post: 15th May 2011, 04:12 PM
  4. [SIMS] SIMS Server query
    By Cache in forum MIS Systems
    Replies: 8
    Last Post: 23rd January 2011, 03:30 PM
  5. [SIMS] SIMS server reducancy
    By Newton in forum MIS Systems
    Replies: 9
    Last Post: 13th January 2011, 10:08 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
  •