We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] Reorg Database in SAP

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from MBI28 on Feb 7 at 6:29 AM
Hi Guys,

Regarding my last issue, I thought that this is already solved? Can I ask you a very important question again? I do a system copy r3load base in abap only ( create export file and import thru system r2load base, but the question is how about if I want to do a system copy in one of our server having dual stack abap + java at the same time we want to freed also the space, did i do the same thing like when backing up the abap only? or correct me if I'm wrong..

Using dual stack


SOURCE
1. Generate smigr_create_ddl ( what can i do if no generated files, i thought this is ok if abap only not in abap + java so require to have a generated file )
2. Stop SAP MMC
3. Export Preparation now for abap + java
4. Database instance export.

TARGET
1. Target abap + java
2. Standard system copy/ Migration ( load Based )

My goal here is to free up and reclaim free space.

Please guide me with this guys.

Thanks a lot

---------------Original Message---------------
From: MBI28
Sent: Wednesday, February 05, 2014 9:50 AM
Subject: Reorg Database in SAP

Hi Masters,

Please help me with my issue, we are having a production server, and we have plan to reorganize the database due to some issue in sap client (we do a system copy of qas to prd and delete the clients that came from qas but we are notice that our harddrive space will become full ) that's why we plan to reorg the tables, but the question is, it is possible to reorganize " dbcc defrag" our harddrive which is almost 2 TB of data? Any ideas how long could it take to reorg? BTW we try to reorg only 1 table and it takes an hour to reorg, how much long if we run an reorg in all tables? it is possible or not advisable?

DB: SQL Server 2008
OS: Windows Server 2008 Standard

Thanks

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2014 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
MBI28  

achievement
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language