Yes, when you are deploying dts to production if you need to redo mapping of columns.

What will happen to the existing tables in the .mdf when I will add data to them?

SQL writes new data to .ndf and .mdf file until .mdf file gets full.

If .mdf...

DBCC INDEXDEFRAG increased log bigger than db reindex...

Check if there is any maintenance plan running for the db or REINDEX/INDEXDEFRAG  job is running... OR it could be a big data...

I resolved this many times in my place with the method which I explained...

If you don't need need temp table at all then you can get rid of it..

During a full database or differential backup, Microsoft SQL Server backs up enough of the transaction log to produce a consistent database for when the database is restored.

All changes...

A description of the 4 GB RAM Tuning feature and the Physical Address Extension switch

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

SAN backups freez the db befor it takes the snap of the db files and later normalizes...

Always sql native backups are more reliable...If you make backups faster and the backup...

Use Global temp table (##)...

Create a ## global temp table in QA, without closing the QA window you have to create the dts package....

Once the dts package creation completed you can...

Is file size is managible by winrar command?

May be sql didn't get the returned aknowledgement when it is completed...

Try executing the bat file using xp_cmdshell command see what you get...or...

For all the steps you explained  create a SSIS package and Schedule it as sql job to run as you needed....

select

distinct object_name(id) from syscomments where text...

When the recovery model is SIMPLE if you enable SELECT INTO... it will not change the recovery model... it changes the only option...

where as when the recovery model FULL if...

If you are running SELECT INTO statement to populate the table it will not change the recovery model...

If you change the db option to "SELECT INTO/BULKCOPY" usigng alter database statement or...

There is no simple way to validate...

It is OK to validate the name of the column...but first read the "Rules for Regular Identifiers" in BOL to validate the names...

Rules for...

You can't get rid of a page...either checktable should remove or copy the data to new table and delete the problematic table to resolve this page issue