|
Posted by Erland Sommarskog on 05/19/06 01:09
(jimfkennedy@gmail.com) writes:
> Hi, we have a SqlServer instance in production containing around 10
> databases.
>
> It has just been realised that all the db's are held on the small c:
> partition with only a gig or so of space left.
>
> On the server there is another partition and another hard disk both
> will ample space (few hundred gigs).
>
> What would be the best way of getting the data onto the other
> partitions with minimal impact on the applications. Can we move the
> primary data files for each db? Should we just create secondary data
> files on the big partitions for all the db's? Is there a method of
> moving all the data at once?
It appears that your databases are small in size. That talks against
creating a secondary datafile.
I would suggest that you use either detach/attach or backup/restore the
move the database. My own preference is for the latter.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|