Client copy on Windows based server with Mssql

[Former Member]

Good morning to everyone

Just trying to get some information on how long does it take to do a client copy with sap_all on Windows base running Sap 4.6c with mssql.

If your database was around 120Gb how long would a client copy take.

Trying to compare this with other hardware.

Thanks

Joe

[markus_doehr2 · Accepted solution]

The easiest way to find that out is to do a test client copy.

Markus

[Former Member]

Joe,

You did not mention it but a local client copy is generally faster than a remote client copy (between difference system) due to crossing the network, etc. Another factor in speed is whether tx logging is on/off. You didn't indicate SQL Server version but in SQL 7.0, you select "Truncate log on checkpoint in the <SID> database options in SQL Enterprise Manager, in SQL 2000 and 2005 you switch to "Simple" Recovery Mode - all of which require SQL Server to be restarted and then SAP started. While tx logging is essentially always on for rollback purposes, as soon as the copy is successful, it truncates the table from the log so that your transaction log doesn't fill. Don't forget to revert your changes after the copy and restart accordingly.

As others have mentioned, your specific hardware, disk layout and overall system set-up make guessing too difficult but generally 3-5 hours for 120GB would be about right. Also check OSS note 552711 for Client Copy FAQ

Regards,

Ken S.

[former_member193399]

You don't have to restart either SQL Server or SAP when you change the database "Recovery Model" in SQL Server 2000/2005.

[Former Member]

is it possible to change the recovery mode from FULL to SIMPLE while a client copy is going on ??

if not what are the options after starting the client copy ?

what if there is the limit in the max LOG size set ????

[Former Member]

Joe,

Even on different platform it depends not just on the size of the database alone:

1. Size of the database

2. system activity during client copy (let's say you have more clients)

3. system configuration

On a HP system with Oracle, other clients being used and close to 120 GB (occupied size and not actual size) took around 5hrs.

Thanks

BMG