enrique_aeo

<div>
Hello,<br />
<br />
Execute the following commands to validate the integrity of the database and its tables and please indicate the results, attachment reference link.<br />
<br />
<a href="https://docs.microsoft.com/es-es/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql" rel="ugc">https://docs.microsoft.com/es-es/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql</a><br />
<br />
I remain attentive to your comments.<br />
<br />
regards..
</div>


<div>
hi experts<br />
<br />
What files can I delete to decrease the disk size?
</div>


<div>
Can I delete the dump files?
</div>


<div>
The files . mdmp are being saved in the Log folder of Disk C where SQL Server C: \ Program Files \ Microsoft SQL Server \ MSSQL13.POSEIDON \ MSSQL \ Log is installed, the .mdmp files are equal to the dump file I think, when you I right click on a dump file and see its properties, its extension is .mdmp<br />
<br />
On the C disk the mdf and ldf files of the databases are not being saved, on the C disk there are only the installation folders and the 223 GB weight of the log referred to the Log of the installation folder C: \ Program Files \ Microsoft SQL Server \ MSSQL13.POSEIDON \ MSSQL \ Log and it's just so heavy because every day a lot of Dump files are being generated<br />
<br />
&nbsp;On the other hand, we do not have visible problems with the bd server, everything works fine, it does not fall or anything, that's why I wanted to know why so many dump files are being generated daily or how could I identify what is happening to solve it? that eliminates the dump files and frees a little space, in a few days it is full again.
</div>


<div>
<div class="content wysiwyg-content">
I have been reviewing a database server that we have here and I see that Disk C, where the SQL Server is installed, is with 0 bytes available.<br />
<br />
I have navigated through all the folders and I have noticed that the &quot;Log&quot; folder weighs 223 GB and inside that folder there are thousands of dump .mdmp files, I know that the dump files are generated when there is a problem in the server, so I started to find out on the internet and in a forum they mentioned that it could be that a database is corrupt, so I consulted the table sys.messages and found a suspicious error:<br />
<br />
&quot;An inconsistency was detected during an internal operation in database '%. * Ls' (ID:% d) on page% S_PGID. Please contact technical support.&quot; with the code 5242,<br />
<br />
On the internet they mention that this error code indicates database corruption but in the message they do not detail what database it is.<br />
<br />
So I started to run a DBCC CHECKDB to all databases and all are fine, the CHECKDB does not find any error<br />
<br />
what should I do?
</div>
</div>


I have been reviewing a database server that we have here and I see that Disk C, where the SQL Server is installed, is with 0 bytes available.

I have navigated through all the folders and I have noticed that the "Log" folder weighs 223 GB and inside that folder there are thousands of dump .mdmp files, I know that the dump files are generated when there is a problem in the server, so I started to find out on the internet and in a forum they mentioned that it could be that a database is corrupt, so I consulted the table sys.messages and found a suspicious error:

"An inconsistency was detected during an internal operation in database '%. * Ls' (ID:% d) on page% S_PGID. Please contact technical support." with the code 5242,

On the internet they mention that this error code indicates database corruption but in the message they do not detail what database it is.

So I started to run a DBCC CHECKDB to all databases and all are fine, the CHECKDB does not find any error

what should I do?

the file log filled the disk

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.