MSSQL DB compression

[Former Member]

Hi Friends,

As per client requirement yesterday we upgraded my data base from mssql2005 to mssql 2008r2.

Now my SAP server is up and running , i want to know below topics clearly .

1) After upgrade mssql 2008r2, where can i check my upgrade is done successfully or not.

2) We want to compress my db size using msscompress

Please give me the steps with detailed information,

Please let me know with full details , this is the urgent requirement for me

Thanks

[Reagan]

1) After upgrade mssql 2008r2, where can i check my upgrade is done successfully or not.

Perform standard checks on SAP and check DB using Tx's related to DB.

2) We want to compress my db size using msscompress

Read these SAP notes.

1488135 - Database compression for SQL Server

1459005 - Enabling index compression for SQL Server

Regards

RN

[Former Member]

Hi,

Please check the below note.

1488135 - Database compression for SQL Server

1744217 - MSSQL: Improving the database performance

Thanks

Rishi abrol

[Former Member]

Hello Koteswara,

Below link has the steps to compress the DB tables in MSSQL.

Check the link  http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/50c5de8f-282a-2e10-cb8a-a5859a099...

Regards,

Mudasir