MIS Systems Thread, Offline SIMS? in Technical; Sorry Meant to explain, these USBs contain 2 in our safe (1 to update which the other is in there) ...
25th March 2013, 09:33 PM #16
Sorry Meant to explain, these USBs contain 2 in our safe (1 to update which the other is in there) and 1 in our "safety" schools safe, sealed in an envelope with our headteachers signature
25th March 2013, 09:34 PM #17
25th March 2013, 09:36 PM #18
@PhilNeal thank you for pointing it our before another place has a couple of usbs sitting in a draw at home.
I should explain a lot more before clicking post.
26th March 2013, 06:45 AM #19
I've got a couple of mods to suggest for you @BKGarry
I don't think you need to copy the mdf / ldf. The .bak file should be plenty good and it will negate the need to stop and start services, which means it's less likely to fail when you least expect it.
Also, if you don't specify a filename at backup time will it autoname it with a date? Or is it only SQL backups that do that. I like this feature and keep as many as possible.
Otherwise, i've used something like this to create a folder or to append to the filename for other similar scripts, which would be the easiest thing to do here:
the format might need tweaking depending on your datetime settings and preference.
It's probably overkill to store more than one recent and a backup, but if you did want to, some snazzy tool like TidyBackups - Home might be worth setting up to keep it tidy.
Thanks to vikpaw from:
BKGarry (26th March 2013)
26th March 2013, 11:30 AM #20
Can I ask why?
Originally Posted by PhilNeal
I use an encrypted container on my thumb drive to move my excel files to/from school daily, some of which are chock full of student data.
I'd be well impressed if someone could get into my encrypted file.
26th March 2013, 02:25 PM #21
Thank you @vikpaw I only do 2 days worth for the restore on the laptop, our standard backup schedule does atleast 30 days worth of SQL backups for SIMs and then there are even more on archived tapes.
By Gatt in forum MIS Systems
Last Post: 17th October 2013, 10:49 AM
By jumpinjamez in forum MIS Systems
Last Post: 17th April 2012, 07:35 PM
By Grommit in forum MIS Systems
Last Post: 18th January 2012, 01:30 PM
By FragglePete in forum MIS Systems
Last Post: 9th October 2008, 12:12 PM
By Jonsi in forum MIS Systems
Last Post: 3rd October 2008, 09:06 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)