Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Log File and Rows Data on Remote Server

Author  Topic 

Gerald30
Yak Posting Veteran

62 Posts

Posted - 2015-02-24 : 22:25:07
Hi,

Good Morning.

I just want to get your expert opinion on this scenario.

One of my friend wants to save the Log and Row Data file of his SQL Server on a remoter computer.

So the setup will be, the SQL Database will be save on Server1 while its Log and Row Data files will be stored in Server2.

I think this is possible but what could be its effect to the performance of the Database?

Any advantages or Dis Advantages of this approach?

Thank you
   

- Advertisement -