suzy_reid

yes - there is some movement of them between our different regional centres. The databases are sometimes updated by a member of staff prior to a training course - and then distributed round 5 regional centres - so takes a while. i thought there may be a clever way to archive/shrink....

thanks for the replies - it isnt that big for a School database but we wanted to get it down in size and make it more manageable for training courses. We only use a few pupils in the current year for training purposes - so wondered if anyone had any clever way of removing redundant data (eg all pupils with surname not beginning with A, old years of attendance etc) and then compacting? The database has built over the years and we just wanted to streamline it!

Hi we use a few different SIMS.Mdf for training purposes.. these have evolved over the years and are now an unwieldy 2GB. Is there anything I can do to shrink the MDF to a more manegable size - we have shrunk the LDF but cant see how to reduce the MDF? Its only training data so would be happy to remove historical/old data.. thanks

Thanks guys, all info much appreciated. Will go have a look at sims.db_version_info. cheers

hello Does anyone here know where the SIMS version is held in the SQL tables. We want to run a SQL script across a lot of our Schools to check the SIMS version. Need to make sure they are all upgraded to the same version (don't trust what Schools Manager is telling me!) thanks Suzanne