Thanks it is useful to list some of the stuff, could you please assist with syntax with which I can pull all SQL and Windows User Accounts,

Thanks,

Bubby

Thanks a Lot, it helped to understand, much appreciated,

The drive is getting almost max due to that, How to troubleshoot please? can I be assisted with some queries please

I am not exporting the data, I am trying to run the query and want to save the results as csv files with headers, the data is huge

How long will be the run?

No

Thanks,

I would I see if my SQL is optimized,

Can I get a link please

Public please

Issue: XYZ database (log) size was growing very fast, after any maintenance task was carried such as indexing or shrink log file,

Problem: The Size would grow out of control

Resolution: Following...

Thanks

can I get a syntax to check the data file size and log file size please,

How to fix it please?

NOTHING

CHECKPOINT

LOG_BACKUP

NOTHING

REPLICATION

NOTHING

CHECKPOINT

NOTHING

NOTHING

REPLICATION

REPLICATION

This is the result I get, when I try this,

SELECT name

FROM sys.database_files

WHERE type_desc = 'LOG'

DBCC SHRINKFILE ('XYZ_Log', 1000)

DBCC SHRINKFILE(XYZ_Log)

size keep on growing

How to do that? I have no replication set up, I do not see any Local Publications,