+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 23 of 23
MIS Systems Thread, Sims.net Server2008 64Bit in Technical; Shrink the log is a good place to start and tidy up the database, if you have been using it ...
  1. #16

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    13
    Shrink the log is a good place to start and tidy up the database, if you have been using it along time think how much dead wood you have.

  2. #17
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,043
    Thank Post
    22
    Thanked 177 Times in 123 Posts
    Rep Power
    52
    We do a nightly backup that shrinks the ldf - its the mdf that's grown.

    SIMS is used here very intensively - all lesson registers, assessment, profiles, personnel, you name it we use it, and use it a lot.

  3. #18
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,150
    Thank Post
    182
    Thanked 50 Times in 43 Posts
    Rep Power
    25
    Quote Originally Posted by Steve_T View Post
    Shrink the log is a good place to start and tidy up the database, if you have been using it along time think how much dead wood you have.
    How do you shrink the log?

  4. #19
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,043
    Thank Post
    22
    Thanked 177 Times in 123 Posts
    Rep Power
    52
    From Supportnet:

    1) Create a new user in SIMS .net, making them a member of the System Manager group and also a trusted SIMS .net user

    2) Create a batch file containing the following

    DBATTACH /SERVER="server\sims" /DATABASE="SIMS" /BACKUP /AUTO /TRUSTED

    if ERRORLEVEL 1 GOTO :ERROR
    GOTO :END
    :ERROR
    ECHO NOT WORKING
    :END

    3) Create a scheduled task to run the batch file the with the users credentials as in 1)

    The task will then run whether the user is logged in or not


    A Scheduled Task is set up via:-
    Start | Control Panel | Scheduled Tasks | Add Schedule Tasks
    Follow the on screen instructions and browse to the batch file that will run the backup

  5. #20

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    13
    As Steve said above or user SQL Management Studio it wont bite. A huge amount problems can be resolved with a few clicks using Management studio. See attachment.
    Attached Images Attached Images

  6. #21
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30
    Quote Originally Posted by steve View Post
    From Supportnet:

    1) Create a new user in SIMS .net, making them a member of the System Manager group and also a trusted SIMS .net user

    2) Create a batch file containing the following

    DBATTACH /SERVER="server\sims" /DATABASE="SIMS" /BACKUP /AUTO /TRUSTED

    if ERRORLEVEL 1 GOTO :ERROR
    GOTO :END
    :ERROR
    ECHO NOT WORKING
    :END

    3) Create a scheduled task to run the batch file the with the users credentials as in 1)

    The task will then run whether the user is logged in or not


    A Scheduled Task is set up via:-
    Start | Control Panel | Scheduled Tasks | Add Schedule Tasks
    Follow the on screen instructions and browse to the batch file that will run the backup
    Is there anyway to get dbattach to automatically detach the database so you can backup the actual .mdf and .ldf? I can think of a few situations where the .bak scripts would be pretty useless in the event of a restore...

  7. #22

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Quote Originally Posted by Oops_my_bad View Post
    Is there anyway to get dbattach to automatically detach the database so you can backup the actual .mdf and .ldf? I can think of a few situations where the .bak scripts would be pretty useless in the event of a restore...
    Just top the SQL service (net stop mssql$sims2005) copy the .mdf/.ldf then start MSSQL (net start mssql$sims2005)

    Yet to hear of a case where the .bak can't be used to be honest.

    FYI: if you do copy the .mdf etc, take a copy of master.

    Whilst on the subject, if you use FMS, it MUST BE BACKED UP AT THE SAME TIME AND BOTH RESTORED FROM THE SAME TIME.

    caps off
    Last edited by matt40k; 30th April 2009 at 10:37 PM.

  8. Thanks to matt40k from:

    Oops_my_bad (1st May 2009)

  9. #23

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    13
    MUST BE BACKED UP AT THE SAME TIME AND BOTH RESTORED FROM THE SAME TIME.
    Make sure you do take note of the above or you will encounter problems regarding Unsynchronised databases.

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Replies: 23
    Last Post: 3rd October 2009, 05:44 PM
  2. Installing SIMS.net on Windows Server 2008 64bit
    By mattstevenson2005 in forum MIS Systems
    Replies: 10
    Last Post: 7th March 2009, 08:08 PM
  3. Sims on W2K3 64bit
    By skunk in forum MIS Systems
    Replies: 2
    Last Post: 18th August 2008, 10:35 AM
  4. SIMS and SQL2005 on a 64bit OS
    By timbo343 in forum Windows
    Replies: 2
    Last Post: 8th May 2008, 08:52 AM
  5. sims 64bit
    By russdev in forum MIS Systems
    Replies: 8
    Last Post: 19th January 2008, 11:07 AM

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
  •