"Don Murphy" <DonMur***@discussions.microsoft.com> wrote in message
news:F29306B2-D89B-467A-8096-B3807FEBBD60@microsoft.com...
> Is there a good resource that shows how to move the database file from one
> drive partition to another for SQL 2005 SP2?
>
> This is a new server with the default database getting ready for
> Sharepoint.
> Right now I start "SQL Server Management Studio" and drill down to
> database
> settings properties.
>
> I see two entries:
>
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
>
> one for data and one for log.
>
> Is it as easy as stopping some service (please tell me which ones) and
> changing these pats and restarting the services?
>
>
> TIA
>

"Gail Erickson [MS]" wrote:

> > Is there a good resource that shows how to move the database file from one
> > drive partition to another for SQL 2005 SP2?
>
> See the section Planned Relocation Procedure in this Books Online topic
> http://msdn2.microsoft.com/en-us/library/ms345483.aspx for step-by-step
> instructions
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>
> "Don Murphy" <DonMur***@discussions.microsoft.com> wrote in message
> news:F29306B2-D89B-467A-8096-B3807FEBBD60@microsoft.com...
> > Is there a good resource that shows how to move the database file from one
> > drive partition to another for SQL 2005 SP2?
> >
> > This is a new server with the default database getting ready for
> > Sharepoint.
> > Right now I start "SQL Server Management Studio" and drill down to
> > database
> > settings properties.
> >
> > I see two entries:
> >
> > C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
> >
> > one for data and one for log.
> >
> > Is it as easy as stopping some service (please tell me which ones) and
> > changing these pats and restarting the services?
> >
> >
> > TIA
> >
>
>
>

"Don Murphy" <DonMur***@discussions.microsoft.com> wrote in message
news:05163DE7-E9D7-46FB-A623-D40CB27266DA@microsoft.com...
> Thanks for the response.  Is there no way to do this with managementy
> studio?
>
> or some other tool?  I am not an sql weeny...    ;)
>
>
>
> "Gail Erickson [MS]" wrote:
>
>> > Is there a good resource that shows how to move the database file from
>> > one
>> > drive partition to another for SQL 2005 SP2?
>>
>> See the section Planned Relocation Procedure in this Books Online topic
>> http://msdn2.microsoft.com/en-us/library/ms345483.aspx for step-by-step
>> instructions
>> --
>> Gail Erickson [MS]
>> SQL Server Documentation Team
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights
>> Download the latest version of Books Online from
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>>
>> "Don Murphy" <DonMur***@discussions.microsoft.com> wrote in message
>> news:F29306B2-D89B-467A-8096-B3807FEBBD60@microsoft.com...
>> > Is there a good resource that shows how to move the database file from
>> > one
>> > drive partition to another for SQL 2005 SP2?
>> >
>> > This is a new server with the default database getting ready for
>> > Sharepoint.
>> > Right now I start "SQL Server Management Studio" and drill down to
>> > database
>> > settings properties.
>> >
>> > I see two entries:
>> >
>> > C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
>> >
>> > one for data and one for log.
>> >
>> > Is it as easy as stopping some service (please tell me which ones) and
>> > changing these pats and restarting the services?
>> >
>> >
>> > TIA
>> >
>>
>>
>>

"Gail Erickson [MS]" wrote:

> >  Is there no way to do this with managementy studio?
>
> Sure, you've got two choices that can be GUI-only tasks: Detach/attach or
> Backup/Restore.
>
> For Detach/Attach, see
> http://msdn2.microsoft.com/en-us/library/ms191491.aspx  and
> http://msdn2.microsoft.com/en-us/library/ms190209.aspx. Just remember to
> physically move the files to the new location before you attach :>)   I
> recommend making a full backup of the database prior to moving just as a
> safeguard.
>
> For Backup/Restore, I didn't find any how-to topics that were not T-SQL code
> specific.  But you can certainly backup and restore a database using the GUI
> in Management Studio and specify a new file location in the "Restore As"
> part of the interface.
>
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>
> "Don Murphy" <DonMur***@discussions.microsoft.com> wrote in message
> news:05163DE7-E9D7-46FB-A623-D40CB27266DA@microsoft.com...
> > Thanks for the response.  Is there no way to do this with managementy
> > studio?
> >
> > or some other tool?  I am not an sql weeny...    ;)
> >
> >
> >
> > "Gail Erickson [MS]" wrote:
> >
> >> > Is there a good resource that shows how to move the database file from
> >> > one
> >> > drive partition to another for SQL 2005 SP2?
> >>
> >> See the section Planned Relocation Procedure in this Books Online topic
> >> http://msdn2.microsoft.com/en-us/library/ms345483.aspx for step-by-step
> >> instructions
> >> --
> >> Gail Erickson [MS]
> >> SQL Server Documentation Team
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights
> >> Download the latest version of Books Online from
> >> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> >>
> >> "Don Murphy" <DonMur***@discussions.microsoft.com> wrote in message
> >> news:F29306B2-D89B-467A-8096-B3807FEBBD60@microsoft.com...
> >> > Is there a good resource that shows how to move the database file from
> >> > one
> >> > drive partition to another for SQL 2005 SP2?
> >> >
> >> > This is a new server with the default database getting ready for
> >> > Sharepoint.
> >> > Right now I start "SQL Server Management Studio" and drill down to
> >> > database
> >> > settings properties.
> >> >
> >> > I see two entries:
> >> >
> >> > C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
> >> >
> >> > one for data and one for log.
> >> >
> >> > Is it as easy as stopping some service (please tell me which ones) and
> >> > changing these pats and restarting the services?
> >> >
> >> >
> >> > TIA
> >> >
> >>
> >>
> >>
>
>
>

"Don Murphy" <DonMur***@discussions.microsoft.com> wrote in message
news:D495ADA3-1FA0-4AF0-97BD-D001F5B8F6C6@microsoft.com...
>I can't just use the browse button in the pop up I identified above?
>
> I used that technique to move exchange databases?
>
>
>
> "Gail Erickson [MS]" wrote:
>
>> >  Is there no way to do this with managementy studio?
>>
>> Sure, you've got two choices that can be GUI-only tasks: Detach/attach or
>> Backup/Restore.
>>
>> For Detach/Attach, see
>> http://msdn2.microsoft.com/en-us/library/ms191491.aspx  and
>> http://msdn2.microsoft.com/en-us/library/ms190209.aspx. Just remember to
>> physically move the files to the new location before you attach :>)   I
>> recommend making a full backup of the database prior to moving just as a
>> safeguard.
>>
>> For Backup/Restore, I didn't find any how-to topics that were not T-SQL
>> code
>> specific.  But you can certainly backup and restore a database using the
>> GUI
>> in Management Studio and specify a new file location in the "Restore As"
>> part of the interface.
>>
>> --
>> Gail Erickson [MS]
>> SQL Server Documentation Team
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights
>> Download the latest version of Books Online from
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>>
>> "Don Murphy" <DonMur***@discussions.microsoft.com> wrote in message
>> news:05163DE7-E9D7-46FB-A623-D40CB27266DA@microsoft.com...
>> > Thanks for the response.  Is there no way to do this with managementy
>> > studio?
>> >
>> > or some other tool?  I am not an sql weeny...    ;)
>> >
>> >
>> >
>> > "Gail Erickson [MS]" wrote:
>> >
>> >> > Is there a good resource that shows how to move the database file
>> >> > from
>> >> > one
>> >> > drive partition to another for SQL 2005 SP2?
>> >>
>> >> See the section Planned Relocation Procedure in this Books Online
>> >> topic
>> >> http://msdn2.microsoft.com/en-us/library/ms345483.aspx for
>> >> step-by-step
>> >> instructions
>> >> --
>> >> Gail Erickson [MS]
>> >> SQL Server Documentation Team
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights
>> >> Download the latest version of Books Online from
>> >> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>> >>
>> >> "Don Murphy" <DonMur***@discussions.microsoft.com> wrote in message
>> >> news:F29306B2-D89B-467A-8096-B3807FEBBD60@microsoft.com...
>> >> > Is there a good resource that shows how to move the database file
>> >> > from
>> >> > one
>> >> > drive partition to another for SQL 2005 SP2?
>> >> >
>> >> > This is a new server with the default database getting ready for
>> >> > Sharepoint.
>> >> > Right now I start "SQL Server Management Studio" and drill down to
>> >> > database
>> >> > settings properties.
>> >> >
>> >> > I see two entries:
>> >> >
>> >> > C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
>> >> >
>> >> > one for data and one for log.
>> >> >
>> >> > Is it as easy as stopping some service (please tell me which ones)
>> >> > and
>> >> > changing these pats and restarting the services?
>> >> >
>> >> >
>> >> > TIA
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

> Is there a good resource that shows how to move the database file from one
> drive partition to another for SQL 2005 SP2?
>
> This is a new server with the default database getting ready for
> Sharepoint.
> Right now I start "SQL Server Management Studio" and drill down to
> database settings properties.
>
> I see two entries:
>
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
>
> one for data and one for log.
>
> Is it as easy as stopping some service (please tell me which ones) and
> changing these pats and restarting the services?