Re-Extenting

I need to move (actually copy) some 2000 databases over
to a faster disk array. How can I do it so that the
databases get re-extented if you know what I mean? If I
do a regular Windows Explorer type copy, it will get
unfragmented on the o/s level, right? But how can I get
any unneeded extents out of there?Yes the Windows copy of the file ( from sp_detach_db) will do new disk
allocation and (if the contiguous disk space is available), you'll get
pretty allocations.
To remove unused disk space
DBCC shrinkdb
or
DBCC shrinkfile
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob" <anonymous@.discussions.microsoft.com> wrote in message
news:2dbe601c46a86$5defb910$a501280a@.phx.gbl...
> I need to move (actually copy) some 2000 databases over
> to a faster disk array. How can I do it so that the
> databases get re-extented if you know what I mean? If I
> do a regular Windows Explorer type copy, it will get
> unfragmented on the o/s level, right? But how can I get
> any unneeded extents out of there?