"Qnguyen" <Qnguyen@discussions.microsoft.com> wrote in message
news:5D0F1731-6AE7-406D-B4F1-D154C1019DB2@microsoft.com...
> Hi,
> Do you know how to move SQL and its database from one drive to another
> drive
> (C to D for example). My C drive is almost full but D drive still has a
> lot
> of space. I would like to move my SQL and its database to D. Thanks for
> any
> help
>
>

"Hari Prasad" wrote:

> Hi,
>
> Do not move SQL files to D drive; for that you need to do a removal of SQL
> Server software and install it in D drive.
> To overcome your space issue just move your application/user databases to D
> Drive.
>
> Steps:-
>
> 1. Detach the database [SP_DETACH_DB Dbname]
> 2. Move the files from C drive to D drive using explorer
> 3. Attach the database [SP_Attach_db 'dbname','Mdffile with path','ldf file
> name with path'
>
> Thanks
> Hari
> SQL Server MVP
>
>
>
> "Qnguyen" <Qnguyen@discussions.microsoft.com> wrote in message
> news:5D0F1731-6AE7-406D-B4F1-D154C1019DB2@microsoft.com...
> > Hi,
> > Do you know how to move SQL and its database from one drive to another
> > drive
> > (C to D for example). My C drive is almost full but D drive still has a
> > lot
> > of space. I would like to move my SQL and its database to D. Thanks for
> > any
> > help
> >
> >
>
>