+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, Patch city and large mdf file in Technical; It was bound to happen eventually. We are still chasing up issues with Learning Aims before the Census. 5 patches ...
  1. #1

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,887
    Thank Post
    1,316
    Thanked 1,738 Times in 1,087 Posts
    Blog Entries
    19
    Rep Power
    563

    Patch city and large mdf file

    It was bound to happen eventually.

    We are still chasing up issues with Learning Aims before the Census. 5 patches were released by .ICT late this afternoon (in the hope that 2 of them would fix our final issues!).

    They were dutifully applied and the server was happy.

    I have just gone to test the issue (duplicate entries of students as members of courses, and knackered end / planned end dates!) and it takes forever to try to save ... i am used to this ...

    But then it times out and the connection to the DB goes ...

    restart SQL ... no joy ... restart the box ...I go to log into SIMS and I get incorrect password error.

    hmmm ... I try the backdoor

    no joy.

    I have a look in the error logs ... and spot
    CREATE/ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 2048 MB per database.
    Yes ... you've guessed it ... we are still running MSDE for it whilst we waited for a suitable time to upgrade to MSSQL 2005.

    Not being a DB admin can anyone suggest quick methods to compact the DB (I don't have the sa account here) or any other utils.

    Upgrading to 2005 is not an option today / tomorrow. I just need a quick fix to go in a purge some stuff.

  2. #2

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,800
    Thank Post
    110
    Thanked 582 Times in 503 Posts
    Blog Entries
    1
    Rep Power
    223

    Re: Patch city and large mdf file

    There are no quick fixes. It is not possible to run a compact job on an MSDE database instance. The only solution is to upgrade to SQL server.

  3. #3

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,887
    Thank Post
    1,316
    Thanked 1,738 Times in 1,087 Posts
    Blog Entries
    19
    Rep Power
    563

    Re: Patch city and large mdf file

    I had a really horrible feeling that would be the answer.

    Oh well ...

  4. #4

    Join Date
    Jul 2005
    Location
    Corby
    Posts
    1,056
    Thank Post
    12
    Thanked 20 Times in 18 Posts
    Rep Power
    23

    Re: Patch city and large mdf file

    Now if it was a JET 4.0 engine DB you could follow this:

    http://support.microsoft.com/kb/303528

    We are having the same issue with the errors Tony and we run SQL 2000 right now (waiting for the update to 2005- should be on the 19th of this month). I'm not sure that the most of the issues you saw were anything to do with MSDE, because when I left work yesterday Allan was still applying patches to fix whatever caused the 89 errors we got re-running the census check before today. On first run we got over 70 errors (same as yours); we fixed them. Re-ran and got no errors. Great (we thoughts) all ready!

    We re-ran to make sure (validation process) and got the 89 errors (more than before). We have a print out of the first successful run to prove to ourselves that it actually did work...

    We are down to 15 warnings which apparently is OK. But that's before doing the same thing today to get it sent off. And Allan isn't in- and I'm no DB admin either.

    Hopefully the move to SQL 2005 will sort a lot of this out.

    Good luck mate!!

    Paul

  5. #5

    Join Date
    Apr 2006
    Posts
    382
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    44

    Re: Patch city and large mdf file

    Hi

    OK, so it would seem the errors you are seeing are happening as a result of the database trying to increase in size, having filled up.

    You might find that someone logging in causes a log record to be written that tips the DB over the edge, although as Geoff says it could be coincidental. Depends on how good their error handling is ;-)

    Although you have MSDE there, you can manage it via the SQL Server 2005 Express Management Studio. This *should* (never tried it, take a backup first blah blah) be able to connect you to the DB such that you can change the growth property (properties > files > autogrowth > elipsis > blah blah > may need a restart, I don't know). By default this setting will be 10% of the current DB size, so you might be able to knock the number down or change to an MB increase, so that when someone logs in (if the above *is* the case) the critical size isn't hit.

  6. #6
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,386
    Thank Post
    10
    Thanked 483 Times in 423 Posts
    Rep Power
    110

    Re: Patch city and large mdf file

    Even compacted my database is 2.1GB It went over the 2GB mark with the august update, I assume due to the preperation for the sql. I've since migrated anyway, but I was using the full version so it wasn't an issue.

  7. #7

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,887
    Thank Post
    1,316
    Thanked 1,738 Times in 1,087 Posts
    Blog Entries
    19
    Rep Power
    563

    Re: Patch city and large mdf file

    The bullet was bitten and SQL 2000 was put on. It runs ... but the ldf file needs some serious truncating ... it grows at the rate of 1GB per hour in use.

    I am looking at the 3rd party call on the database used by Sleuth (actually the groupcall service) to see if that is hitting it hard but I don't think it is ... it only runs the extract once a day at 7pm.

    We are putting in notice to County that the return will be late and the reasons why ... and see what happens.

  8. #8

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,374
    Thank Post
    625
    Thanked 951 Times in 653 Posts
    Blog Entries
    2
    Rep Power
    318

    Re: Patch city and large mdf file

    Don't you just love microsoft and licensing

  9. #9

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,855
    Thank Post
    1,162
    Thanked 1,028 Times in 729 Posts
    Rep Power
    323

    Re: Patch city and large mdf file

    @grumbledook: yes sleuth hardly impacts but why only move to sql2000 and not 2005?

  10. #10

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,887
    Thank Post
    1,316
    Thanked 1,738 Times in 1,087 Posts
    Blog Entries
    19
    Rep Power
    563

    Re: Patch city and large mdf file

    We just needed to get it up and running, without introducing any other problems

    The main problem is that some tasks for sorting CENSUS data grew the DB and took ages .. that led to too large a DB but if we upgrade then other things may break.

  11. #11

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,855
    Thank Post
    1,162
    Thanked 1,028 Times in 729 Posts
    Rep Power
    323

    Re: Patch city and large mdf file

    what have your LEA said in response to your predicament?

SHARE:
+ Post New Thread

Similar Threads

  1. large sims directory
    By Uraken in forum MIS Systems
    Replies: 3
    Last Post: 30th October 2007, 02:28 PM
  2. Large video files ofr MEdia Studies
    By Kyle in forum How do you do....it?
    Replies: 2
    Last Post: 25th April 2007, 07:57 AM
  3. large File Transfer
    By SimpleSi in forum Windows
    Replies: 20
    Last Post: 26th March 2007, 06:24 PM
  4. Burlington, Wiltshire's Underground City
    By webman in forum General Chat
    Replies: 3
    Last Post: 5th June 2006, 11:56 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
  •