Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:19 AM
Points: 4,399, Visits: 6,255
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.


Best,

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