+ Post New Thread
Page 6 of 7 FirstFirst ... 234567 LastLast
Results 76 to 90 of 92
MIS Systems Thread, How much disk space do you have for SIMS.net? in Technical; Do you sometimes think the world is against you though indiegirl? If even your NM is an incompetent what chance ...
  1. #76
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,211
    Thank Post
    226
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Re: How much disk space do you have for SIMS.net?

    Do you sometimes think the world is against you though indiegirl? If even your NM is an incompetent what chance have you with the teaching staff?

    Wes

  2. #77
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,211
    Thank Post
    226
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Re: How much disk space do you have for SIMS.net?

    Windows Scripting Host is not running?

    No comment!

    Wes

  3. #78

    Join Date
    Oct 2005
    Location
    Anywhere but in a school ;o)
    Posts
    522
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: How much disk space do you have for SIMS.net?

    It pays to grumble... here's the solution to shrinking the ldf file:

    Query Analyzer time (best done with the sa login and password, but guess what I don't have??? - so done with Administrator):

    on the SIMS database, execute the following query:

    backup log sims with no_log
    dbcc shrinkdatabase (sims, 0)

    105Gb free, ldf file now 1mb.

    Backup time!!!!!

  4. #79
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,211
    Thank Post
    226
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Re: How much disk space do you have for SIMS.net?

    Removed!!!!

  5. #80
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,483
    Thank Post
    10
    Thanked 502 Times in 442 Posts
    Rep Power
    114

    Re: How much disk space do you have for SIMS.net?

    Good to hear!

    I was going to suggest that, as I've just been reading up on it, I only know general sql and not the more technical stuff. I didn't know if you had the query analyser as I'm not sure if it comes with msde (we were all given msde - although our school changed to full sql). As the normal sims backup truncates too, we just have to hope the full backups we get are good, although I see no practical way for a school to look after a full transcation log and its backup sensibly.

  6. #81
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,483
    Thank Post
    10
    Thanked 502 Times in 442 Posts
    Rep Power
    114

    Re: How much disk space do you have for SIMS.net?

    More info here http://support.microsoft.com/kb/873235/EN-US/

    Oh, and you might not want to broadcast the SA password wesley. I would have done a drop database sims; by now if I was a student :P

  7. #82
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,483
    Thank Post
    10
    Thanked 502 Times in 442 Posts
    Rep Power
    114

    Re: How much disk space do you have for SIMS.net?

    I've just checked, its not the SA password round here, although I did work out what ours is.

  8. #83

    Join Date
    Oct 2005
    Location
    Anywhere but in a school ;o)
    Posts
    522
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: How much disk space do you have for SIMS.net?

    it's not that password here either. I know this as NM changed it in the summer, and then spent 1/2 a day phoning the dude who he hauled in to set the system up to try and find out what it was.

    The world against me? Nah, I'm just extremely unlucky in my choice of jobs (the pattern so far is one good, one bad, one good, one bad...) things can only get better :-D

  9. #84
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,211
    Thank Post
    226
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Re: How much disk space do you have for SIMS.net?

    Okay, I'm having such fun being wrong

    Yeah wasn't thinking there I've deleted that now!


    Wes

  10. #85

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: How much disk space do you have for SIMS.net?

    Quote Originally Posted by DMcCoy
    I've just checked, its not the SA password round here, although I did work out what ours is.
    Yes, I don't remember there being a preset sa password when installing SQL Server on the SIMS server.

    You're normally given a choice.

  11. #86
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,211
    Thank Post
    226
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Re: How much disk space do you have for SIMS.net?

    I thought you were supposed to follow certain guidelines for this but I could be wrong (Won't be the first time today!)

    Wes

  12. #87

    Join Date
    Oct 2005
    Location
    Anywhere but in a school ;o)
    Posts
    522
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: How much disk space do you have for SIMS.net?

    Listen guys, thank you so much for all of your help (and replies, and views, and support) today. It's days like this that I am grateful for people like you out there with the spare time to assist. Your help has been priceless today.

    I can only take from this that I've learned a lot (but still have so much more to go!) on the SIMS front... but I think we can all safely say that I'm a step or two ahead of the NM now...

    Cheers - have a good evening.

  13. #88
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,483
    Thank Post
    10
    Thanked 502 Times in 442 Posts
    Rep Power
    114

    Re: How much disk space do you have for SIMS.net?

    I'm not following any guidelines from capita tyvm

    I know it, the lea support team knows it, and its in the magic black book. This is all that should be needed. Besides you can change it as administrator if it in mixed mode afaik

  14. #89

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: How much disk space do you have for SIMS.net?

    Quote Originally Posted by wesleyw
    I thought you were supposed to follow certain guidelines for this but I could be wrong (Won't be the first time today!)

    Wes
    No one body told me. That would be like Microsoft telling everyone to use a standard domain admin password.

  15. #90
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,211
    Thank Post
    226
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Re: How much disk space do you have for SIMS.net?

    Well as long as there's a way back from the abbyss I think that'll be fine. Thanks though DMcCoy and NetworkGeezer I've actually learnt somethings about SIMS today which will definitely be very useful in the future! Excellent!

    Wes

SHARE:
+ Post New Thread
Page 6 of 7 FirstFirst ... 234567 LastLast

Similar Threads

  1. Script Need to check disk space on remote servers
    By screwuphead in forum Scripts
    Replies: 8
    Last Post: 26th November 2007, 05:28 PM
  2. Help my server thinks its run out of disk space.
    By pickman in forum Wireless Networks
    Replies: 7
    Last Post: 12th October 2007, 09:45 AM
  3. Server 2003 strange disk space issue.
    By starscream in forum Windows
    Replies: 12
    Last Post: 3rd August 2007, 12:07 AM
  4. server disk space
    By david12345 in forum Hardware
    Replies: 8
    Last Post: 24th July 2007, 04:28 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
  •