Viewing 6 posts - 16 through 21 (of 21 total)
learning_sql (11/26/2012) Does the domain account have "permission to logon as a service" rights on the server?
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
#1562199
Thanks all !!!
Running a 2nd backup and then a shrink in EM worked a treat 🙂
virtual 119.3672 11.94245
August 30, 2012 at 5:12 am
#1531799
select name, log_reuse_wait_desc from sys.databases
master NOTHING
tempdb ACTIVE_TRANSACTION
model LOG_BACKUP
msdb NOTHING
virtual LOG_BACKUP
vmum NOTHING
I've...
August 30, 2012 at 4:31 am
#1531781
DBCC OPENTRAN returns no clues
No active open transactions.
August 30, 2012 at 3:45 am
#1531771
Interestingly the %used was pretty high @ 92.6%
virtual 64481.87 92.59304
August 30, 2012 at 3:32 am
#1531764
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
#1531759