>maybe there's just an old transaction left open? Try DBCC OPENTRAN
>(Emerald) to check,
This is what I got
Transaction Information for database: Emerald
No active open transactions.
Replicated Transaction Information:
Oldest Distributed RID : (287134 , 19)
Time Stamp : 0001 0042D26A
Oldest Non-Distributed RID : (281754 , 15)
Time Stamp : 0001 004479A1
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
>then issue
> dump transaction Emerald with truncate_only
This is what I got back
This command did not return data, and it did not return any rows
>followed by
> dump database Emerald to disk = '\\DNS1\dns1.cdr\Emerald1.dat' with
init, stats=5>
Not sure what it was looking for here but this is what I got back
Msg 3201, Level 16, State 1
Can't open dump device '\\DNS1\dns1.cdr\Emerald1.dat', device error or
device off line. Please consult the SQL Server error log for more details.
>Please let me know if it worked!
So I guess it didn't work...:-(
Thanks again,
Will ,,,=^. .^=,,,
Webmaster
* GreenNet========================================*
* "Link Locally ~ Surf Globally" http://www.greennet.net *
* Come Play On Our Game Server *
* Serving northeastern Massachusetts, southern New Hampshire *
* TEL: 508-363-8898 FAX: 508-363-1225 email:will@greennet.net*
*===============================================*