Step 3 didn't worked because it seems you have unsufficient rights. So
try it first this way:
Let's assume your SQL (!) servers name is 'SQL1', and this very server
(!) has a net share (NOT a directory!) named 'test'.
dump database Emerald to disk = '\\SQL1\test\Emerald1.dat' with init, stats=5
To the best of my knowledge, this should work. What's your result?
Peter A. Sang
SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany
T: +49-201-82020-0 * F:-40 * http://sang.net * mailto:firstname.lastname@example.org
* Microsoft Solution Provider * Intel Systems Integrator *
>Gesendet: Freitag, 13. Juni 1997 17:37
>Betreff: Re: Big Problem with SQL Logs
>>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
>> 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
>> dump database Emerald to disk = '\\DNS1\dns1.cdr\Emerald1.dat' with
>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...:-(
>Will ,,,=^. .^=,,,
>* "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:email@example.com*
> Emerald Mailing List firstname.lastname@example.org