Post reply

Create a new database on different server

  • December 16, 2005 at 10:18 am

    #188682

    Hi,

    Is there a way to create a database on different server in SQL 2005? Thanks.

    Chris

  • December 19, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • December 19, 2005 at 8:56 am

    #610343

    Do you mean place the database files on shared drives on other servers? You can add the trace flag 1807 in the start up parameter. This is supported in  2000 and 2005. But you need to start up sql server in command prompt.

    slqserver.exe ... -T 1807

    Use network drives to hold database files are not recommended due to performance and reliability of the network.

     

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply