SQL Server Performance

SQL DataBase Issues

Discussion in 'General DBA Questions' started by mpanchal, May 31, 2003.

  1. mpanchal New Member

    Hi there,

    I am having two SQL server 7.0 running on two different machines. And i have one dataserver with me. Can i map both the SQL server databse to one path. i.e i wanted to create a database on my dataserver, in the event of first SQL server down i wanted second sql server to start with (manunaly) the database which is there on dataserver.

    Please help me or give me other solution.

    Thanks & Regards

    Mahendra
  2. gaurav_bindlish New Member

    SQL server does not support remote files as data files. So the data files need to be located locally on both installations. For handling your case you can do clustering / replication. See BOL for more details.

    Gaurav
  3. satya Moderator

Share This Page