Database Discussion - Automatic SQL Server DB Operation

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.
URL: https://forums.webwiz.net/forum_posts.asp?TID=29556
Printed Date: 29 November 2023 at 5:02am
Software Version: Web Wiz Forums 12.06 - https://www.webwizforums.com

Topic: Automatic SQL Server DB Operation

Posted By: AlexW
Subject: Automatic SQL Server DB Operation
Date Posted: 21 July 2011 at 5:24pm

Hi,

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?

Cheers,

Alex

Replies:

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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting