SQL Server Performance Forum – Threads Archive
SQL DataBase IssuesHi 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
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
As suggested, for the solution you can LOG SHIPPING even though you’re using version 7.
Refer to this link http://www.sql-server-performance.com/sql_server_log_shipping.asp] which has explained in detail. Also this link http://www.sql-server-performance.com/greg_robidoux_interview.asp] adopting DR solution for the servers. _________