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.
Thanks