+ Post New Thread
Page 2 of 7 FirstFirst 123456 ... LastLast
Results 16 to 30 of 92
MIS Systems Thread, How much disk space do you have for SIMS.net? in Technical; I'm really, really going to show my lack of knowledge here and ask if I have to run that from ...
  1. #16

    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?

    I'm really, really going to show my lack of knowledge here and ask if I have to run that from the command line on our SQL server?

    (sorry!)

  2. #17
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,047
    Thank Post
    22
    Thanked 178 Times in 124 Posts
    Rep Power
    53

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

    Just copied this from supportnet:

    Dbattach can be used at a dos prompt or included in a batch file.
    Path to the N:\Program Files\Microsoft SQL Server\MSSQL$SIMS\binn folder where N is the drive SQL is installed to. Dbattach.exe is in this folder.
    The command would then be dbattach <parameters> as specified below:
    Parameters :
    /SERVER="ABCD" - ABCD is the name of the SQL Server to upgrade
    /DATABASE="ABCD" - ABCD is the name of the SIMS database on the server to upgrade.

    Note that if not supplied the settings from the Connect.INI in the
    current directory will be used.

    /USER="ABCD" - ABCD is the user name: SQL User for installations and utilities
    SIMS User name when used to backup.
    /PASSWORD="ABCD" - ABCD is the password for the user given

    /AUTO - If supplied the user interface will not wait for the user to press the Install button.
    /NOBACKUP - If supplied no backup will be taken of the database, and if a problem occurs, no
    restore will be performed
    /BACKUP - Create a SIMS backup - also requires user, password, database, server and auto

  3. #18
    Snuffkins's Avatar
    Join Date
    Jan 2006
    Posts
    207
    Thank Post
    14
    Thanked 8 Times in 8 Posts
    Rep Power
    23

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

    Run it on the server you have sims installed on.

  4. #19

    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?

    You absolute gems. I'm assuming that this is safe to do with users on the system??

  5. #20
    Snuffkins's Avatar
    Join Date
    Jan 2006
    Posts
    207
    Thank Post
    14
    Thanked 8 Times in 8 Posts
    Rep Power
    23

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

    I'm pretty sure you can run it ok whether there are users in or not. But it might be worth getting them out anyway. Takes about 5-10 minutes to run normally. Saying that i run it with them logged in so i hope it's safe lol.

  6. #21
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,047
    Thank Post
    22
    Thanked 178 Times in 124 Posts
    Rep Power
    53

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

    Just to be safe and speed things up, I'd get the users out of SIMS first.

  7. #22

    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?

    In that case, I'll run it tonight before I go home. The chances of getting any of this lot out of SIMS now (given that they couldn't log in until -shock- 8.30am) is nigh on impossible...

    One thing - what does it actually *do*? What's the purpose of a DBAttach?

    Many thanks.. where would I be without this place? In a gibbering heap on the floor on hold at Capita, methinks...

  8. #23
    Snuffkins's Avatar
    Join Date
    Jan 2006
    Posts
    207
    Thank Post
    14
    Thanked 8 Times in 8 Posts
    Rep Power
    23

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

    I'd guess it attaches to the database to do the backup? But that would just be me making things up again , i'm good at that.

    You have support direct from Capita . I'm still confused how such a small mdf can produce such a large lock file, i mean something bad must have happened to cause that... Unless your network manager hasn't done a backup or an update since .net was installed, which by the sound of him may just be possible lol. Still don't know how it could get that big.

  9. #24

    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?

    Quote Originally Posted by Snuffkins
    You have support direct from Capita
    For all the use it was this morning, yes, we do...

    I thought that was what it did.. attaches, backs up and resets the lock file... hopefully!

    I'm confused as well, a lock file should only be the size (or slightly bigger?) of it's main db file, I'm sure..

    Shall I ring Capita and tell them that I have a 800mb mdf file and a 110Gb lock file and see what they say, just for a laugh?!

  10. #25

    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?

    Sorry for the double post folks. My net connection's playing up so I was posting in the dark ops:

    Quote Originally Posted by indiegirl
    The guy I spoke to seemed to assume we'd had the "february disk"! I thought that it was all done via Solus as well...

    Just found the culprit - in the following folder:

    Program Files\Microsoft SQL Server\MSSQL$SIMS\Data

    I have a SIMS.ldf file which is 110gb 8O
    110gb ldf looks like the log file hasn't bee truncated in a looOOOng time.
    Has the NM ever backed up SIMS.net

    Quote Originally Posted by steve
    dbattach.exe /user:"username" /password:"password" /backup /SERVER:"YOURSIMSSERVER" /DATABASE:"sims" /AUTO

    That will reduce the size of the ldf (username and password of a sysman)

    But you will need space for a backup - about 300Mb
    Only 300Mb??? I think it will be a bit more than that because the SQL server will dump a bak file of least 812mb into the free space. It could be a lot more considering the size of the ldf.

    If your backup folder is in a different partition then you might not have a problem.

  11. #26
    Snuffkins's Avatar
    Join Date
    Jan 2006
    Posts
    207
    Thank Post
    14
    Thanked 8 Times in 8 Posts
    Rep Power
    23

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

    Oh please, i'd love too know how long they say ermmmm for, lol. My .ldf is 1.2kb with a 1 gig database. I do run the sql backup on a nightly basis though.

  12. #27
    Snuffkins's Avatar
    Join Date
    Jan 2006
    Posts
    207
    Thank Post
    14
    Thanked 8 Times in 8 Posts
    Rep Power
    23

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

    Quote Originally Posted by NetworkGeezer
    110gb ldf looks like the log file hasn't bee truncated in a looOOOng time.
    Has the NM ever backed up SIMS.net
    I was thinking that, but when you do an update it automatically does a backup. Do you know what version of sim.net it is? It should be 7.70.
    Maybe he hasn't updated or backed up ever, lol. Actually that wouldn't
    be funny.

  13. #28

    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 indiegirl
    Quote Originally Posted by Snuffkins
    You have support direct from Capita
    I'm confused as well, a lock file should only be the size (or slightly bigger?) of it's main db file, I'm sure..

    Shall I ring Capita and tell them that I have a 800mb mdf file and a 110Gb lock file and see what they say, just for a laugh?!
    I hate to be a pedant especially as I make so many mystakes myself but it's log file not lock file. The ldf stores any transactions which haven't stored in the main ldf file.

  14. #29

    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 Snuffkins
    I was thinking that, but when you do an update it automatically does a backup. Do you know what version of sim.net it is? It should be 7.70.
    Maybe he hasn't updated or backed up ever, lol. Actually that wouldn't
    be funny.
    It would have to be 7.62 at the very least unless the NM got a note from his mum to excuse hime from doing PLASC ...sorry School Census

  15. #30

    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?

    NetworkGeezer: pedantic, but excused. My error! I think my brain was working on the age-old Access DBs and their 'lock' files ops:

    Let's see... I am running...... 7.62, build 8, DB build 3.61.198

    I couldn't honestly tell you if the NM has ever backed SIMS.net up... I'm very, very worried now...



SHARE:
+ Post New Thread
Page 2 of 7 FirstFirst 123456 ... 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, 06: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, 10:45 AM
  3. Server 2003 strange disk space issue.
    By starscream in forum Windows
    Replies: 12
    Last Post: 3rd August 2007, 01:07 AM
  4. server disk space
    By david12345 in forum Hardware
    Replies: 8
    Last Post: 24th July 2007, 05: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
  •