February 7, 2012 at 8:49 am
Hello,
I'm administering a 90-instance portfolio, spanning 1100 DBs and 15 TB. My management wishes to achieve a goal of performing a full validation of all the DBs in the portfolio every 24 hours. This would involve a full backup, copy to an alternate server, restore and recovery and DBCC CHECKDB for each DB. We're under the assumption that we'd need multiple test servers and instances to run several test restores concurrently, but we're debating whether a third party tool exists that can perform this workflow or if we should build a custom application using .NET and SMO to perform the work. Has anyone come across either type of solution?
Thank you,
Matt
February 8, 2012 at 5:07 am
Hi Matty,
We've just implemented a in-house written powershell script to run a CHECKDB against our environment from a central location and store the results in a db on a weekly schedule.
The difference between what we've done and what you need is that we don't take a backup 1st, the reason being that most of our db's are fairly small and we're lucky to have a window where transaction no.s are low.
I don't know of any tools around that do this, but that's not to say there aren't any.
Cheers
Vultar
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply