SQL Server Performance Forum – Threads Archive

Transaction Log storage

Can a tx log file be stored on a server not the same as the data file. If yes what are the disadvantages?

Yes, you must keep away database transaction log on a seperate drive other than data file, in order to avoid any disk contentions on the resource intensive database. http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=42 for your information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I am curious to know if this drive can be on another server i.e data file on one server and log file on another server.

i ahvent been able to find a way to do this: Creating the log file using UNC path since it is not the same server as data file.

http://www.windowsitpro.com/Article/ArticleID/14285/14285.html to answer your questions. I would like to know as per the artilce ‘First ask yourself what your reason is for doing this?’ Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks, that helps. No reason but to save money. We have some good servers unused. So instead of adding another external storage array wanted to know if this was an option.

Then be aware you may be inviting trouble, I will guess that you will come up here with a related problem in the due course [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

You should NEVER do this on a production system skdmail, even if you can. What is the cost of downtime and corruption of your production database? Does it outweigh the benefit you’re going to be getting from this. If you’re going to move any direction, purchase seperate drives on the the production server and place the logs on it. Dicing up space can be achieved on a SAN. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

Thanks guys.. this suggestion had come up and wanted an expert opinion.. we are not doing it!

]]>