MyDoggieJessie (1/20/2013)
Personally I'd just move the entire filgroup to the new drive (rather than moving individual tables). To move the entire file group to a new drive execute the code below
Move the files would be best way.
MyDoggieJessie (1/20/2013)
stop the MSSQL Service, physically move the file from one disk to the other, then restart the SQL service
This old chestnut again!!
You do not need to stop the sql server services to physically move a database file. Issue the ALTER DATABASE ... MODIFY FILE command and then take the database Offline, this will allow you to then manipulate the physical OS files. Copy and paste them to the new directory and then bring the database online. Once the database is online successfully, then remove the old file(s).
Keep an eye out for my SSC article on this subject coming soon
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉