Viewing 2 posts - 1 through 2 (of 2 total)
As per my opinion, we have two kinds of logins
1) local computer logins
2) sql server logins
So according to given scenario we are totally logged out of sql server logins...
March 17, 2011 at 12:43 am
#1299803
use DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
Try to look if any maintenance jobs are going on and affecting the t log....
March 16, 2011 at 9:29 pm
#1299774