Administration Functions and Tools › Archiving and Purging Historical Data › Archive the Data › Archive the Data in SQL Server 2008

Archive the Data in SQL Server 2008

This section describes archiving the data in SQL Server 2008.

Note: We recommend that you use MS SQL Server Management Studio to execute the stored procedure.

Follow these steps:

1. Log in to MDB as usm_user or sa using MS SQL Server Management Studio.
2. Click New Query and enter the following in the new query window.
3. Replace <…> tags with the required data.

   USE [<mdb instance name>]
   GO
   DECLARE	@return_value int
   EXEC	@return_value = [dbo].[usm_sp_archive_data]
   		@p_object_type = N'< Object Type >',
   		@p_date = N'<Completion Date on or before - yyyy-mm-dd>',
   		@p_bu = N'<Business Unit>'
   
   SELECT	'Return Value' = @return_value
   GO
   

   MDB Instance Name

   Specifies the MDB instance name that CA Service Catalog uses.

   Object Type

   Specifies the type of objects you want to archive and purge. Following object types are supported:

   Request

   Specifies that requests that are in completed status and related data (including audit data) is archived or purged

   Audit

   Specifies that audit entries for all the objects are archived or purged.

   Completion Date on or before – yyyy-mm-dd

   Specifies that only requests that are completed on or before the specified date are to be archived or purged.

   Business Unit

   Specifies the business unit whose records you want to archive or purge.

4. Click Execute.

   The result is displayed in the Messages tab.

   On successful completion of the stored procedure, the data is archived.