Skip to Content
0

Data Base Partition

Dec 18, 2016 at 07:08 AM

66

avatar image
Former Member

Dear Experts,

Is it possible to divide a single DB in to four parts based on the years.

Using the DB from 2005 now want to create a DB with only last two years data

SAP Version 8.8 Patch Level 20

SQL Sevrer Version 2008

Regards,

Karthik B

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Johan Hakkesteegt Dec 19, 2016 at 07:48 AM
0

Hi Karthik B,

It might be better to use the Data Archive Wizard (Administration > Utilities > Data Archive Wizard). This tool will delete all data older than two or more years.

All data older than what you retain you can keep in a database on another server or hard disk (just restore a backup to a new database).

Regards,

Johan

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you for the help

Regards,

Karthik B

0