Results 1 to 17 of 17

Thread: [NOT RESOLVED] Periodic compact database, MSSQL 2000

Threaded View

  1. Jul 10th, 2006, 10:57 AM #1
    Dave Sell
    Dave Sell is offline

    Thread Starter
    PowerPoster Dave Sell's Avatar
    Join Date
    Mar 2004
    Location
    /dev/null
    Posts
    2,961

    Question [NOT RESOLVED] Periodic compact database, MSSQL 2000

    All,

    as per this thread, I found a way to tame my ever-growing log file.

    I assume I can put this in a stored proc or udf. Assuming I do, how can I make it automatically execute periodically, like once a week.

    I might even like to get real fancy-like and have it execute only if the database grows to some certain size.

    Any ideas?

    Thanks!

    Dave
    Last edited by Dave Sell; Jul 11th, 2006 at 11:30 AM.
    Nobody knows what software they want until after you've delivered what they originally asked for.

    Don't solve problems which don't exist.

    "If I had eight hours to cut down a tree, I'd spend six hours sharpening my axe." --- Abraham Lincoln (1809-1865)

    2 idiots don't make a genius.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width