How to split mdf into two files?

N

Nikolai Savelyev2017-03-21 13:46:08

Windows Server

Nikolai Savelyev, 2017-03-21 13:46:08

I googled, it seems to have done everything according to the instructions, but the second file does not grow in size. The first one has already occupied almost the entire free space on the disk, I would like to somehow use other disks. Maybe someone will tell?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

K

Konstantin Tsvetkov, 2017-03-21
@tsklab

How to split mdf into two files?

Add another file to the database and transfer part of the tables to it.
That is, create a filegroup:
Read Database files and
filegroups As a result, get: