Objective
![Dump Dump](/uploads/1/2/6/5/126553277/818974207.jpg)
Procedure
![Sql Sql](/uploads/1/2/6/5/126553277/258133151.png)
Oracle Database removes the directory object but does not delete the associated operating system directory on the server file system. Dropping a Directory: Example. The following statement drops the directory object bfiledir: DROP DIRECTORY bfiledir.
The SQL DELETE Statement The DELETE statement is used to delete existing records in a table. Oct 19, 2011 We just had our SQL Server crash last week with a Crash dump generated, a bit about the Environment (This is a multi instance Environment) Server OS: Windows 2008 R2 Enterprise,64 bit Memory: 256 GB SQL Server: 2008 R2 Enterprise Edition Max Server Memory: 60 GB Processor Count: 16. The easy answer comes by reading the file. It's a text file, not binary, so you should be able to glean what it is by just opening it up in Wordpad (Notepad can't open such large files). http://www.guzhongdiman1975.simpsite.nl/transmission-downloads-for-mac. More than likely it's a complete dump of all the data in the database, in one big SQL query. Dumps indicate that something is not working as expected in SQL Server and forcing SQL to either terminate the process or terminate itself. Each dump had three files generated. Out of them text and log were readable, but mdmp needs a special tool (windows debugger) to read it. Here is what I saw in the files which were readable.
AlarmODBC service continues logging alarms and events into SQL database. The size of database file (.mdf) and its transaction log file (.ldf) will grow over time. How to periodically purge old records from the database and dump the transaction log so that the database file and its transaction log file keep compact?![Dump Dump](/uploads/1/2/6/5/126553277/818974207.jpg)
Procedure
Delete Sql Dump Files Delete
A SQL Server Agent job can be created to delete old records in the database, then shrink the transaction log file (.ldf) and database file (.mdf). This SQL Server Agent job can be scheduled to run every day. Refer to the following steps:- Make sure SQL Server Agent service is running. Launch SQL Server Management Studio, create a new job under 'SQL Server Agent --> Jobs'.
- Set the name of job to something like 'PurgeFixAlarms'. Assume the name of SQL database used by AlarmODBC service is 'iFix'. On 'Steps' tab, create the first Step like the following. The code below deletes those records that were created 90 days ago.
![Sql Sql](/uploads/1/2/6/5/126553277/258133151.png)
- Create the second step in this job like the following. Note, the following code assumes the SQL database name is 'iFix' and its transaction log file is 'iFix_log.ldf'.
- Create the third step in this job:
- On 'Schedules' tab for this job, create a new schedule for this job and configure the schedule to occur at a specific time every day, say 12:00:00 AM every day.