You have installed SQL 2000 with compatibility mode 80, and AdventureWorks has a compatibility mode 90.

This mean that AdventureWorks has data types, schemas, etc, not supported by SQL 2000

You only need add a sentence for attach_rebuild_log

With this script you can attach AdventureWorks in the same folder where master exists.

DECLARE @data_path nvarchar(256);

DECLARE @db nvarchar(50);

DECLARE @filename nvarchar(100);

SET @data_path = (SELECT...

yes, of course.

I've reviewed all logs in three nodes, and anything.

It seem a properti configuration on Polyserve, than trys to rehost to fisrt physical node