If we take the database offline without resolve (Without run the dbcc check db allow repairdataloss) the issue. Does it still generates the dump files?

Even when I run

DBCC CHECKDB ('DBNAME', NOINDEX)

I am getting the same errors.

How to fix this issue?

I saw

Initializing

Applied script 'Table1_120'.pre

.....

....

...

Applied script 'Table20_1.sch'

....

Applied Script 'Table1_120.sch'

Bulk copying data into table 'Table1'

Bulk Copying data into table 'Table1' (9rows)

Thank you

Need help an example of

How to schedule weekly backup through windows scheduler tasks. No Sql server agent is available

But when I run

dbcc opentran

The results are nothing

Currently we don't have any scheduled full backups. We don't have sql agent.

So assuming with full back we can control the log size.

Yes.

I added the fulltextsearch feature to the installation. I have some full text indexes in publisher database. The fulltextcataloge is created manually in subscriber server.

Under the articles when I tried...

Thanks everyone

I am little confused here.

Database is size is only .mdf file size. I thought free space is available means it tells us the free space available in the data...

so if the datafile size is higher than database size i.e. there is more unused space right? What is the use of that unused space

I think extended events are available in enterprise edition only. We are using standard

I took the snapshot when I click on replication monitor

I can see so many errors from distributor to subscriber

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view...

How to find out what caused the log to grow

Is there any way

I use the query

SELECT [text], cp.size_in_bytes, plan_handle

FROM sys.dm_exec_cached_plans AS cp

CROSS APPLY sys.dm_exec_sql_text(plan_handle)

WHERE cp.cacheobjtype = N'Compiled Plan'

AND cp.objtype = N'Adhoc'

AND cp.usecounts = 1

ORDER BY cp.size_in_bytes DESC;

DBCC FREEPROCCACHE(plan_handle)

and clear the cache....