Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    50

    Unanswered: where data file and log file located???

    Hi all,
    I want to create a database on a computer but datafile nad transaction log file located on the other computer.
    please show me,
    best regard.

  2. #2
    Join Date
    Feb 2004
    Posts
    3
    You Can specifiy the database file location. If you right click on the DB in the general Tab you will see the location column and in the tranasaction Tab you will see the Location Column of the tranasaction log. I pretty sure these need to be on a drive which is mounted as a local drive for MSSQL to use them. Hope this helps..

  3. #3
    Join Date
    Jan 2004
    Posts
    50
    Originally posted by gus8910
    You Can specifiy the database file location. If you right click on the DB in the general Tab you will see the location column and in the tranasaction Tab you will see the Location Column of the tranasaction log. I pretty sure these need to be on a drive which is mounted as a local drive for MSSQL to use them. Hope this helps..
    thanks for reply, but i can not do it. When i try to do but SQL server only display drives on the local computer.
    Best regard,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •