dump database Emerald to disk =
'\\YourSQLserverName\YourShareOnThisVeryMachine\EmeraldDump1.dat' with
>init, stats=5
What happens now?
With the commands I told some days ago your TL should be almost empty.
So you should be able to save new records...
-
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 *
>----------
>From: will@greennet.net[SMTP:will@greennet.net]
>Reply To: emerald@emerald.iea.com
>Sent: Mittwoch, 18. Juni 1997 17:15
>To: emerald@emerald.iea.com
>Subject: Re: Big Problem with SQL Logs
>
>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
>>
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>