Unanswered: changing the data files to another disk partition
I have a sql server 7 running on a machine with two disk partitions (D: and E.
The data files xxx.mdf and xxx.ldf are stored in D:, which has very few space available. I want to copy these files to E: but I get an error saying that it is not possible to change the source file of a database. Is it possible to do it or do i have to create another data file in E: and keep the old one in D:?