Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Runaway transaction log
Message
From
04/10/2000 11:36:04
 
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00424480
Message ID:
00424777
Views:
20
>You didn't say the version of SQL Server but for 7 look up DBCC SHRINKFILE.
>
>The trick is that the active virtual log has to be towards the front. You can use DBCC LOGINFO to view the virtual logs. Look for a two in the status column. That will be the active virtual log.
>
>-Mike

yep - it's 7 - thanks Mike - it'll be a day or two before I can look at it again, but I'll give it a try.

Thanks,
Ken B. Matson
GCom2 Solutions
Previous
Reply
Map
View

Click here to load this message in the networking platform