|
Posted by jimfkennedy on 05/18/06 13:29
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?
Any ideas on how we should approach this?
(ps we dont have control of the sqlserver its outsourced, so simpler
the better).
Thanks,
Jim
Navigation:
[Reply to this message]
|