ADSM-L

Re: SQL Server: RESTORE VERIFYONLY

2003-07-21 08:21:21
Subject: Re: SQL Server: RESTORE VERIFYONLY
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 21 Jul 2003 08:16:39 -0400
Chris,

Data Protection for SQL does not have a VERIFYONLY function.
You will have to restore the database in order to verify it.
You could restore it to an alternate name or stand-by server
if you do not want to interrupt your live database.

Thanks,

Del

----------------------------------------------------

> The SQL Server command RESTORE ... VERIFYONLY allows you to check the
> physical integrity of a backup without having to actually restore it onto
a
> server.  Microsoft says that if your backup passes the VERIFYONLY test,
then
> they guarantee that it can be restored.
>
> What I want to know is whether this functionality is exposed through TDP
for
> SQL Server.  Does anybody know?  I can't find anything in the command
> reference.  I also couldn't find anything in the listserv archives
(though I
> haven't found a good way to search them yet).

<Prev in Thread] Current Thread [Next in Thread>
  • Re: SQL Server: RESTORE VERIFYONLY, Del Hoobler <=