Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Unanswered: SQL database maintenance

    Hello All,

    I am using SQL 2000 Standart server as a backup database.
    I would like to build a maintenance which includes:
    delete records older then 30 days.
    re-build indexs
    limit the size of the database to 2047mb.

    please assist.
    Zeevi.

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: SQL database maintenance

    Originally posted by Zeevi
    Hello All,

    I am using SQL 2000 Standart server as a backup database.
    I would like to build a maintenance which includes:
    delete records older then 30 days.
    *** create sp and set up job for it

    re-build indexs
    *** use database maintenance plan

    limit the size of the database to 2047mb.
    *** setup max size for DB

    please assist.
    Zeevi.

  3. #3
    Join Date
    Sep 2003
    Posts
    2

    Re: SQL database maintenance

    Originally posted by snail
    Hello Snail,

    Thank you for your answer.
    Since I am not a DB administrator can you be more specific?

    What is sp?
    where can I creat a job?

    where can I limit the data base size?

    Thank you,
    Zeevi.

Posting Permissions

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