so replication is not the reason for the log growth, that what you mean correct

It is showing

XYZ Simple Replication,

Can I get a syntax to change it to CHECKPOINT, as I am not using replication

Currently Allocated 5939.19 MB

Available Free Space 156.59 (2%)

How can I find it, space is at auto growth 10%

My Apologies if anyone felt that way, I have mentioned that there was regular maintenance running, and the log would not grow.

I even stopped the maintenance job, but whenever I...

Nothing was changed, I need help if something can be done, looking for resolution here

Disk is not a problem, but I had this maintenance tasks running before too, size was growing in few mbs now suddenly it has grown crazy, I need to see...

Agreed, but I would I get my size of log low as it is simple database,

Database is 2 gb and the log is 4 gb, every time I shrink log the size of log grows, as mentioned database is simple

Thanks, this query helped me to change it to single user mode,

Regards,

Bubby

any help I am willing to repair it with loosing data even

I backup the database, restored as different name, trying to Run the below statement before I try to run repair script, query is taking for ever to finish, any idea...

Actually I have a corruption in one of the database, when I run DBCC CHECKTABLE I get this,

CHECKDB found 0 allocation errors and 1464 consistency errors in database 'Alloy'.

When I...

Hello Help will be appreciated,

When I try to run repair_allow_data_loss in the particular database it says no stored procedure,

This is the result,

There are 41752 rows in 1155 pages for object...

Replication is not enabled