Sql Server Programming :: Moving database from one disk to another ?


	Moving database from one disk to another ? I'm a newly appointed dba and have run into a problem... We ran out of diskspace so I added another data file for the data on another available spindle. All was good but now I have a new disk for the database and would like to get rid of the 'split' database and move it to the new disk. This doesn't seem like something no one else has ever done, but I can't find a way. It is a SQL Server 2000 (SP4)installation, about 125 GB in size. Any pointers or references are greatly appreciated! Thanks! Norman Detach the DB, move the file and attach the DB. Check out sp_attach_db in the BOL for details. -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "NormanHeyen" <n.he@insightbb.com> wrote in message news:ffrf631lrrp0ia54t55t7qd0nk86s5c6a9@4ax.com... I'm a newly appointed dba and have run into a problem... We ran out of diskspace so I added another data file for the data on another available spindle. All was good but now I have a new disk for the database and would like to get rid of the 'split' database and move it to the new disk. This doesn't seem like something no one else has ever done, but I can't find a way. It is a SQL Server 2000 (SP4)installation, about 125 GB in size. Any pointers or references are greatly appreciated! Thanks! Norman