did you check database log size before the backup ?

instead of only once in day,you should configure log backup to execute frequently,say every hour depending of your database size

Clustered index defines physical order of your data .

Please go through the link I provided in last post .

SQL server do not give the estimated time required to complete this...

Do you mean Clustered Index ?

http://www.sqlservercentral.com/stairway/72399/

i'm still finding meaning of the status no,

Seems there is no information about it on Microsoft document

if Auto_close is False, Sql server just...

did you try this ?

Alter database DB_Name set online

did you try to make it online ?

Alter Database DBNAME set online

also what is the status of the DB

select * from sys.sysdatabases where name = 'DB NAME'

did you checked...

It will not get bigger ,if you have maintenance plan for regular backup log.

but at least...

i'm Sure there must be something in error log or atleast in Event Viewer logs.

Reason may be any long transaction got interrupted due to network problem .

Also check ,Auto_close option...

No, Please check the attachement

right click on server connection

>properties

>Processor

Yes Please 🙂

chetan.aegis (12/6/2012)

---

When data is inserted in table a clustered index determines the physical order of data in a table.because the clustered index dedicated the physical storage order of the data...

did you check SQL server agent logs ?

check SQLAGENT.OUT files in your '\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log' directory

what is their in Windows Event log ?