Results 1 to 7 of 7

Thread: MS SQL Book !!!

  1. #1
    Join Date
    Oct 2009
    Posts
    12

    Unanswered: MS SQL Book !!!

    I'm looking for book recommendations on MS SQL Server 2005 Express.
    I've just migrated our Access DB (Classic ASP web application) and need to get to grips with it.
    I will be developing the DB further and also administering it.
    Any advice appreciated.

    Regards
    Andy

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

  3. #3
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Probably the first mistake everyone makes when doing this is having their user database using the full recovery model (model db setting), and not putting any log mgmt jobs in place and eventually you run out of space on the log drive. Either make sure you switch the DB to use the simple recovery model, or put log dump/truncate jobs in place.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by PMASchmed View Post
    Probably the first mistake everyone makes when doing this is having their user database using the full recovery model (model db setting), and not putting any log mgmt jobs in place and eventually you run out of space on the log drive. Either make sure you switch the DB to use the simple recovery model, or put log dump/truncate jobs in place.
    Using FULL is not a mistake

    Then Mistake in knowing that you NEED to do Maintenance
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Quote Originally Posted by PMASchmed View Post
    Either make sure you switch the DB to use the simple recovery model, or put log dump/truncate jobs in place.
    You mean log BACKUPs, right? Truncation is automatic and never needs a special job to do it. Just clarifying for the benefit of anyone reading your advice.

  6. #6
    Join Date
    Mar 2006
    Posts
    3
    In full recovery mode you need to backup the log which will then truncate any completed transactions.

    if you care about your data, make sure you keep the db in full mode and make regular log backups.

  7. #7
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by Brett Kaiser View Post
    Using FULL is not a mistake

    Then Mistake in knowing that you NEED to do Maintenance
    C'mon Brett, now your getting picky.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •