Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

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

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc