Re: Big Problem with SQL Logs

Will LaSala ( will@greennet.net )
Wed, 18 Jun 1997 11:15:05 -0400

Ok
Since I don't have an share called test
I used a different machine that I was sure I had permissions on
here's what I used
dump database Emerald to disk = '\\Web\Web.ddr\Emerald1.dat' with init,
stats=5
Here's what I got back
Msg 3201, Level 16, State 1
Can't open dump device '\\Web\Web.ddr\Emerald1.dat', device error or device
off line. Please consult the SQL Server error log for more details.

We're still stuck now I can't get Emerald to even save the database is tooo
ful...:-(

Thanks
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*
*===============================================*
----
From: Peter A. Sang <pesa@sang.de>
To: 'emerald@emerald.iea.com'
Date: Saturday, June 14, 1997 8:01 AM
Subject: AW: Big Problem with SQL Logs

>OK, seems like Step 1+2 worked. Your Transaction log should be almost
>empty now, correct?
>
>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
>>
>>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>