Moving SQL data to another Local Disk

How simple is it to relocate the SQL data to another local disk on
the server. Our drive that we are currently using for SQL is getting
full and we are installing a RAID1 configuration to use specifically for
SQL, but I need to know the how difficult it will be to move it to
another location. If it is simple, what are the steps for this process? Thank
you in advance.Basically you are going to Detach the DB, move the .mdf data file and
reattach the database.
Here is great how to article from Microsoft.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4wq1.asp
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in message
news:15583E07-D763-4CFE-85E5-F825AB906203@.microsoft.com...
> How simple is it to relocate the SQL data to another local disk on
> the server. Our drive that we are currently using for SQL is getting
> full and we are installing a RAID1 configuration to use specifically for
> SQL, but I need to know the how difficult it will be to move it to
> another location. If it is simple, what are the steps for this process?
> Thank
> you in advance.
>|||Thank you. This is exactly what I needed.
"Warren Brunk" wrote:
> Basically you are going to Detach the DB, move the .mdf data file and
> reattach the database.
> Here is great how to article from Microsoft.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4wq1.asp
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> */
>
> "Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in message
> news:15583E07-D763-4CFE-85E5-F825AB906203@.microsoft.com...
> > How simple is it to relocate the SQL data to another local disk on
> > the server. Our drive that we are currently using for SQL is getting
> > full and we are installing a RAID1 configuration to use specifically for
> > SQL, but I need to know the how difficult it will be to move it to
> > another location. If it is simple, what are the steps for this process?
> > Thank
> > you in advance.
> >
>
>|||before detaching the database , run checkpoint command.
Phil Buzzette wrote:
> Thank you. This is exactly what I needed.
> "Warren Brunk" wrote:
>> Basically you are going to Detach the DB, move the .mdf data file and
>> reattach the database.
>> Here is great how to article from Microsoft.
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4wq1.asp
>>
>> --
>> /*
>> Warren Brunk - MCITP - SQL 2005, MCDBA
>> www.techintsolutions.com
>> */
>>
>> "Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in message
>> news:15583E07-D763-4CFE-85E5-F825AB906203@.microsoft.com...
>> How simple is it to relocate the SQL data to another local disk on
>> the server. Our drive that we are currently using for SQL is getting
>> full and we are installing a RAID1 configuration to use specifically for
>> SQL, but I need to know the how difficult it will be to move it to
>> another location. If it is simple, what are the steps for this process?
>> Thank
>> you in advance.
>>|||before detaching the database , run checkpoint command.
--krishna
Phil Buzzette wrote:
> Thank you. This is exactly what I needed.
> "Warren Brunk" wrote:
>> Basically you are going to Detach the DB, move the .mdf data file and
>> reattach the database.
>> Here is great how to article from Microsoft.
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4wq1.asp
>>
>> --
>> /*
>> Warren Brunk - MCITP - SQL 2005, MCDBA
>> www.techintsolutions.com
>> */
>>
>> "Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in message
>> news:15583E07-D763-4CFE-85E5-F825AB906203@.microsoft.com...
>> How simple is it to relocate the SQL data to another local disk on
>> the server. Our drive that we are currently using for SQL is getting
>> full and we are installing a RAID1 configuration to use specifically for
>> SQL, but I need to know the how difficult it will be to move it to
>> another location. If it is simple, what are the steps for this process?
>> Thank
>> you in advance.
>>|||Not familiar with that. Could you please explain. I am somewhat new to SQL. I
just have to do this for a customer.
"krishna" wrote:
> before detaching the database , run checkpoint command.
> --krishna
> Phil Buzzette wrote:
> > Thank you. This is exactly what I needed.
> >
> > "Warren Brunk" wrote:
> >
> >> Basically you are going to Detach the DB, move the .mdf data file and
> >> reattach the database.
> >>
> >> Here is great how to article from Microsoft.
> >>
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4wq1.asp
> >>
> >>
> >>
> >> --
> >> /*
> >> Warren Brunk - MCITP - SQL 2005, MCDBA
> >> www.techintsolutions.com
> >> */
> >>
> >>
> >> "Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in message
> >> news:15583E07-D763-4CFE-85E5-F825AB906203@.microsoft.com...
> >> How simple is it to relocate the SQL data to another local disk on
> >> the server. Our drive that we are currently using for SQL is getting
> >> full and we are installing a RAID1 configuration to use specifically for
> >> SQL, but I need to know the how difficult it will be to move it to
> >> another location. If it is simple, what are the steps for this process?
> >> Thank
> >> you in advance.
> >>
> >>
> >>
>|||the checkpoint command writes all data stored in memory to disk to ensure
that all data is held in the .mdf database file.
it is a good practice when moving databases using the detach method.
There are alot of things that trigger a checkpoint such as a back up comman
with No_Log option and starting and stopping the SQL server or you can run
Checkpoint in your query analyzer.
thanks,
--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in message
news:50341C73-9539-43A2-A539-AC30BE7F7F59@.microsoft.com...
> Not familiar with that. Could you please explain. I am somewhat new to
> SQL. I
> just have to do this for a customer.
> "krishna" wrote:
>> before detaching the database , run checkpoint command.
>> --krishna
>> Phil Buzzette wrote:
>> > Thank you. This is exactly what I needed.
>> >
>> > "Warren Brunk" wrote:
>> >
>> >> Basically you are going to Detach the DB, move the .mdf data file and
>> >> reattach the database.
>> >>
>> >> Here is great how to article from Microsoft.
>> >>
>> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4wq1.asp
>> >>
>> >>
>> >>
>> >> --
>> >> /*
>> >> Warren Brunk - MCITP - SQL 2005, MCDBA
>> >> www.techintsolutions.com
>> >> */
>> >>
>> >>
>> >> "Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:15583E07-D763-4CFE-85E5-F825AB906203@.microsoft.com...
>> >> How simple is it to relocate the SQL data to another local disk on
>> >> the server. Our drive that we are currently using for SQL is getting
>> >> full and we are installing a RAID1 configuration to use specifically
>> >> for
>> >> SQL, but I need to know the how difficult it will be to move it to
>> >> another location. If it is simple, what are the steps for this
>> >> process?
>> >> Thank
>> >> you in advance.
>> >>
>> >>
>> >>