Re: Purge Interchange DTA - HELP!!!

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,

Have you set up the "Backup BizTalk Databases" script? If not, you can truncate the log file:

Open SQL Query editor and issue:

BACKUP LOG BizTalkDtaDB WITH TRUNCATE ONLY

Note that this will truncate the log file of the DB - if your backup strategy relies on it, you are in trouble and should back it up beforehand.

Sincerely

Joerg Fischer
BizTalk MVP

"Ray Mooney" <ray@xxxxxxxxxx> schrieb im Newsbeitrag news:eVGhffcVHHA.488@xxxxxxxxxxxxxxxxxxxxxxx
IMMEDIATE HELP NEEDED!!



My InterchangeDTA database has become so large that the
'dta_purge_old_records' script does not have the space necessary to run.
Apparently SQL creates a transaction_log file as the script processes and
there is just not enough disk space to create the log file.



I am not achieving the DTA data, I just need to delete the records in the
DTA Database. I am running the purge scripts with the following parameters;



dta_purge_old_records 1,24,0,0



The DTA Database has too many tables to go after deleting data within tables
and in researching this I have seen posts that say to not delete individual
table records, you could really screw things up.



ANY HELP WOULD BE GREATLY APPRECIATED!!!!!






.

Relevant Pages

  • Re: How to truncate?
    ... you can't truncate a table that is referenced by any ... Another way would be to script out all the data from the production database ...
    (microsoft.public.sqlserver.programming)
  • RE: Shrink File?
    ... As my understanding of you problem, you have a database with a data file ... in the log file. ... You can truncate only nonactive portion of the transaction log. ...
    (microsoft.public.sqlserver.setup)
  • Re: DB export/Import looses users - SQL7
    ... log file. ... the database before you delete the DB. ... choose "All Tasks" and then "Generate SQL Script". ... >>> transaction log space), all users are dropped, and have ...
    (microsoft.public.sqlserver.security)
  • Re: Get size of Database log file
    ... tables in my database which is set for Simple Recovery Model. ... It worked fine until today and now the script is failing because it is ... I was planning on putting a bunch of print statements in the script to ... Log file as well. ...
    (microsoft.public.sqlserver.programming)
  • Re: Humongous transaction LOG!!!
    ... I did try to truncate but it didn't work. ... This is strange since the size of the backup database is about 20MB. ... I don't think that the actual size of the log file is 17GB, ... you can set the database to Simple Recovery Mode and the updates to ...
    (microsoft.public.sqlserver.server)