Showing posts with label servermanagement. Show all posts
Showing posts with label servermanagement. Show all posts

Monday, March 12, 2012

Moving SQL 2005 Express dbs using SQL Server Management Express Studio?

Is it possible to move a SQL 2005 Express database using the SQL Server
Management Express 2005 Studio tools? I am trying to move the default
databases for Sharepoint MOSS 2007 from a C: partition to a D: partition,
and would like to know if I can do this with the SME 2005 tools, rather than
using the command line method in KB224071.
Also, is there a list of what the default databases are for MOSS 2007, so I
can make sure that I move all the databases?
Thanks,
Rob G.
Hi Robert
"Robert Gordon" wrote:

> Is it possible to move a SQL 2005 Express database using the SQL Server
> Management Express 2005 Studio tools? I am trying to move the default
> databases for Sharepoint MOSS 2007 from a C: partition to a D: partition,
> and would like to know if I can do this with the SME 2005 tools, rather than
> using the command line method in KB224071.
> Also, is there a list of what the default databases are for MOSS 2007, so I
> can make sure that I move all the databases?
> Thanks,
> Rob G.
>
I am not sure about SQL Express Manager, but you can always use sp_detach_db
and sp_attach_db from a command prompt and SQLCMD see
http://support.microsoft.com/kb/224071/
John