mssqlcompressed-users

[Mssqlcompressed-users] restore verifyonly

[Antonio R. Z. <Ant...@me...>]

Hi,

I was having a look at the Documentation and couldn't figure out if there is an option to do a "RESTORE VERIFYONLY".

I.e.: I have 5 huge .bak files. So before doing a restore, to verify whether the .bak files are fine, I execute:
---
RESTORE VERIFYONLY FROM BDVmyDb1, BDVmyDb2, BDVmyDb3, BDVmyDb4, BDVmyDb5
---
If they are not, I don't attempt to drop & restore the database.

Cheers,


Antonio

Re: [Mssqlcompressed-users] restore verifyonly

[Clay L. <cl...@le...>]

Definitely!  It's on the todo list:
http://sourceforge.net/tracker/?func=detail&aid=2922404&group_id=229242&atid=1076259


On Wednesday, March 17, 2010, Antonio Ruiz Zwollo
<Ant...@me...> wrote:
> Hi,
>
> I was having a look at the Documentation and couldn't figure out if there is an option to do a "RESTORE VERIFYONLY".
>
> I.e.: I have 5 huge .bak files. So before doing a restore, to verify whether the .bak files are fine, I execute:
> ---
> RESTORE VERIFYONLY FROM BDVmyDb1, BDVmyDb2, BDVmyDb3, BDVmyDb4, BDVmyDb5
> ---
> If they are not, I don't attempt to drop & restore the database.
>
> Cheers,
>
>
> Antonio
>
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> Mssqlcompressed-users mailing list
> Mss...@li...
> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users
>