If the recovery model is in bulk mode then the size of the tran log backups will be smaller compare to full especially when log is being dumped during some...

Enterprise manager->Management->SQL Server Agent-> jobs->Right click on the job->properties->general tab->Owner drop down....

thx,

krishnan kaniappan

You can look at DBCC INDEXDEFRAG.It is an online operation and it does not hold locks long term and thus will not block running queries.

And then u can rebuild...

the log files are used for disaster recovery ,recovery of individual transaction or for recovery for all all incomplete transactions when sql server is started.

Point in time failure recovery... Log shipping to...

check the SQL Agent is running and verify the restore jobs on destination and if it missed to ship the log  then try to manually restore the log files.

thx,

krishnan kaniappan

Can you post the dbcc showcontig info for the table..

And also the structure of the table and indexes in it..

Thx,

krishnan kaniappan

You can look at DBCC INDEXDEFRAG.It is an online operation and it does not hold locks long term and thus will not block running queries.

And then u can rebuild the...

Since the db is in simple mode that should keep transaction log files size in check..

If u see lot of free space in the data files and uneed to release...

the object might have been dropped...

Thx,

Krishnan Kaniapapn

start the job and query the sysprocesses table and see whether it has been blocked by another process and also can you post the output file details for the job...that...

move the rows into temp table where ticketid=301068226

delete from the ticket table where ticketid=301068226

Insert the row which u want in the table...

-krishnan