Category: SQL

Move Sharepoint database to a different server.

I wont write on article on this because I found an excellent ready one. But the situation is that you have to move sharepoint to a different server keeping the sql-server instance name as is. http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=255 Thanks Todd!

Continue Reading Move Sharepoint database to a different server.

Transfer SQL Logins and their passwords.

Hi again, Done this multiple times, but thought it would be wisdom to share it. Remember this wont be necessary in SQL 2012 and higher because they save users and password directly to the user database not the master database….

Continue Reading Transfer SQL Logins and their passwords.

Sharepoint 2007 and attaching content database with SQL 2012 R2

Today I had to migrate an old wss 3.0 site to Sql 2012 R2. Made backup of the old DB and transfered it to the new server. Then restored it and tried. STSADM –o addcontentdb –url http://ssps001:7242 -databasename _wss_content_old -databaseserver…

Continue Reading Sharepoint 2007 and attaching content database with SQL 2012 R2

Lync 2013 Response Groups Usage Report not working.

Lync 2013 Monitoring is great … well when it works 🙂 Today one customer wanted to open Response Group Usage Report and got nothing after 15 minutes on waiting. The reason was a broken index in lcscdr database. And the…

Continue Reading Lync 2013 Response Groups Usage Report not working.