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: 29 November 2023 at 5:02am
Software Version: Web Wiz Forums 12.06 -

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 - Web Wiz Forums Hosting" rel="nofollow - ASP.NET Web Hosting

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.06 -
Copyright ©2001-2023 Web Wiz Ltd. -