Skip to Content
avatar image
Former Member

Client copy on Windows based server with Mssql

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Feb 07, 2008 at 04:34 PM

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

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 07, 2008 at 04:16 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 22, 2008 at 05:51 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Ramesh Thalluru

      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 ????