Sunday, November 16, 2008

How to change Sharepoint Embedded Database microsoft##ssee

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 Client
http://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 Utility
http://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-br


Adminstration 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 lines
1> 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.
Post a Comment