Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Design considerations for database cleanup application. Expand / Collapse
Posted Wednesday, June 26, 2013 8:46 AM



Group: General Forum Members
Last Login: Yesterday @ 7:41 AM
Points: 5,524, Visits: 8,033
I have a client that has several thousand SQL Express instances at their clients, hosting tens of thousands of databases. Works fine, lasts a long time!

Sounds like your .NET batching will work fine, and you can obviously build in a good bit of error handling, retries, notifications, logging, etc. And having your code run as a windows service installed with your app make it available to control it's own execution too.


Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1467715
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse