Re: [sap-basis] Transaction log grows too much on client copy
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Maria Valdes on Aug 2 at 2:06 PM |  Mark 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!
__.____._ 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
Related Content
In the Spotlight
White Papers
In the Spotlight
SAP Enterprise Software: flexible, best-of-breed business 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
_.____.__ 
