Move a datafile file in sql server 2000greenspun.com : LUSENET : DBAzine : One Thread
In Oracle it is really easy to move a file without taking the whole database offline. In other words you take the tablespace offline only. Is there a way in sql server to move a single datafile ie rename or to another disk, without taking all of the database offline?
-- catherine Ewington (firstname.lastname@example.org), July 22, 2002