I use CTE's to accomplish these type of delete and or archive tasks.

For example:

WITH AuditRecordsToArchiveTop10000 AS (

SELECT TOP 10000 *

...

xp_cmdshell 'systeminfo /S MyServerName'

The decryption process with gpg and ssis is on this site:

http://codingstuffs.blogspot.com/2007/03/pgp-inside-ssis-package.html

--recipient "YOUR-NAME" --output "C:\A_20081023.zip.gpg"

--encrypt "C:\A_20081023.zip"

If using GPG remember to look at the syntax here:

http://www.glump.net/dokuwiki/gpg/gpg_intro

Look at this site:

http://codingstuffs.blogspot.com/2007/03/pgp-inside-ssis-package.html

I just posted the article you stated sorry.

Take a look at this article it should answer all of your questions

http://support.microsoft.com/kb/240867/EN-US/

Here's the MS KB for more info if you need it.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546

Your attach statement should look something like this (substitute the drive, directory, and filename for your drive, directory and filename):

In Query analyzer:

use master

go

sp_attach_db 'mydb','E:\Sqldata\mydb.mdf','E:\Sqldata\mydb.ldf'

go

You can also use enterprise manager and...

SQL Server archives your errorlogs every time you stop/start SQL server or when you issue the sp_cycle_errorlog command. Within these errorlogs (by default there are 6) you will see an...

Take a look at this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;304101

Look at these articles:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;187370

http://p2p.wrox.com/archive/sql_server_admin/2002-01/1.asp

Create a job with the SQL Server Agent. See BOL for more info on how to create jobs.

It's known to happen. You may want to try this to get them back:

1. At the command prompt, type in the following: unlodctr.exe MSSQLServer

2. Then...

Take a look at the sp_fulltext_catalog sproc in BOL. This should answer your question.