Sunday, November 16, 2008

How to change Sharepoint Embedded Database microsoft##ssee


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 X86 X64
Microsoft SQL Server 2005 Command Line Query Utility X86 X64

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