Geeks With Blogs
SharePoint & SQL Thoughts July 2010 Entries
Get information for your SQL Server
If you are a DBA you should be familiar with @@Version to get the information for you SQL Server, but whatif you want to get a little more that the @@Version information. Here is a head start. CREATE PROCEDURE usp_getserverinfo AS IF @@VERSION LIKE ('% 10.%') BEGIN SELECT SERVERPROPERTY('ComputerNam... as ActualServerName ,SERVERPROPERTY('MachineName') as SQLServerName ,SERVERPROPERTY('InstanceNa... as instancename ,(CASE WHEN CONVERT(VARCHAR(2),SERVERPR... ......

Posted On Monday, July 19, 2010 7:26 AM

SharePoint Backup using PowerShell errors
I was at a client location the other day and there was a need to configure PowerShell to back-up the SharePoint 2010 Farm after getting my commands ready and executing them it boomed out on me with the following errors Verbose: [Database_Name] SQL command timeout is set to 1.00 hours. Warning: [Database_Name] Cannot open backup device 'e:\etekglobalinc\backups\s... Operating system error 3(The system cannot find the path specified.). The path seemed right but the .bak file didn’t ......

Posted On Friday, July 16, 2010 8:44 AM

While publishing SharePoint 2010 publishing portal it errors out
When publishing SharePoint 2010 Portal you encounter the following error “The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator. “ This issue is caused by lack of Session State Service which usually is a result of farm being configured manually. To fix the issue power up your PowerShell on the SharePoint Server and run the following commands, these commands will create a State Service ......

Posted On Thursday, July 8, 2010 5:17 AM

Copyright © Leonard Mwangi | Powered by: