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'.
Please try
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?
cu,
-
Peter A. Sang
SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany
T: +49-201-82020-0 * F:-40 * http://sang.net * mailto:pesa@sang.net
* Microsoft Solution Provider * Intel Systems Integrator *
>----------
>Von: will@greennet.net[SMTP:will@greennet.net]
>Gesendet: Freitag, 13. Juni 1997 17:37
>An: emerald@emerald.iea.com
>Betreff: Re: Big Problem with SQL Logs
>
>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
>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*
>*===============================================*
>
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>