Re: Big Problem with SQL Logs

Will LaSala ( )
Fri, 13 Jun 1997 11:37:30 -0400

Thanks Peter,

>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

>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 ,,,=^. .^=,,,
* GreenNet========================================*
* "Link Locally ~ Surf Globally" *
* Come Play On Our Game Server *
* Serving northeastern Massachusetts, southern New Hampshire *
* TEL: 508-363-8898 FAX: 508-363-1225*