How to set the REDO_QUEUE size?

I have found some article on the web talking about how to change the REDO_QUEUE size like "ALTER DATABASE [AdventureWorks] SET PARTNER REDO_QUEUE 100MB;"

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

When I run it, the result is "Incorrect syntax near 'REDO_QUEUE'."

I have query for the Books online and there is no REDO_QUEUE there.

I also found "The only supported value for a mirrored database is the UNLIMITED value" on the MS KB http://support.microsoft.com/kb/907741

Is this comment obsoleted?

Thanks.

You can not set the redo queue.

|||

Hi, since we want to limit the size that is occuiped by the db mirroring to prevent the computer "hang" due to no free hard disk space, is there any other way to set the size limit?

Thanks in advance.