hope this is querying AD.

we dont have access.

simon.murin (4/17/2013)

Just a note - a SQL Server database...

yes but DBCC SHRINKFILE (1) will shrink the data file - avoid this

Truncate log will break the backup chain.

in order to create a new chain you have to start with a full backup and then proceeded by log backups.

do remember once the...

shrinking the log - Bad option.

file will grow again to the size it required.

Is it that space crunch?

thanks again gail.

thanks gail

hope i understand that we cant do through sql.

any suggestions?

Hello,

Forgot to mention we (our team) dont have access to do that.

is there a way to indentify the state and alert.

Hello,

Is your windows account locked or password expired?

if you dont want the log keep the DB in Simple recovery.

why are you switching it to simple and full.

is this simple but if you dont have full backup you...

while select * , just try to trace the query and see how IO performs.

try moving (copy) the table to another DB which is on another drive and check performance...

Are referring to SQL agent failover? yes.

I accept Jonathan's comments check the security part.

look at the failed jobs and look at the other jobs which runs around the same time. take running time also into consideration.

can you post more details like what is...