Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2009

    Exclamation Unanswered: Noob SQL Server dba

    Hey guys-

    I'm a noob SQL Server dba (though a seasoned IT guy) and I am just learnign the ins and outs of SQL Server (mostly 2005).

    One thing I've come across (and I've looked through this forum)
    - In a 2005 db I used the maint. plan wizard to create full backups for a SIMPLE mode database (2 actually) and I noticed the option to delete backups older than x option is not there.

    Is there a reason for this?

    Apurshiate yur help on this.


  2. #2
    Join Date
    Nov 2002
    so the backups don't eat all of your hard drive space?

    Seasoned IT Guy?

    Is that with salt and pepper run out of disk when SQL Server is active, it could corrupt stuff...and that would be bad

    Make sure you have backups of master, msdb and model as well

    And you should try and not use the maint plans

    Look here

    Ramblings of a DBA - SQL Server - Database Administration

    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.

  3. #3
    Join Date
    Jul 2003
    The Dark Planet
    Quote Originally Posted by Brett Kaiser
    You beat me to it .... I was just searching Tara's blog for the right link :P
    Get yourself a copy of the The Holy Book

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

  4. #4
    Join Date
    Sep 2009
    Thanks guys.

    I will check this out.

    And by "seasoned IT" I don't mean pepper and salt. I have served as a Network Engineer, SQA and TAC agent previsouly to dba...though I do love my salt...

  5. #5
    Join Date
    Sep 2003
    Columbia, MD USA
    If you don't have 'Maintenance Cleanup Task' as an available option for your maintenance plans, you may want to check your version.

    Get Service Pack #3, should fix your problem

    How to obtain the latest service pack for SQL Server 2005

Posting Permissions

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