Skip to Content
Former Member
Dec 16, 2007 at 01:26 PM

Hard disk space


I have two instances(A&B) in a single machine .Transaction log of both instances reside on drive M.

the first instance(A) transaction log data is full now even though there has been enough space on drive M ;I guess the free space mush have assigned for second instance (B) only at the time of installation

1)How can I make the transaction log of instance A to use available free space from SQL management studio becuase its not considering the free space on drive M

2)Can I add another HD solely for the purpose of transaction log A...If it so how to assign the new hard disk for instance A trans log purpose from SQL management studio.