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

No comments:

Post a Comment