I have a database that is over 200GB on one data file and on the same drive
with the log and tempdb. I want to move this to a new server that is better
designed and organized - multiple data files, files and filegroups, etc. I
want to keep my developers working or keep the developers down time to a
minimum while I move this data over to the new server. What ideas do you
have for accomplishing this while keeping down time to a minimum? I have
several developers using this database that I cannot afford to have not
working.Hi,
DBCC SHRINFILE(FILENAME, EMPTYFILE)
GO
This command move all data the especified filename for another file in the
same filegroup.
ALTER DATABASE DBNAME
ADD FILEGROUP new_filegroup
GO
ALTER DATABASE DBNAME
ADD FILE (parameters) TO new_filegroup
GO
CREATE NONCLUSTERED INDEX index_name
ON tabela (columns) ON new_filegroup
GO
Change the filegroup for table use the ALTER TABLE statement.
Any things post ou send e-mail.
** * Esta msg foi Ăștil pra vocĂȘ ? Ent?o marque-a como tal. ***
Regards,
Rodrigo Fernandes
lobo-fernandes@.hotmail.com
"spoons" wrote:
> I have a database that is over 200GB on one data file and on the same driv
e
> with the log and tempdb. I want to move this to a new server that is bett
er
> designed and organized - multiple data files, files and filegroups, etc.
I
> want to keep my developers working or keep the developers down time to a
> minimum while I move this data over to the new server. What ideas do you
> have for accomplishing this while keeping down time to a minimum? I have
> several developers using this database that I cannot afford to have not
> working.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment