dembis (2/2/2016)
Hey guys,I have many databases pointing their transaction logs to a same location (G: drive in my case). I would like to reduce the size of G: thru vmware because it looks like I have allocated to much space. My plan is to create a smaller drive, call it G: again, copy over the files and point all the logs to the new G:. Would I need to detach/attach all databases for that? Also, there is a replication process on one of the databases, would this process break anything?
Thanks.
How much space are we talking here, what size currently, what size are you reducing too.
My best advice to you would be to leave this alone as you have shown a clear misunderstanding of the requirements behind the logging architecture in SQL Server, you may be setting yourself up for a fall
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉