+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 33
MIS Systems Thread, Database - where is it? in Technical; Run system manager from SIMS now, and choose the backup option. This should save it locally, but i think there ...
  1. #16

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Run system manager from SIMS now, and choose the backup option. This should save it locally, but i think there is an option to change path.
    Do this NOW!

    Focus | System
    [you need to have system manager rights, oh how i hope you have these.]

    Close the pop up window.
    Click on Tools | Backup Path
    Enter something local, or just record what is has as it should be on the local drive, and you can browse there later to extract the file.
    Click on Tools | Create Backup.

    You can do this now even with people logged in. You need to make sure you have at least one file you have access to. Zip it up with a password, put it on an encrypted drive and take it home with you tonight.

    Also, talk to RM as they can't remove your access to your backups, they have to give them to you as it's your data, or destroy it, but that's not legal as you need to keep it.

  2. Thanks to vikpaw from:

    quietriot1983 (16th March 2011)

  3. #17
    quietriot1983's Avatar
    Join Date
    Dec 2010
    Location
    Manchester
    Posts
    105
    Thank Post
    15
    Thanked 6 Times in 6 Posts
    Rep Power
    9
    It's no RM yet, it's Salford authority, I already burnt our bridges with them as they wouldn't set up simple email forwarding for us (long story).

    I will try that backup method as soon as the secretary gets up for a brew!

  4. #18
    quietriot1983's Avatar
    Join Date
    Dec 2010
    Location
    Manchester
    Posts
    105
    Thank Post
    15
    Thanked 6 Times in 6 Posts
    Rep Power
    9
    OK, it seems that everything was held locally. So I've backed up C:\program files\SIMS and all its contents, and bundled the drive into a safe.

  5. #19

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,680
    Thank Post
    516
    Thanked 2,451 Times in 1,897 Posts
    Blog Entries
    24
    Rep Power
    832
    Quote Originally Posted by stpaulscrompton View Post
    OK, it seems that everything was held locally. So I've backed up C:\program files\SIMS and all its contents, and bundled the drive into a safe.
    THe data is not stored in the c:\program files\SIMS directory. It is stored in the MSSQL directory structure. Also, the simsarea share will likely not be there either - it will be another directory.

  6. #20

    Join Date
    Apr 2010
    Posts
    2,038
    Thank Post
    83
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    If you are sure the full sims and sql are on the client computer you could do a vmware capture to get a full working version of that computer you can then run from any machine if needed. Vmware capture is free.

  7. #21
    quietriot1983's Avatar
    Join Date
    Dec 2010
    Location
    Manchester
    Posts
    105
    Thank Post
    15
    Thanked 6 Times in 6 Posts
    Rep Power
    9
    I meant to say that I did it that way because the Focus > System option is not there. And if I did it through dbattach, the credentials were not correct :/
    Where might I find the SQL directory structure?

  8. #22

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    22
    Look for something like program files\microsoft sql server\MSSQL.??\MSSQL\Data. The database file should be SIMS.mdf and there will also be the log file SIMS.ldf. However if you just back up these files and try to restore from them later you may have trouble logging back into SIMS as the user password data is saved elsewhere (I think in the master database but I'm not absolutely sure) If you back up and restore using dbattach the user credentials are saved and restored as well. If you can't find focus system it would appear you don't have administrator permissions and if you don't have the sa password for the sql database you are storing up all sorts of problems. It is possible to reset the sa password but you really need to know what you are doing. If you can't ask your Local authority for support can you find someone at a nearby school who has SIMS experience?

  9. #23

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,028
    Thank Post
    374
    Thanked 367 Times in 299 Posts
    Blog Entries
    8
    Rep Power
    176
    I think everyone here has iterated to the correct course of action. My 2 pence here is just to mention on that last point from OP: You will not be able to copy and manipulate the core database files (mdf/ldf) while SQL is on and active. Not that copying the database etc from there gets you far, but just as a warning. dbAttach is the way.

  10. #24

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    stpauls' - someone at your school must have system manager rights, or there must be someone that creates new users when they join. Who is this person? They have the ability to do this backup, and also to grant you those rights. Try and get that sorted. Hopefully they aren't offsite support, but even if they are, someone on site has the right for this level of permissions.

    If you get really desperate, i should have somewhere are really old .exe file that will backup sims, but haven't used it for a while, it was from my old LA, it just replicates the system manager backup.

    To get around the problem GREED mentioned you can just stop the SQL services on that machine. Obviously warn any users sims will be down, though i suspect that machine is the only user...

    You need to copy the full C:\program files\ folder if you don't want to go hunting, though again, services will need to be switched off for you to be able to take the database file.

    You also need the docstorage and sims share, as i mentioned before, both in different locations.

    If you're really desperate for help, i'm sure someone will be willing to speak to you on the phone and talk you through it. I'd offer, but i'm only in synch 40% of the time and the phone bill will be more than Capita would charge to come out and do it for you!
    Last edited by vikpaw; 19th March 2011 at 12:43 PM. Reason: major typos

  11. #25
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    10
    If it'll help I do have a script that will reset the SA password. The SA username and password can then be used with DBAttach to correctly detach the DB (or just back it up).

    Also, a word of caution: I've had schools backup the SIMS DB by just stopping the services then backing-up the raw files; .mdf and .ldf. At more than one school this failed when a restore was needed and Capita (with a healthy charge) had to fix it. As GREED said; "DBAttach is the way".

    @stpaulscrompton, you haven't mentioned FMS. Do you use this? If so, it has it's own DB and it's own version of DBAttach.

    One final thing. @stpaulscrompton I do know someone who works with schools in the Manchester area. I've worked with him in the past and this kind of thing is his bread'n'butter. Drop me a PM and I can send you his details. He would almost certainly be able to sort you out.

  12. #26

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,968
    Thank Post
    112
    Thanked 489 Times in 335 Posts
    Blog Entries
    2
    Rep Power
    283
    If you have a Windows administrative access to the SQL server, you can change the sa password without knowing the old one. You can use either the SQL Management GUI, or, if that isn't installed, an OSQL command line. It's fairly simple, I won't post it here, but PM me if you want the instructions.

    As for backing up SQL, you can't assume anything about where the database may be. On a simple system, it is likely to be C:\Program Files\Microsoft SQL Server\etc, but it's not guaranteed. It could be on a separate volume or disk, for instance.

    To find out where the files live, this SQL code will show the physical file names used by a particular database:
    Code:
    use [name_of_you_sims_database]
    select filename from sysfiles
    As for backing up, you must use a proper SQL backup, either from a script, DBAttach, an SQL scheduled task or a third party SQL backup solution. Stopping the server and copying the physical files is not the way to do it.
    Last edited by jinnantonnixx; 21st March 2011 at 08:54 AM.

  13. #27

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,968
    Thank Post
    112
    Thanked 489 Times in 335 Posts
    Blog Entries
    2
    Rep Power
    283
    Here's a good article about SQL backups from the Petri website. If you don't know about Petri, bookmark it now. Essential website for all IT.

    This steps you the the basics of DIY SQL backups.
    Backup Job in SQL Server: How to Create for Single/Multiple DBs
    Last edited by jinnantonnixx; 21st March 2011 at 09:19 AM.

  14. #28
    quietriot1983's Avatar
    Join Date
    Dec 2010
    Location
    Manchester
    Posts
    105
    Thank Post
    15
    Thanked 6 Times in 6 Posts
    Rep Power
    9
    Thanks for all the offers of help, it is much appreciated!

    I've successfully got System Admin details off the outgoing support desk, so will try a dbattach backup ASAP.

  15. #29

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Good point about the FMS!

    Probably shouldn't share the script about resetting SA, though i'm sure the code is easily downloaded from any other forum. You have to have rights to access and run code on the server to do it anyway.

    I wonder what was wrong with a stopped service backup. The only fancy thing that dbattach does that i can recall is keeping hold of the logins, and possibly shrinking the log file too, in the old days.

    re: manchester support: It's not that john howarth guy is it?
    Last edited by vikpaw; 21st March 2011 at 01:43 PM. Reason: clarity

  16. #30
    CAM
    CAM is online now

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,111
    Thank Post
    826
    Thanked 356 Times in 280 Posts
    Blog Entries
    60
    Rep Power
    281
    Resetting SA is easy, you start SQLServer in Single User mode and it uses the Windows login to authenticate you instead. After the password is reset you put it back into normal mode. Had to do this myself on my Green Abbey test server.

SHARE:
+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

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