krotparts.blogg.se - Sql management studio download table without quotes

#Sql management studio download table without quotes how to#
#Sql management studio download table without quotes free#

Paste this query into the query window:Įxec SP_Task_PurgeTaskLogOlderThan 'mm-dd-yyyyy'.Open a query window, and select the ePO database.Purge the server task log entries older than a specified time frame: This solution applies if you need to remove data from the following tables:

#Sql management studio download table without quotes how to#

KB92098 - How to purge large amounts of event data from ePolicy Orchestrator using an SQL query – Use this article if you need to purge threat event data based on criteria other than EventID.

KB68961 - How to find the top 10 threat events and purge events – Use this article to purge threat event data based on a specific EventID, which is filling up the database.

The following articles provide detailed instructions on how to purge threat event data using a direct SQL query: This solution applies if you need to remove data from the following tables: But you typically don’t need to shrink the database.

To reduce the database size, you need to shrink the database. But, this action doesn’t actually reduce the size of the database file on the storage solution.

#Sql management studio download table without quotes free#

Based on the results of the script, you can purge data using one of the appropriate solutions below.Īfter you purge the data from the relevant tables, the database has more free space.

NOTE: If you’re using ePO 5.10, you must run this script against both ePO databases. The script lists the tables by size in desending order:

How much space in megabytes each table takes up.

Run the following script, and analyze the results.

Use SQL Server Management Studio to open a query window, and select the ePO database.

You can query the ePO database directly to determine the largest tables using the following steps: If your ePO database is large and you need to reduce the size, determine which tables you need to purge.įor help with the steps below, see KB67591 - How to run a SQL script provided by Technical Support against the ePolicy Orchestrator database.

This article must be followed only if you can't purge the data using the database maintenance tasks provided in the ePO console. If you have access to the ePO console, we highly recommend that you purge data from your ePO database.įor details, see related article KB79561 - How to purge data from the ePO database using the ePO console.