Skip to Content
avatar image
Former Member

SQL queries

Hi ,

a)Can we do SAP Installation with any Id other than administrator in Windows ..but the Id has been added in the administrator group and having admin rights

b)Is it possible to mirror the translog files of SQL 2008 during installation in a separate drive. like in Oracle..If so How to do it.

c) What is the size required for translog for Installation

I would appreciate your help

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 06, 2010 at 06:31 AM

    >

    > Hi ,

    >

    > a)Can we do SAP Installation with any Id other than administrator in Windows ..but the Id has been added in the administrator group and having admin rights

    >

    You just need a user with local administrator rights for the installation. If you are performing a domain installation either the installation user should have domain admin rights or your domain administrator should prepare the required user/group accounts as per the installation guide

    > b)Is it possible to mirror the translog files of SQL 2008 during installation in a separate drive. like in Oracle..If so How to do it.

    >

    No. You can configure more than one log files but not as mirror.

    > c) What is the size required for translog for Installation

    >

    Use the default value for the installation and then change. There is a best practice document available in SDN

    > I would appreciate your help

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 06, 2010 at 05:46 AM

    >

    > c) What is the size required for translog for Installation

    well during the installation the database is created, and it is replica of 'model' system database and default size will work for installation. After installation you want to resize you transaction log anywhere around 10-15 gig. This recommendation is given by microsoft in a white paper.

    Add comment
    10|10000 characters needed characters exceeded