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
Monday, March 12, 2012
Moving SQL 2005 Express dbs using SQL Server Management Express Studio?
Labels:
database,
dbs,
defaultdatabases,
express,
management,
microsoft,
moving,
mysql,
oracle,
server,
servermanagement,
sql,
studio,
tools
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment