DATABASE Size seems to be double after completing the system copy in windows with ms Sql server environement

[Former Member]

Hi Experts,

Recently we have done the system copy in the SAP ECC6.0 environment  ( windows with MS SQLSERVER).  production is our source system and quality is the target system and it is in the dual stack.(ABAP+JAVA). After completing the activity ,we didn't noticed that it is not overwrite schema's and table,s instead all the table content was added with database. now the DB size shows double time of PRD ( ie qas 105 + prd 110 = 225). Kindly help me to resolve.

Thanks in Advance .

Paranthaman

[Matt_Fraser]

Hi Paranthaman,

Did you use the database-dependent method of system copy?  Even so, it should have overwritten your QAS schemas, not just added to them.  However, for SQL Server, this method of system copy is not the primary recommendation.  For now, you can probably fix it as Martina suggests, but next time I highly recommend that you use the database-independent (aka detach/attach, or backup/restore) method of system copy for SQL Server.  It is faster, and it does not result in this kind of problem.  It works for both ABAP and Java stacks (and dual-stack), though since you are operating in a dual-stack environment, you must be certain to follow the instructions from the ABAP+Java system copy guide.  With this method, your database will be copied by restoring a backup from production over your QAS database (overwriting it completely in the process), and your Java system will be exported and them imported using the SWPM tool. 

Regards,

Matt

[Martina_Gállego]

Hi Paranthaman,

I think you should have deleted the quality database before the system copy.

You can try deleting now qas + prd database in quality system and starting again the system copy.

Best regards,

Martina

[Former Member]

Hi Martina,

Thanks for your reply. the system is working fine now. but i want remove the data from the database related to the old schema.

Regards,

Paranthaman

[Martina_Gállego]

Hi Paranthaman,

Try this:

DROP SCHEMA schema_name

DROP SCHEMA qas

http://technet.microsoft.com/es-es/library/ms186751.aspx

Hope this helps.

Best regards,

Martina

[Sriram2009]

Hi Paran

1.  Could you share the version details of you SAP system & OS / DB  ?

2. On both system Transaction code ST04 screen shots

Regards

Sriram