|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Moving a database to a new driveI have a CRM 3.0 application running on a Windows server 2003 R2 and SQL
2005. I need to move the database and log file to a different drive from the current location. It is currently on C: which is the system partion. I need to move the log file and data file to H and I respectively. The database has one filegroup, Primary. It has one datafile in the primary filegroup, and one log file. I need to move these files to drives H and I respectively. Will someone be able to point me in the right direction on how to move this files? Thanks in advance. OD INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071 Show quote "OD" <olu***@hotmail.com> wrote in message news:%238v5kKd0GHA.1252@TK2MSFTNGP04.phx.gbl... >I have a CRM 3.0 application running on a Windows server 2003 R2 and SQL >2005. I need to move the database and log file to a different drive from >the current location. It is currently on C: which is the system partion. I >need to move the log file and data file to H and I respectively. > > The database has one filegroup, Primary. It has one datafile in the > primary filegroup, and one log file. I need to move these files to drives > H and I respectively. > > Will someone be able to point me in the right direction on how to move > this files? > > Thanks in advance. > > OD > See reply in sqlserver.tools
Show quote "OD" <olu***@hotmail.com> wrote in message news:%238v5kKd0GHA.1252@TK2MSFTNGP04.phx.gbl... >I have a CRM 3.0 application running on a Windows server 2003 R2 and SQL >2005. I need to move the database and log file to a different drive from >the current location. It is currently on C: which is the system partion. I >need to move the log file and data file to H and I respectively. > > The database has one filegroup, Primary. It has one datafile in the > primary filegroup, and one log file. I need to move these files to drives > H and I respectively. > > Will someone be able to point me in the right direction on how to move > this files? > > Thanks in advance. > > OD > Thanks Jasper. You have provided the exact information that I am searching.
For some reason I couldn't find it on microsoft's Web site. Thanks again, OD Show quote "Jasper Smith" <jasper_smi***@hotmail.com> wrote in message news:e7LOZPd0GHA.720@TK2MSFTNGP02.phx.gbl... > See reply in sqlserver.tools > > -- > HTH, > Jasper Smith (SQL Server MVP) > http://www.sqldbatips.com > > > "OD" <olu***@hotmail.com> wrote in message > news:%238v5kKd0GHA.1252@TK2MSFTNGP04.phx.gbl... >>I have a CRM 3.0 application running on a Windows server 2003 R2 and SQL >>2005. I need to move the database and log file to a different drive from >>the current location. It is currently on C: which is the system partion. I >>need to move the log file and data file to H and I respectively. >> >> The database has one filegroup, Primary. It has one datafile in the >> primary filegroup, and one log file. I need to move these files to drives >> H and I respectively. >> >> Will someone be able to point me in the right direction on how to move >> this files? >> >> Thanks in advance. >> >> OD >> > > You could take a look at KBArticle
http://msdn2.microsoft.com/en-us/library/ms187858.aspx -- Show quoteThanks Sethu Srinivasan, Software Design Engineer, SQL Server Manageability -- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm. "OD" <olu***@hotmail.com> wrote in message news:%238v5kKd0GHA.1252@TK2MSFTNGP04.phx.gbl... >I have a CRM 3.0 application running on a Windows server 2003 R2 and SQL >2005. I need to move the database and log file to a different drive from >the current location. It is currently on C: which is the system partion. I >need to move the log file and data file to H and I respectively. > > The database has one filegroup, Primary. It has one datafile in the > primary filegroup, and one log file. I need to move these files to drives > H and I respectively. > > Will someone be able to point me in the right direction on how to move > this files? > > Thanks in advance. > > OD >  
Other interesting topics
|
|||||||||||||||||||||||
