Saturday, February 25, 2012

Changing number of data files

I have a 225Gb database on a test server. It is currently in one file and I
would like to split it into several files smaller files. What is the best
way of doing this?
thanks
GavGav
CREATE DATABASE mywind
GO
ALTER DATABASE mywind ADD FILEGROUP new_customers
ALTER DATABASE mywind ADD FILEGROUP sales
GO
ALTER DATABASE mywind ADD FILE
(NAME='mywind_data_1',
FILENAME='d:\mw.dat1')
TO FILEGROUP new_customers
ALTER DATABASE mywind
ADD FILE
(NAME='mywind_data_2',
FILENAME='d:\mw.dat2')
TO FILEGROUP sales
"Gav" <gavin.metcalfe@.portakabinnospam.com> wrote in message
news:bu3072$ltb$1@.titan.btinternet.com...
quote:

> I have a 225Gb database on a test server. It is currently in one file and

I
quote:

> would like to split it into several files smaller files. What is the best
> way of doing this?
> thanks
> Gav
>

No comments:

Post a Comment