Page 1 of 2 12 LastLast
Results 1 to 16 of 23

Thread: Sbs 2011

  1. #1
    HEXUS.social member Disturbedguy's Avatar
    Join Date
    Nov 2006
    Location
    Manchester
    Posts
    5,113
    Thanks
    841
    Thanked
    482 times in 357 posts
    • Disturbedguy's system
      • Motherboard:
      • Asus Rog Strix Z370-H Gaming
      • CPU:
      • i7 8700K
      • Memory:
      • 16GB Corsair something or other
      • Storage:
      • 1 x Samsung 960 EVO (250GB) 1 x Samsung 850 EVO (500GB)
      • Graphics card(s):
      • GTX 1080Ti
      • Operating System:
      • Windows 7 Ultimate
      • Monitor(s):
      • 32inch Samsung TV
      • Internet:
      • Crap

    Sbs 2011

    Hi guys,

    Someone has asked me for some help in regards to SBS 2011 but I have limited knowledge in regards to SBS 2011 so I thought I would ask here.

    This person has set up a group policy at work, that when users log on they receive a new copy of a database, the database gets delivered however the clients db's keep coming up with "db needs repairing", this keeps coming up through the day. It doesn't happen on any set machine at any set interval from what I can gather, it will happen on different machines throughout the day.

    Anyone got any ideas?
    Quote Originally Posted by TAKTAK View Post
    It didn't fall off, it merely became insufficient at it's purpose and got a bit droopy...

  2. #2
    Splash
    Guest

    Re: Sbs 2011

    What kind of database? How is it delivered (to local disk, network share etc)? Don't think this is likely to be SBS specific tbh.

  3. Received thanks from:

    Disturbedguy (09-07-2012)

  4. #3
    HEXUS.social member Disturbedguy's Avatar
    Join Date
    Nov 2006
    Location
    Manchester
    Posts
    5,113
    Thanks
    841
    Thanked
    482 times in 357 posts
    • Disturbedguy's system
      • Motherboard:
      • Asus Rog Strix Z370-H Gaming
      • CPU:
      • i7 8700K
      • Memory:
      • 16GB Corsair something or other
      • Storage:
      • 1 x Samsung 960 EVO (250GB) 1 x Samsung 850 EVO (500GB)
      • Graphics card(s):
      • GTX 1080Ti
      • Operating System:
      • Windows 7 Ultimate
      • Monitor(s):
      • 32inch Samsung TV
      • Internet:
      • Crap

    Re: Sbs 2011

    Quote Originally Posted by Splash View Post
    What kind of database? How is it delivered (to local disk, network share etc)? Don't think this is likely to be SBS specific tbh.
    That's what I thought, as the database doesn't actually have any issues as she checked when the warnings came up.

    I will get answers to the other questions.
    Quote Originally Posted by TAKTAK View Post
    It didn't fall off, it merely became insufficient at it's purpose and got a bit droopy...

  5. #4
    HEXUS.social member Disturbedguy's Avatar
    Join Date
    Nov 2006
    Location
    Manchester
    Posts
    5,113
    Thanks
    841
    Thanked
    482 times in 357 posts
    • Disturbedguy's system
      • Motherboard:
      • Asus Rog Strix Z370-H Gaming
      • CPU:
      • i7 8700K
      • Memory:
      • 16GB Corsair something or other
      • Storage:
      • 1 x Samsung 960 EVO (250GB) 1 x Samsung 850 EVO (500GB)
      • Graphics card(s):
      • GTX 1080Ti
      • Operating System:
      • Windows 7 Ultimate
      • Monitor(s):
      • 32inch Samsung TV
      • Internet:
      • Crap

    Re: Sbs 2011

    Had a reply, hope this makes sense -

    Access front end, stored on sbs2011 server, 'replaces' local copy using full server path on group policy (user file, not computer file).
    Quote Originally Posted by TAKTAK View Post
    It didn't fall off, it merely became insufficient at it's purpose and got a bit droopy...

  6. #5
    Splash
    Guest

    Re: Sbs 2011

    Access front end? Suggesting an ODBC connection to a backend (SQL? Oracle?) hosted centrally on the SBS box, I assume? Correct version of the Access runtime installed on the clients?

  7. Received thanks from:

    Disturbedguy (09-07-2012)

  8. #6
    HEXUS.social member Disturbedguy's Avatar
    Join Date
    Nov 2006
    Location
    Manchester
    Posts
    5,113
    Thanks
    841
    Thanked
    482 times in 357 posts
    • Disturbedguy's system
      • Motherboard:
      • Asus Rog Strix Z370-H Gaming
      • CPU:
      • i7 8700K
      • Memory:
      • 16GB Corsair something or other
      • Storage:
      • 1 x Samsung 960 EVO (250GB) 1 x Samsung 850 EVO (500GB)
      • Graphics card(s):
      • GTX 1080Ti
      • Operating System:
      • Windows 7 Ultimate
      • Monitor(s):
      • 32inch Samsung TV
      • Internet:
      • Crap

    Re: Sbs 2011

    Thanks for the reply, the answers I've been given are -
    Backend is MySQL on completely separate linux box (whose sole function is MySQL). Access all correct, no issues when group policy is disabled
    Quote Originally Posted by TAKTAK View Post
    It didn't fall off, it merely became insufficient at it's purpose and got a bit droopy...

  9. #7
    Senior Member
    Join Date
    Mar 2005
    Posts
    4,825
    Thanks
    161
    Thanked
    358 times in 288 posts
    • badass's system
      • Motherboard:
      • ASUS P8Z77-m pro
      • CPU:
      • Core i5 3570K
      • Memory:
      • 32GB
      • Storage:
      • 1TB Samsung 850 EVO, 2TB WD Green
      • Graphics card(s):
      • Radeon RX 580
      • PSU:
      • Corsair HX520W
      • Case:
      • Silverstone SG02-F
      • Operating System:
      • Windows 10 X64
      • Monitor(s):
      • Del U2311, LG226WTQ
      • Internet:
      • 80/20 FTTC

    Re: Sbs 2011

    MySQL on an access front end?
    My guess is that isn't helping. MS software often doesn't play nice with other vendors software.
    However the whole thing sounds fishy. A database on a linux box is copied to a local location every time the user logs on and accessed through the MS access runtime?

    This sounds very much like the shall I use the glass bottle or old shoe problem
    "In a perfect world... spammers would get caught, go to jail, and share a cell with many men who have enlarged their penises, taken Viagra and are looking for a new relationship."

  10. #8
    HEXUS.social member Disturbedguy's Avatar
    Join Date
    Nov 2006
    Location
    Manchester
    Posts
    5,113
    Thanks
    841
    Thanked
    482 times in 357 posts
    • Disturbedguy's system
      • Motherboard:
      • Asus Rog Strix Z370-H Gaming
      • CPU:
      • i7 8700K
      • Memory:
      • 16GB Corsair something or other
      • Storage:
      • 1 x Samsung 960 EVO (250GB) 1 x Samsung 850 EVO (500GB)
      • Graphics card(s):
      • GTX 1080Ti
      • Operating System:
      • Windows 7 Ultimate
      • Monitor(s):
      • 32inch Samsung TV
      • Internet:
      • Crap

    Re: Sbs 2011

    Quote Originally Posted by badass View Post
    MySQL on an access front end?
    My guess is that isn't helping. MS software often doesn't play nice with other vendors software.
    However the whole thing sounds fishy. A database on a linux box is copied to a local location every time the user logs on and accessed through the MS access runtime?

    This sounds very much like the shall I use the glass bottle or old shoe problem
    Thanks for that, clearly helps in finding a solution.
    Quote Originally Posted by TAKTAK View Post
    It didn't fall off, it merely became insufficient at it's purpose and got a bit droopy...

  11. #9
    Administrator Moby-Dick's Avatar
    Join Date
    Jul 2003
    Location
    There's no place like ::1 (IPv6 version)
    Posts
    10,665
    Thanks
    53
    Thanked
    385 times in 314 posts

    Re: Sbs 2011

    from a logic point of view if you copy a *running* database to a new location and start it up with a different client - there is a good chance that the DB will come up in a "dirty" state.

    try this foryourself ... find a ( non production SQL server ) and switch it off. When you power it back on , you'll see a bucketload of messages in the event log as SQL goes through a check to ensure that the database is consistent and that the last commited transactions are good.

    I also might have got the wrong end of the stick here. why does the access component need such frequent updates if the data is being held in Mysql.

    Martin, I was running Access front end with a sybase back end 13 years ago - it works fine , whats what ODBC does
    my Virtualisation Blog http://jfvi.co.uk Virtualisation Podcast http://vsoup.net

  12. Received thanks from:

    Disturbedguy (09-07-2012)

  13. #10
    Not a good person scaryjim's Avatar
    Join Date
    Jan 2009
    Location
    Gateshead
    Posts
    15,196
    Thanks
    1,230
    Thanked
    2,291 times in 1,874 posts
    • scaryjim's system
      • Motherboard:
      • Dell Inspiron
      • CPU:
      • Core i5 8250U
      • Memory:
      • 2x 4GB DDR4 2666
      • Storage:
      • 128GB M.2 SSD + 1TB HDD
      • Graphics card(s):
      • Radeon R5 230
      • PSU:
      • Battery/Dell brick
      • Case:
      • Dell Inspiron 5570
      • Operating System:
      • Windows 10
      • Monitor(s):
      • 15" 1080p laptop panel

    Re: Sbs 2011

    I think you need to find out exactly what is being copied. If there's a database running on MySQL that *shouldn't* be being copied - the Access application should be accessing the central db through ODBC. If it's the Access app itself that's being copied (which seems more likely) you need to find out why.

    My best guess at the situation is this: a "master" copy of the Access app is stored on a shared server. This app is sometimes updated for business reasons, and the owner of the db wants to make sure people always use the latest version. So there's a group policy to drop a copy of the app into the user's workspace (desktop/documents folder/wherever) every time they log on, to make sure they have the latest version. If that's the case, it's most likely to be a transient network or disk issue that means that occasionally the Access app gets corrupted during the copying process.

    And frankly, that about as much brain power as I can afford to put into it, since sorting out that kind of problem is one of the things I charge people (very reasonable amounts of) money for...

  14. Received thanks from:

    Disturbedguy (09-07-2012)

  15. #11
    HEXUS.social member Disturbedguy's Avatar
    Join Date
    Nov 2006
    Location
    Manchester
    Posts
    5,113
    Thanks
    841
    Thanked
    482 times in 357 posts
    • Disturbedguy's system
      • Motherboard:
      • Asus Rog Strix Z370-H Gaming
      • CPU:
      • i7 8700K
      • Memory:
      • 16GB Corsair something or other
      • Storage:
      • 1 x Samsung 960 EVO (250GB) 1 x Samsung 850 EVO (500GB)
      • Graphics card(s):
      • GTX 1080Ti
      • Operating System:
      • Windows 7 Ultimate
      • Monitor(s):
      • 32inch Samsung TV
      • Internet:
      • Crap

    Re: Sbs 2011

    Cheers for the replies guys.

    What scaryjim said is what i thought, some network issue somewhere causing this to happen. Had it been set machines, I would have said it was the machines.

    Also, in regards to why it needs such frequent updates, the company sell printers and consumables and such so I think this database would be the one that stores stock information (could possibly be client information but I would suspect this would be a different db for security reasons).

    One thing I did think of, although I am not sure how valid it might be, if they are using VOIP phones (network cable into phone, cable to PC) when the users receive calls or hang up, could this cause the DB to think its lost connection, in which case it thinks the DB is corrupt? :/
    Quote Originally Posted by TAKTAK View Post
    It didn't fall off, it merely became insufficient at it's purpose and got a bit droopy...

  16. #12
    Not a good person scaryjim's Avatar
    Join Date
    Jan 2009
    Location
    Gateshead
    Posts
    15,196
    Thanks
    1,230
    Thanked
    2,291 times in 1,874 posts
    • scaryjim's system
      • Motherboard:
      • Dell Inspiron
      • CPU:
      • Core i5 8250U
      • Memory:
      • 2x 4GB DDR4 2666
      • Storage:
      • 128GB M.2 SSD + 1TB HDD
      • Graphics card(s):
      • Radeon R5 230
      • PSU:
      • Battery/Dell brick
      • Case:
      • Dell Inspiron 5570
      • Operating System:
      • Windows 10
      • Monitor(s):
      • 15" 1080p laptop panel

    Re: Sbs 2011

    Hmmm, VOIP phones should have no impact at all. That whole system sounds like an odd setup tbh, they shouldn't need to change the front end just for stock information. I reckon they need to get someone in to look at it properly: whatever's going on it's not quite right. I know it wasn't very useful to you, but badass's "glass bottle, old shoe" point has a lot of resonance. If they're meant to have a distributed database-driven inventory app but they're regularly copying data around instead of accessing it from a single point, something's not been set up right...

  17. #13
    HEXUS.social member Disturbedguy's Avatar
    Join Date
    Nov 2006
    Location
    Manchester
    Posts
    5,113
    Thanks
    841
    Thanked
    482 times in 357 posts
    • Disturbedguy's system
      • Motherboard:
      • Asus Rog Strix Z370-H Gaming
      • CPU:
      • i7 8700K
      • Memory:
      • 16GB Corsair something or other
      • Storage:
      • 1 x Samsung 960 EVO (250GB) 1 x Samsung 850 EVO (500GB)
      • Graphics card(s):
      • GTX 1080Ti
      • Operating System:
      • Windows 7 Ultimate
      • Monitor(s):
      • 32inch Samsung TV
      • Internet:
      • Crap

    Re: Sbs 2011

    One of the issues is, from my understand and opinion, he didn't get a professional in to install the stuff in the first place or if they did, they ripped him off. From what I have heard a lot of the stuff is bodged jobs and the person I know has been working to fix this stuff since they have started.

    I'm still waiting for more information based on your earlier reply and Moby's answer.
    Quote Originally Posted by TAKTAK View Post
    It didn't fall off, it merely became insufficient at it's purpose and got a bit droopy...

  18. #14
    HEXUS.social member Disturbedguy's Avatar
    Join Date
    Nov 2006
    Location
    Manchester
    Posts
    5,113
    Thanks
    841
    Thanked
    482 times in 357 posts
    • Disturbedguy's system
      • Motherboard:
      • Asus Rog Strix Z370-H Gaming
      • CPU:
      • i7 8700K
      • Memory:
      • 16GB Corsair something or other
      • Storage:
      • 1 x Samsung 960 EVO (250GB) 1 x Samsung 850 EVO (500GB)
      • Graphics card(s):
      • GTX 1080Ti
      • Operating System:
      • Windows 7 Ultimate
      • Monitor(s):
      • 32inch Samsung TV
      • Internet:
      • Crap

    Re: Sbs 2011

    Ok so I got some more information -

    I have a copy of the Access front end on my PC.
    When I make changes, I copy it to the server (L drive).
    When users log on, I want them to get a new copy of the FE database – I got told to use ‘Group Policies’.
    I set up the Group Policy to copy the database from //server/database/database.mdb to C:/database/database.mdb – this works fine.
    Randomly throughout the day, it would get ‘corrupted’ errors or ‘record locked’ – which I understand cos obviously if you try replacing a file that’s in use, issues.
    I found a setting in the group policy rules that says it disables refreshing, and only runs the group policy when the user logs in. – I enabled that.
    It says in it that ‘the pc needs to be restarted for this setting to take effect – but doesn’t specify client or server.
    After rebooting the clients, still had the ‘corrupt’ issue.
    After rebooting the server, some users still randomly get the same issue. – I asked about this, some users have simply stopped telling the person and just click the "ok" button

    There isn’t an issue in the copying process – all users get a new copy of the db and it works – to begin with.
    Then all of a sudden the ‘corrupt’ appears.
    Close the DB, re-open and it tells you it needs repairing.
    Repair it, and it works fine until next time.


    Various Operating Systems in use - Win 7 32 and 64bit along with Win XP

    It never happens on the machine the person uses as a test machine, although they don't use it all that much.

    As some extra information, the server has the latest copy which is pushed to the user, the user's don't / shoudn't be making any changes, if they do make them, they are lost when it next updates anyway.

    It look's like it could be something to do with the Group Policy, more importantly to do with the setting where it by default refreshes every 90 minutes and then a random time of 0 - 30 minutes to help stop flooding I assume.

    The last time it was running, was Thursday, the user logged in at around 08:30 and the error occurred between 10:15 and 10:30 which fits in with the default 90 + random up to 30 minutes thing.
    Quote Originally Posted by TAKTAK View Post
    It didn't fall off, it merely became insufficient at it's purpose and got a bit droopy...

  19. #15
    Administrator Moby-Dick's Avatar
    Join Date
    Jul 2003
    Location
    There's no place like ::1 (IPv6 version)
    Posts
    10,665
    Thanks
    53
    Thanked
    385 times in 314 posts

    Re: Sbs 2011

    how often does the Front end change ?
    my Virtualisation Blog http://jfvi.co.uk Virtualisation Podcast http://vsoup.net

  20. #16
    HEXUS.social member Disturbedguy's Avatar
    Join Date
    Nov 2006
    Location
    Manchester
    Posts
    5,113
    Thanks
    841
    Thanked
    482 times in 357 posts
    • Disturbedguy's system
      • Motherboard:
      • Asus Rog Strix Z370-H Gaming
      • CPU:
      • i7 8700K
      • Memory:
      • 16GB Corsair something or other
      • Storage:
      • 1 x Samsung 960 EVO (250GB) 1 x Samsung 850 EVO (500GB)
      • Graphics card(s):
      • GTX 1080Ti
      • Operating System:
      • Windows 7 Ultimate
      • Monitor(s):
      • 32inch Samsung TV
      • Internet:
      • Crap

    Re: Sbs 2011

    Usually a fresh copy would be put on the server each night, however a new copy has not been put on the server for 2 - 3 weeks as some major changes are being made to the version on the persons machine.
    Quote Originally Posted by TAKTAK View Post
    It didn't fall off, it merely became insufficient at it's purpose and got a bit droopy...

Page 1 of 2 12 LastLast

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
  •