Hi,Some time ago have this litle issue, change database on a sharepoint embedded Database, so i create this litle steps to make the move without using sql server "SQL Server Management".This steps required a litle of knowledge of SQL commands.Microsoft SQL Server Native Clienthttp://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/sqlncli.msi X86
http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/sqlncli_x64.msi X64
Microsoft SQL Server 2005 Command Line Query Utilityhttp://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_SQLCMD.msi X86
http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_SQLCMD_x64.msi X64
http://support.microsoft.com/kb/843580/pt-brAdminstration Site Sharepoint 3.0
Central Administration> Application Management > Content Database
Remove Content Database.
Command lines
net pause mssql$sharepoint
net continue mssql$sharepoint
C:\>sqlcmd -S \\.\
pipe\mssql$microsoft##ssee\sql\query -E
1> exec sp_detach_db 'WSS_Content';
2> go
Now copy you database from c:\windows\sysmsi\sse\mssql2005\mssql\data to your new directory
ex: D:\DB....
Back to
command lines1> exec sp_attach_db @dbname=N'WSS_Content', @filename1=N'[Path]WSS_Content.mdf', @filename2=[Path]WSS_Content_log.LDF';
2> go
1> quit
C:\>cd "Program Files"
C:\Program Files>cd "Common Files"
C:\Program Files\Common Files>cd "Microsoft Shared"
C:\Program Files\Common Files\Microsoft Shared>cd "web server extensions"
C:\Program Files\Common Files\Microsoft Shared\web server extensions>cd 12
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12>cd bin
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm -o addcontentdb -url http//[URL] -databasename WSS_content
Operação concluída com êxito.