Viewing 6 posts - 16 through 22 (of 22 total)
learning_sql (11/26/2012)
Does the domain account have "permission to logon as a service" rights on the server?
Yes it does - just double checked it in user rights assignment in local policies...
November 26, 2012 at 6:51 am
Thanks all !!!
Running a 2nd backup and then a shrink in EM worked a treat 🙂
virtual119.367211.94245
August 30, 2012 at 5:12 am
select name, log_reuse_wait_desc from sys.databases
masterNOTHING
tempdbACTIVE_TRANSACTION
model LOG_BACKUP
msdb NOTHING
virtualLOG_BACKUP
vmum NOTHING
I've...
August 30, 2012 at 4:31 am
DBCC OPENTRAN returns no clues
No active open transactions.
August 30, 2012 at 3:45 am
Interestingly the %used was pretty high @ 92.6%
virtual64481.8792.59304
August 30, 2012 at 3:32 am
It doesn't seem to be reducing in size just growing..
The only reason i noticed it is the DB it logs for is only 2Gb in size so appears rather huge...
August 30, 2012 at 3:17 am
Viewing 6 posts - 16 through 22 (of 22 total)