+ Post New Thread
Page 1 of 3 123 LastLast
Results 1 to 15 of 33
MIS Systems Thread, Database - where is it? in Technical; Hi, I think I need some SIMS help. We have one machine in the office running SIMS, and I assumed ...
  1. #1
    quietriot1983's Avatar
    Join Date
    Dec 2010
    Location
    Manchester
    Posts
    105
    Thank Post
    15
    Thanked 6 Times in 6 Posts
    Rep Power
    10

    Database - where is it?

    Hi,

    I think I need some SIMS help. We have one machine in the office running SIMS, and I assumed that the database and all the information was held on the networked S: drive. However, I backed that up and then disabled the connection, and was still able to log in and access pupil data etc.

    So basically, I think my question is where does the SIMS data come from, can I find this out? And if it is coming from somewhere that will disappear when RM switch us off, how do I go about chianging its location to somewhere local?

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,529
    Thank Post
    527
    Thanked 2,648 Times in 2,049 Posts
    Blog Entries
    24
    Rep Power
    925
    The SIMS database is an MSSQL database running on the server where the S: drive is hosted.

    You really should speak to your SIMS support people to talk about migrations and the like, as you don't want it to go awry.

  3. #3

    Join Date
    Dec 2005
    Posts
    548
    Thank Post
    38
    Thanked 90 Times in 80 Posts
    Rep Power
    40
    Check for your connect.ini

    Our's is located on the S drive - s:\sims\connect.ini

    Mine states

    ServerName=hal\sims2008
    DatabaseName=sims
    Which shows the database server and the SQL instance name

  4. #4

    Join Date
    Apr 2010
    Posts
    2,169
    Thank Post
    111
    Thanked 192 Times in 159 Posts
    Rep Power
    85
    The data is held in sql probably on the c or d drive on the server not normally the s drive.

  5. #5

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    6,512
    Thank Post
    627
    Thanked 1,173 Times in 900 Posts
    Blog Entries
    15
    Rep Power
    524
    The typical Capita setup is that S: is mapped on all clients machines, which points to what is typically Dinsert sims installation directory here) on the admin server.
    You can have SIMS on single stations - perhaps S: is just a plain file storage for you and your MSSQL server in this instance is just on that single workstation.

    On a network server, it would usually be d:\admin data\sims for SIMS itself but the data will be d:\program files\mssql (or similar)
    On a workstation it'd be c:\program files\mssql for the SQL data.

  6. #6

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    23
    The actual database you are looking for is the SIMS.mdf file and is found somewhere like drive\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\DATA. However unless you are really sure what you are doing get Capita to help you move it. It's very easy to miss something and lose connectivity to your data

  7. #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
    The fact you can log in without your S drive connected means your connect.ini must be a local one, so i'm assuming this is your only SIMS machine.

    As others have said, the database file itself is on the machine running SQL, most likely the machine you are are using to access.
    Search for the connect.ini file to be sure, and also check for the Microsoft SQL Server folder.

    This 'server' computer should have quite recently been upgraded to the latest SQL version which is 2008. Perhaps you can remember where the work was done.

    I think you need to speak to who ever is maintaining the network and the backups (most important). Are backups being done, and where are they?
    So long as you have those, then it doesn't matter what RM do, although it would be nice to be shown some continuity information and will save some time and effort.

    In addition to the database backups, you should also have a backup of the S: share as well as the Document Storage folder which is usually on the C drive of the database server.

    If in doubt, call Capita / Tech Support.

  8. Thanks to vikpaw from:

    quietriot1983 (15th March 2011)

  9. #8
    quietriot1983's Avatar
    Join Date
    Dec 2010
    Location
    Manchester
    Posts
    105
    Thank Post
    15
    Thanked 6 Times in 6 Posts
    Rep Power
    10
    Yes that is our only SIMS machine. Off-site backups are being done, but again, when we get switched off these will disappear and I will take over the backing up of the system. What I'm most worried about right now is if we would lose all data when we get switched off. But you seem to have quelled that fear, so thanks!

  10. #9
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Reigate Area, Surrey
    Posts
    4,427
    Thank Post
    884
    Thanked 416 Times in 316 Posts
    Blog Entries
    61
    Rep Power
    328
    Start here: Sims Backup

    Has some warnings and resources for backing up in it.

  11. #10

    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
    When you say disappear, i take it you mean the system that does the backup will go, but you will have access to the off-site location, or will retrieve all your data prior to disappearance.

    I'm not really sure what service RM are doing for you, but i would get access to the backups, and follow some of the threads on how to setup a test sims installation. Either physical on a desktop or even virtualise it. You can test your backup works, and also play with the backing up routines yourself to put your mind at ease. The thread CAM linked to is really useful for this.

    Make sure you're happy with it all before your contract with RM ends, as the MIS data is the most valuable in the school.

  12. #11

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    837
    Thank Post
    179
    Thanked 106 Times in 73 Posts
    Rep Power
    186
    SIMS .net works as a service over the network and does not rely on the S drive being mapped, so long as the connect.ini file in C:\Program Files\SIMS\SIMS .net contains the name of the server rather than "redirect=S:\SIMS".

  13. #12

    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
    Quote Originally Posted by Jawloms View Post
    SIMS .net works as a service over the network and does not rely on the S drive being mapped, so long as the connect.ini file in C:\Program Files\SIMS\SIMS .net contains the name of the server rather than "redirect=S:\SIMS".
    That's what i meant by saying it was a local connect.ini, i.e. it's not redirected to a shared network connect.ini

  14. #13
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Reigate Area, Surrey
    Posts
    4,427
    Thank Post
    884
    Thanked 416 Times in 316 Posts
    Blog Entries
    61
    Rep Power
    328
    This is the connect.ini for my Green Abbey install:

    Code:
    ServerName=TECHPC\SIMS2005
    DatabaseName=SIMS_ga
    DatabaseMode=Online
    It's part of a larger 18 line (!) file to access a live and local database, this is the bit for the local database modified slightly.

    TECHPC is my computer's name, basically where the Green Abbey SIMS server is located. SIMS2005 is the name of the MS SQL Service. They combine to form TECHPC\SIMS2005 (Yes I am running it on SQL 2005 Express! ). This might also be called localhost\SIMS_2005.

    SIMS_ga is the name of the database SIMS_ga.ldf and SIMS_ga.mdf files in the Program Files tree for SQL Server. Use dbAttach to back these up (see the manual linked in that other thread).

    I don't know what DatabaseMode does but it didn't work without it. That may be to do with having one SIMS client for multiple database connections.

  15. #14
    quietriot1983's Avatar
    Join Date
    Dec 2010
    Location
    Manchester
    Posts
    105
    Thank Post
    15
    Thanked 6 Times in 6 Posts
    Rep Power
    10
    Quote Originally Posted by vikpaw View Post
    When you say disappear, i take it you mean the system that does the backup will go, but you will have access to the off-site location, or will retrieve all your data prior to disappearance.
    The off-site backups will go, and we will no longer have access to them. This current system was implemented before my time, so it doesn't help that the secretary has been unable to run a local backup, as we're unable to run executables from a secure backup drive (external).

    I want to do some form of backup before RM's services comes in (and therefore unplugs us from the matrix!), just incase it all goes tits up.

    I've printed that pdf file from the linked thread, so I'll try and get an hour or two with the secretary's machine and see if I can make head or tail of it.

    As you can tell, I don't know the first thing about SIMS.

  16. #15

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    23
    As CAM says you can use dbattach (found in - on my system- drive\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\binn) can be used to make a local back up of the data which saves in the drive\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\backup. Obviously your path might differ slightly and you will need the SQL sa password. I think you really need to talk to whoever does your SIMS support as your MIS data is critical and by your own admission you know very little about SIMS



SHARE:
+ Post New Thread
Page 1 of 3 123 LastLast

Similar Threads

  1. Branching Database
    By laserblazer in forum General Chat
    Replies: 9
    Last Post: 30th April 2010, 03:59 PM
  2. Database
    By silver_hippo in forum Courses and Training
    Replies: 2
    Last Post: 6th November 2008, 10:11 AM
  3. HELP!!!! - Database
    By lalalalalalalalalalala in forum How do you do....it?
    Replies: 1
    Last Post: 21st March 2007, 10:03 PM
  4. Replies: 4
    Last Post: 28th February 2007, 10:37 AM
  5. New Sims Database
    By SimAda00 in forum MIS Systems
    Replies: 0
    Last Post: 10th January 2007, 12:27 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
  •