Move a datafile file in sql server 2000

greenspun.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 (catherine.ewington@btinternet.com), July 22, 2002

Moderation questions? read the FAQ