RE: [sap-basis] Transaction log grows too much on client copy
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Lars-Erik Hallsten (CEO & Senior Consultant) on Aug 2 at 3:33 PM |  Mark as helpful |
Hi,
If you remove the autogrow property and set the log in simple mode, it
shouldn't grow past the point set as max size. It will auto truncate the
log.
I'm sure you are aware of it, but I just want to mention it, anyway. It's
not a good idea to have DEV and QA in same system as different clients.
There are quite a lot of client independent customizing and settings in a
SAP system that will be active in all clients when activated in one client.
In your case I think client copy might be the best solution, but do you
REALLY want all the productive data in your DEV/QA system? Be sure to
maintain the proper authorization for the users in the client containg this
data.
Also make sure that no users are logged on and no data is processed in PROD
during the copy/export (that includes batch jobs).
Regards,
LEH
From: Maria Valdes via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 2. august 2009 16:59
To: Lars-Erik Hallsten
Subject: Re: [sap-basis] Transaction log grows too much on client copy
Posted by Maria Valdes
on Aug 2 at 2:06 PM
<http://it.toolbox.com/api/ContentVote/2911612/1/1/> Mark this reply as
helpfulMark as helpful
Toolbox sap-basisIt's a 2 system landscape, PRD and DEV, DEV has two clients
and I'm trying to copy PRD to one of those clients that acts as quality
assurance system.
I've already tried putting database on simple mode recovery but the log grew
anyway. The log file is on autogrow I don't know if removing that property
would make the log not to grow with the combination of a simple recovery
mode.
The size of the productive system is about 100GB and the export transport is
about 4 GB.
Thanks for your help.
From: Lars-Erik Hallsten via sap-basis
Sent: Sunday, August 02, 2009 9:44 AM
To: Maria Valdes
Subject: RE: [sap-basis] Transaction log grows too much on client copy
Posted by Lars-Erik Hallsten (CEO & Senior Consultant)
on Aug 2 at 10:36 AM Mark as helpful
Hi,
The same amount of data is copied during client import as during remote
copy, so the log will grow equally large.
However, you can turn of the logs by setting it to simple mode. Just be sure
to reset it after the copy and perform a full backup.
If a system copy is a better solution depends on your needs. You'll have to
tell us more details about your system for us to help you decide.
For instance, what are the source and target systems? How many clients do
you have in the source/traget systems? And so on...
Regards,
LEH
From: Maria Valdes via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 2. august 2009 15:56
To: Lars-Erik Hallsten
Subject: [sap-basis] Transaction log grows too much on client copy
Posted by Maria Valdes
on Aug 2 at 10:22 AM
Hello,
I'm performing a client export/import ECC 5 on SQl Server 2000.
When starting import on target client runs for some hours and then the
transaction log gets full and stops the import.
If I choose to do a Remote Client copy will the log grow less? Or should I
expect the same problem?
Would it be best to make a system copy?
Thanks in advance!
__.____._ If you remove the autogrow property and set the log in simple mode, it
shouldn't grow past the point set as max size. It will auto truncate the
log.
I'm sure you are aware of it, but I just want to mention it, anyway. It's
not a good idea to have DEV and QA in same system as different clients.
There are quite a lot of client independent customizing and settings in a
SAP system that will be active in all clients when activated in one client.
In your case I think client copy might be the best solution, but do you
REALLY want all the productive data in your DEV/QA system? Be sure to
maintain the proper authorization for the users in the client containg this
data.
Also make sure that no users are logged on and no data is processed in PROD
during the copy/export (that includes batch jobs).
Regards,
LEH
From: Maria Valdes via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 2. august 2009 16:59
To: Lars-Erik Hallsten
Subject: Re: [sap-basis] Transaction log grows too much on client copy
Posted by Maria Valdes
on Aug 2 at 2:06 PM
<http://it.toolbox.com/api/ContentVote/2911612/1/1/> Mark this reply as
helpfulMark as helpful
Toolbox sap-basisIt's a 2 system landscape, PRD and DEV, DEV has two clients
and I'm trying to copy PRD to one of those clients that acts as quality
assurance system.
I've already tried putting database on simple mode recovery but the log grew
anyway. The log file is on autogrow I don't know if removing that property
would make the log not to grow with the combination of a simple recovery
mode.
The size of the productive system is about 100GB and the export transport is
about 4 GB.
Thanks for your help.
From: Lars-Erik Hallsten via sap-basis
Sent: Sunday, August 02, 2009 9:44 AM
To: Maria Valdes
Subject: RE: [sap-basis] Transaction log grows too much on client copy
Posted by Lars-Erik Hallsten (CEO & Senior Consultant)
on Aug 2 at 10:36 AM Mark as helpful
Hi,
The same amount of data is copied during client import as during remote
copy, so the log will grow equally large.
However, you can turn of the logs by setting it to simple mode. Just be sure
to reset it after the copy and perform a full backup.
If a system copy is a better solution depends on your needs. You'll have to
tell us more details about your system for us to help you decide.
For instance, what are the source and target systems? How many clients do
you have in the source/traget systems? And so on...
Regards,
LEH
From: Maria Valdes via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 2. august 2009 15:56
To: Lars-Erik Hallsten
Subject: [sap-basis] Transaction log grows too much on client copy
Posted by Maria Valdes
on Aug 2 at 10:22 AM
Hello,
I'm performing a client export/import ECC 5 on SQl Server 2000.
When starting import on target client runs for some hours and then the
transaction log gets full and stops the import.
If I choose to do a Remote Client copy will the log grow less? Or should I
expect the same problem?
Would it be best to make a system copy?
Thanks in advance!
Copyright © 2009 CEB Toolbox, Inc. and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Lars-Erik HallstenSAP Basis Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Centrify: centrally secure cross-platform systems & web apps View Vendor Profile
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
