+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 20
MIS Systems Thread, SIMS backup on Server 2008 (not R2)... in Technical; Hi all, Not sure if I should post here or the in the server forum, but here goes... Over the ...
  1. #1
    Koldov's Avatar
    Join Date
    May 2011
    Location
    Bedfordshire
    Posts
    522
    Thank Post
    102
    Thanked 54 Times in 47 Posts
    Rep Power
    39

    SIMS backup on Server 2008 (not R2)...

    Hi all,

    Not sure if I should post here or the in the server forum, but here goes...

    Over the summer holiday I have succesfully (I think) moved SIMS onto a 2008 server (many thanks to EDUGEEK) from our old and soon to be not supported 2003 server.

    Unfortunately, I am now having to re-think our backup schedule!

    We don't have any 3rd party software apart from very old copies of Cobian (running on the 2003 server) and Veritas BackupExec 9 (which I found in the old technicians cupboard unopened!) and I believe that only works up to Server 2003 OS.

    I need a solid plan for backups before we get back into it (hopefully without buying any new 3rd party software as I am on my own with no budget for the next few weeks), however I know there are limitations to Server 2008 backup.

    Also I believe that a live SQL database like SIMS may not be backed up in a normal server backup without services being stopped and/or databases being detached.

    Does anybody run a system like this?

    Thanks in advance.

    Kol.

  2. #2

    Join Date
    Oct 2005
    Posts
    848
    Thank Post
    51
    Thanked 115 Times in 105 Posts
    Rep Power
    74
    Windows Server Backup will be absolutely fine for this - it uses VSS so you'll get a "good" SQL backup.

    Just make sure that your backup schedules are regular enough and you have enough space on your backup target.
    I'd also recommend testing your backups too! - no point having them if they don't work!

  3. #3

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,169
    Thank Post
    430
    Thanked 314 Times in 265 Posts
    Rep Power
    153
    Use DBAttach to detach the SIMS Database and then backup the db files. In my last school we had a script that would do this in the middle of the night and reattach afterwards. I am sure I got it from someone on Edugeek.

  4. #4

    Join Date
    Oct 2005
    Posts
    848
    Thank Post
    51
    Thanked 115 Times in 105 Posts
    Rep Power
    74
    One more thing to add - why not talk to Capita and see what they recommend/support?

  5. #5

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,169
    Thank Post
    430
    Thanked 314 Times in 265 Posts
    Rep Power
    153
    Here it is : DBAttach Script

  6. #6
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    941
    Thank Post
    35
    Thanked 164 Times in 132 Posts
    Rep Power
    94
    Yuo don't need to detach the database using dbattach. simply use the built in backup process via a command line script. I also use the exellent sims tidy routine created by @matt40k to keep the size down

  7. #7

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,169
    Thank Post
    430
    Thanked 314 Times in 265 Posts
    Rep Power
    153
    Quote Originally Posted by Mcshammer_dj View Post
    Yuo don't need to detach the database using dbattach. simply use the built in backup process via a command line script. I also use the exellent sims tidy routine created by @matt40k to keep the size down
    Ah Things must have changed (Im not responsible for SIMS in my new place). I got the original script from your kind self!

  8. #8
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    941
    Thank Post
    35
    Thanked 164 Times in 132 Posts
    Rep Power
    94
    yeah that script edited will still work fine and if you follow @fiza 's link then you can get the copy of the the tidybackups

  9. #9
    Koldov's Avatar
    Join Date
    May 2011
    Location
    Bedfordshire
    Posts
    522
    Thank Post
    102
    Thanked 54 Times in 47 Posts
    Rep Power
    39
    Quote Originally Posted by Mcshammer_dj View Post
    Yuo don't need to detach the database using dbattach. simply use the built in backup process via a command line script. I also use the exellent sims tidy routine created by @matt40k to keep the size down
    Thanks for this, actually dbattach, scripts and scheduled tasks were all used together somehow on the old 2003 server (then Cobian copied it all onto a USB drive), but I didn't write or configure any of it, so I don't really understand how it all came together.

    Unfortunately, I can't read the words 'simple' and 'command line script' in the same sentence without a look lol. I know I am limited with Server 2008 as to my backup location and type of backup, but can I take it from these posts that I can just set the inbuilt server backup utility to backup the relevant folders (SIMS and FMS databases) to a local USB drive that I can swap out everyday?

    Kol.
    Last edited by Koldov; 20th August 2013 at 01:58 PM.

  10. #10
    Koldov's Avatar
    Join Date
    May 2011
    Location
    Bedfordshire
    Posts
    522
    Thank Post
    102
    Thanked 54 Times in 47 Posts
    Rep Power
    39
    Quote Originally Posted by pantscat View Post
    One more thing to add - why not talk to Capita and see what they recommend/support?
    Last time I talked to Capita, they were horrified I was using USB drives to backup to and not tape (isn't support for tape being dropped for new Server OS'?)...

    Worth a try I guess.

    Kol.

  11. #11
    Koldov's Avatar
    Join Date
    May 2011
    Location
    Bedfordshire
    Posts
    522
    Thank Post
    102
    Thanked 54 Times in 47 Posts
    Rep Power
    39
    However, reading that other thread, this worried me:

    I've also got a tool somewhere to transfer the passwords from the MASTER database to the actual database (ie SIMS), so when you backup the SIMS database, it includes all the passwords.

    As I've moved the SIMS and FMS databases, am I going to have trouble with people logging in now if I didn't move the passwords too?

    Kol.

  12. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    Use teh built-in backup, with SQL Management studio. You can setup a maintenance plan and get it to email you when done. then use Matt's tidy backups to keep the store in order.
    No need to stop services or detach data.
    That's if you have full SQL, if not, then there is a third party option i came across on a google search the other day, or script it.

  13. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,432
    Thank Post
    368
    Thanked 645 Times in 527 Posts
    Rep Power
    159
    Quote Originally Posted by Koldov View Post
    I've also got a tool somewhere to transfer the passwords from the MASTER database to the actual database (ie SIMS), so when you backup the SIMS database, it includes all the passwords.
    You'll be pleased to know that SQL2012 allows you to store the user\pass in the database rather then in the local MASTER db... Assuming Capita enables it
    Until then - SIMS Transfer Tools - https://simstransferlogins.codeplex.com/

    And a bit of a plug...

    TidyBackups - TidyBackups - Home

  14. #14
    Koldov's Avatar
    Join Date
    May 2011
    Location
    Bedfordshire
    Posts
    522
    Thank Post
    102
    Thanked 54 Times in 47 Posts
    Rep Power
    39
    Aaaaaaagh! I wasn't a fan before, but this is driving me nuts!

    Anyway, my Business Manager has just popped in and I asked him to try to log in to SIMS. He logged on fine, so what am I missing here?

    Below is a screenie of my MSSQL DATA folder contents:

    Database.jpg

    Does that look about right? I don't remember copying the 'Master Database' and I've looked through the thread that helped me and I didn't see it mentioned, so I doubt I did... As far as I can remember I just used dbattach to put the SIMS and FMS databases on.

    Kol.
    Last edited by Koldov; 21st August 2013 at 01:22 PM.

  15. #15

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,255
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Quote Originally Posted by Koldov View Post
    Aaaaaaagh! I wasn't a fan before, but this is driving me nuts!

    Database.jpg
    Sorry not had chance to read the thread... but your Sims.ldf looks rather large and needs shrinking.

  16. Thanks to creese from:

    vikpaw (21st August 2013)

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

Similar Threads

  1. Replies: 1
    Last Post: 18th April 2012, 12:59 PM
  2. SIMS FMS RemoteApps on Server 2008 R2
    By spc-rocket in forum Windows Server 2008 R2
    Replies: 6
    Last Post: 14th August 2011, 05:03 PM
  3. Moodle backup on server 2008
    By grahamd22 in forum Virtual Learning Platforms
    Replies: 6
    Last Post: 1st February 2011, 04:33 PM
  4. SIMS will not load on Server 2008 64bit
    By KWestos in forum MIS Systems
    Replies: 15
    Last Post: 8th October 2009, 08:50 PM
  5. NT Backup on Server 2008
    By FN-GM in forum Windows Server 2008
    Replies: 15
    Last Post: 12th May 2009, 02:49 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
  •