CheckDB really reads and writes some information in log file. but it should not cause big log growth.

I faced same situation some years back. JOb would take 2 hours where as ssms run it just 20 minutes.

I used sqlcmd, it was fine, took just 20 minutes.

I believe...

Alter Server State.. Try this permission.

The login that is running the backup script has enough permission for missing databases?

Any of the database are in restoring mode?

Please post your script to analyse.

What kind of performance problem you are facing? like low memory, huge IO, CPU hike, blocking, deadlocks? Before going for...

are you using 32 bit? can you post the error message you received?

Are Primary and Secondary server in different time zone?

SQL Addict (5/8/2013)

---

but when I tried to access data through login from which linked server is configured it is giving me login failed for user error.

This login has created in...

What is the auto growth of your lDF file?

I am about to blame the number of VLF files in your database. Your Purge might be adding lots of small sized...

A couple of websites can help you.

http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx

http://sqlserver.in/blog/index.php/archive/database-mirroring-step-by-step/

http://technet.microsoft.com/en-us/library/ms189852.aspx

Can you check your error log for IO take longer duration warning message?

if your have sql 2008 or newer version, then

CREATE EVENT SESSION [Monitor Update Stats ] ON SERVER

ADD EVENT sqlserver.sql_statement_completed(

ACTION(sqlos.task_time,sqlserver.database_id,sqlserver.database_name,sqlserver.sql_text,sqlserver.transaction_sequence,

sqlserver.tsql_frame,sqlserver.tsql_stack)

WHERE ([sqlserver].[like_i_sql_unicode_string]([sqlserver].[sql_text],N'%update%statistics%')))

ADD TARGET package0.event_file(SET filename=N'd:\Monitor Update Stats .xel')

WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30...

Correct me if am wrong. If backup never taken, then db will go...

I had the same problem few years back, no space in ldf drive. But users were able to logon. We received error only when try to run dml statements.

Yep, I was wrong 🙂