Print Page | Close Window

Automatic SQL Server DB Operation

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
Printed Date: 28 November 2022 at 2:51pm
Software Version: Web Wiz Forums 12.05 -

Topic: Automatic SQL Server DB Operation
Posted By: AlexW
Subject: Automatic SQL Server DB Operation
Date Posted: 21 July 2011 at 5:24pm
I want to purge data automatically from my SQL DB hosted on WebWiz.  Think the best way would be to create a stored proceedure, can I set a task from the 'myLittleAdmin' section that manages the database to run this SP say every 30 days?
Would there be a better way of going about this?

Posted By: WebWiz-Bruce
Date Posted: 21 July 2011 at 6:39pm
myLittleAdmin is simply a database editor allowing you to create, edit, and delete tables and stored procedures in a database, it's not able to automatically run anything.

I would suggest the best way would be to manually call a stored procedure or clean out the database once a month and then shrink the database to free up the empty space to allow it to be reused.

-------------" rel="nofollow - Find Web Wiz on Facebook" rel="nofollow - Follow Web Wiz on Twitter

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.05 -
Copyright ©2001-2022 Web Wiz Ltd. -