+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Backup Issues in Technical; I am new to SIMS.net and just trying to get my head round it all. I am taking, daily, weekly ...
  1. #1

    Join Date
    Jun 2012
    Location
    coventry, England
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Backup Issues

    I am new to SIMS.net and just trying to get my head round it all. I am taking, daily, weekly and monthly backup of our SIMS system. I decided today I would try and extract last nights backup onto a stand alone PC to make sure the back up works and I can access all the data... Typically it cannot open and windows explorer crashes. Any possible reasons for this? Also the backup is 28G, surely that is too large for a daily backup?? Any feedback would be appreciated!

    Thanks!

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Depends what your backing up. Most important is the SIMS database which the biggest backup size I've seen is 6GB. Was it your LA who set it up?

  3. #3

    Join Date
    Apr 2010
    Posts
    2,169
    Thank Post
    111
    Thanked 192 Times in 159 Posts
    Rep Power
    85
    What version of SQL are you running. Are you backing up the SQL databases?

    Normally you need to backup the SQL databases prior to backing up the standard Sims windows folders

  4. #4

    Join Date
    Jun 2012
    Location
    coventry, England
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Its all set up in backup assist. I have just taken over the role as the guy who looked after it before has left. Im guessing its the whole SIMS database, Iv managed to get into the folder and extract the files and it holds everything(as far as i can see), my only concern is that 28G is just far too large

  5. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    I would image it stops the SQL service, backups the sims.mdf and sims.ldf, as well as the docstorage - which is not uncomment to around 20gb, the sims folder (normally around 1gb). 28GB would be reasonable. It's a pretty standard method of backup - just a bit dated, you should be able to, basically, attach the sims mdf and restore the reset of the files normally - just don't do it on a live system!!

  6. Thanks to matt40k from:

    stokylst (21st June 2012)

  7. #6

    Join Date
    Jun 2012
    Location
    coventry, England
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Ok, well as iv said its all new to me so if that sounds about right to you, then that's all good with me! Cheers

  8. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    can you confirm what is in your backup folder? is it all listed as above?
    if you have an mdf and ldf, tell us the sizes. also, that's not the best way to back it up, you'd be better off with a backup from sql itself which should give you a .bak file. just make sure you don't have multiple things backing up the same data.
    If your db files sizes are too large, there are things you can do to reduce that.
    also, it is probably overkill to be doing a full backup of your docstorage and sims folders, they could be on a separate schedule, doing differential or incremental. this would help reduce your weekly backup size, and time.



SHARE:
+ Post New Thread

Similar Threads

  1. Symantec Backup EXEC CPS Backup issues
    By ranj in forum Enterprise Software
    Replies: 0
    Last Post: 22nd September 2011, 09:21 AM
  2. [SIMS] [Discover] Database backup issue [Solved]
    By Rawns in forum MIS Systems
    Replies: 13
    Last Post: 27th May 2011, 10:22 AM
  3. SharePoint 2010 backup issues
    By faza in forum How do you do....it?
    Replies: 3
    Last Post: 26th May 2011, 10:10 AM
  4. Automatic Backup Issues
    By Duall in forum Windows 7
    Replies: 0
    Last Post: 5th January 2011, 03:43 PM
  5. NAS Backup issues! Pretty urgent...
    By Little-Miss in forum Learning Network Manager
    Replies: 19
    Last Post: 7th June 2010, 10:31 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
  •