Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transaction log too big
Message
From
26/08/2004 10:29:17
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
To
25/08/2004 06:41:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00936130
Message ID:
00936602
Views:
18
>Dragan,
>
>Shrinking transaction logs can be quite tricky. Try if the following sproc helps you. You'll need to replace the references to the db and log.
>Good luck!

Luckily, I didn't need any of such heavy artillery, just needed to log in as admin. The {insert expletive at will} SQL server, namely the Enter Prize Manager (misspelling intentional) should have had the courtesy to let me know my rights. Instead, it just did nothing but reported success. Did so seven times... which made me suspicious after a while :).

And isn't the syntax just great? To truncate log, you have to backup log, which doesn't actually create any backups. Eugene Ionesco would have made such a lovely absurd comedy using this syntax...

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform