Re: oh great SQL gurus..... statement for validating that all of the

Subject:	Re: oh great SQL gurus..... statement for validating that all of the NT servers all have valid registry backups
From:	Mark Stapleton <stapleto AT BERBEE DOT COM>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Tue, 21 Jan 2003 10:36:03 -0600

On Tue, 2003-01-21 at 10:30, Lisa Cabanas wrote:
> I was hoping one of you nice SQL gods/goddesses (Paul???) would help me
> construct a SQL select statement that won't halt my server, won't take days
> to run, and will help me validate that all of our NT servers all have
> active and inactive copies of c:\adsm.sys\...\MACHINE\*
>
> Now that I get to looking.... I don't easily see how to get what I am
> looking for with a select-- is this actually going to be a show bitfile
> kind-of-thing? (yuk)

Rather than rigorously getting results for *every* Windows client, just
randomly check a few each week with

        dsmc restore c:\adsm.sys\* -virtualnodename=<node_name>
                     -subdir=yes -ina -pick

--
Mark Stapleton (stapleton AT berbee DOT com)

<Prev in Thread]	Current Thread	[Next in Thread>
Re: oh great SQL gurus..... statement for validating that all of the NT servers all have valid registry backups, Mark Stapleton <= Re: oh great SQL gurus..... statement for validating that all of the NT servers all have valid registry backups, Seay, Paul

Re: oh great SQL gurus..... statement for validating that all of the NT servers all have valid registry backups