SQL Server, Location of database and log files

microsoft.public.sqlserver.server - Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.


SQL Server >> Location of database and log files

by U2VhQm9i » Wed, 15 Sep 2004 04:57:01 GMT

We are beginning a new implemenation of SQL2000 and considering the locations
of the database and log files. Am I correct that the Log files must reside on
the same server as SQL? Is performance effected at all if the database file
resides on another server?

Top

SQL Server >> Location of database and log files

by BillyDees69 » Wed, 15 Sep 2004 05:01:40 GMT


Well - think what would happen if you lost the other server or even if you
lost network connection.

It's not a good idea. :(



locations
on
file




Top

SQL Server >> Location of database and log files

by David Portas » Wed, 15 Sep 2004 05:24:53 GMT

Data and log files can and should be split across multiple volumes or
devices on a server (either direct-attached or SAN storage) but those
devices must be attached to the server that is running SQL.

In certain very restricted circumstances and on certain hardware only NAS
storage is supported but this is definitely not recommended other than in
exceptional cases.

Installation of databases on a remote server is not supported, nor would it
be a desriable or sensible thing to do from the point of view of
architecture, performance, resilience or data-integrity.

--
David Portas
SQL Server MVP


Top
Similar Threads

1. Moving distribution database log file to a new location in 2k5 - SQL Server Replication

2. SQLDMO:To Change Database file Location path of DBBackup file ( VC 

Dear all 
 I am creating a tool in VC7.0 for database restoration 
 I am facing a problem while working with sql dmo objects i need to restore 
a database, which has database location as "C:\Program Files\Microsoft SQL 
Server\MSSQL\Data\Sample.mdf" to new instance of SQlserver called as 
NEWINSTANCE.

If i try to restore the database file with out modifying the location path 
then my restoration process is failing since "C:\Program Files\Microsoft SQL 
Server\MSSQL\Data\" does not exist in the new machine.

So i need to change the database location file path as given below 
"C:\Program Files\Microsoft SQL Server\MSSQL$NEWINSTANCE\Data\Sample.mdf"
but i am not able to figure out how to achive it
can any one please help me out to solve the problem

waiting in message loop for response message 

With Regards