SharePoint SQL Server Database Went Offline Mode – How to Bring it back to Online?

Problem: Suddenly SharePoint Database Went Offline!Analyzed Event Logs and found the Database went offline because of Backup failure.SQL Server: How to Bring Database Online? Alright, How to Bring it back Online? One line T-SQL! ALTER DATABASE STS_G1WSS01_1385353007 SET ONLINE Now the database is up, and we are back to business!

Read more

How to Create SQL Server Alias for SharePoint?

In My SQL Server best practices for SharePoint, I wrote a point on SQL Server Alias. Let me elaborate that by going a little deep on configuring SQL alias for SharePoint. Why We need SQL Alias for SharePoint? When installing SharePoint, you’ll be prompted to enter the SQL Server instance and that’s…

Read more

403 Forbidden Error in SharePoint – Since SQL Server is in Stopped State

In a SharePoint 2010 Sandbox, Central Administration and other SharePoint sites threw an error: 403 FORBIDDEN Verified Site collection Lock settings, IIS Settings (IP, Host name, Bindings) other permission settings. After a while found SQL Server services are in Stopped State from SQL Server Configuration Manager. Tried starting them. After a while…

Read more

SharePoint Database Consistency Check and Repair

Another fine evening, SCOM reported an IO issue in SQL Server box where SharePoint DBs residing. At the same time, End-users started getting errors: “Cannot complete this action. Please Try again.” SCOM Alert: Try the soft repairs first: stsadm -o databaserepair -url https://site-coll-url -databasename “Content_Database_Name” PowerShell equivalent to repair a SharePoint database…

Read more

Report for Customized Pages, Files, Views in SharePoint

During Migration, had to audit all customized (Un-ghosted) pages , Files, Views,etc. in SharePoint. Here are some useful resources on this regard. 1. To get list of customized List forms: Use STSADM -o EnumAllwebs -includecustomlistviews 2. Use Stsadm extention: Get-SPCustomizedPages from https://github.com/glapointe/PowerShell-SPCmdlets 3. Use RL Soft’s Custom Page auditor https://www.riolinx.com/resources/p/CustomPagesAuditor.zip 4. Use…

Read more

What is my SQL Server Version, Service Pack, Edition

Requirement: Wanted to check the installed SQL Server version service pack level. SELECT @@version ? It didn’t give me the Service pack information. Query to Check SQL Server version, Service pack and Edition: KB Article: https://support.microsoft.com/kb/321185

Read more

“Unable to complete this operation. Please contact your administrator” Error when trying to upload a file in SharePoint

I was troubleshooting an issue with uploading files to SharePoint Site. When I tried uploading a file to the document library, I got this error: “Unable to complete this operation. Please contact your administrator” Enabled Stack Trace and Disabled Custom error tags in web.config to reveal the actual error: Unable to complete…

Read more

Event ID 3351: SQL database login failed. Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.

After joining a new server to an existing SharePoint farm found this error logged multiple times in the newly added server. Event Log 3351: SQL database login failed. Additional error information from SQL Server is included below. Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Root cause and fix: This is because SharePoint…

Read more

Truncate and Shrink SharePoint Transaction Logs, Databases

Some of the Transaction Logs and databases grown rapidly and on urgent basis I had to truncate the Log files on SharePoint Content Databases. Here is the SQL script to truncate and shrink SharePoint transaction log: Important: Please note the <database_Name> and <database_log_Name> in above examples are logical names. This sets the…

Read more

SQL Server Best Practices for SharePoint

Introduction SharePoint stores most of the data in SQL Server. Stress on SQL servers causes stress on front-end servers, which ultimately degrades the user experience. Healthy SQL Server = Healthy SharePoint! So here are the best practices for SQL Server with SharePoint 2010. Whether SQL Server 2005 or SQL  Server 2008 or…

Read more