Minggu, 19 Desember 2010

How to move datafiles to a new drive in SQL Server

For one of the databases that I have to manage we were running out of space, so we got a shiny new 10.9 TB sized drive.I was asked to move some files used by one database to this new drive. I decided to write up a little blog post just in case you ever need to do this so that you don't backup and restore (with move) because there is another way. First create this test database with 3 data files

Tidak ada komentar:

Posting Komentar