Pages

Showing posts with label Sharepoint Admin. Show all posts
Showing posts with label Sharepoint Admin. Show all posts

Monday, April 15, 2019

Re-Create WSS_Logging Database in the Sharepoint 2013 Server

My WSS_Logging Database is corrupted then I want to create new database.

My Central Admin --> Monitorng --> Configure usage and health data collection settings do point to WSS_Logging too, but this DB is not present.

you can create manually re-create WSS_Logging DB using in the following powershell script.

Looks like it will work. you should first delete Service Application since it already existed, but than you could recreate it + it created database. No complaints in the event log so far.

Try using this PowerShell:

#Configuration Variables
$UsageSAName = "Usage and Health Data Collection Service"
$DatabaseName = "WSS_Logging"
$DatabaseServer="SPSQL Servername\Instance Name"
$UsageLogPath = "C:\UsageLogs\"
 
#Get the Usage Service Application Service Instance
$ServiceInstance = Get-SPUsageService
 
#Create new Usage Service application
New-SPUsageApplication -Name $UsageSAName -DatabaseServer $DatabaseServer -DatabaseName $DatabaseName -UsageService $ServiceInstance #> $null
 
#Create Service Application Proxy..." 
$proxy = Get-SPServiceApplicationProxy | where {$_.TypeName -eq "Usage and Health Data Collection Proxy"}
$proxy.Provision()

Friday, March 22, 2019

Shrepoint Page library not created After activated Publishing feature. Unable to create any publishing pages

I have enabled SharePoint server publishing feature in the site, which is a site collection as well. But unfortunately the Pages library list is not appearing and i am unable to create any publishing pages.
Is there a way to solve this. I tried deactivating and activating via manually still i didnt get solution.

Solution:

Kindly find in the powershell script then deactivating and activating using powershell commands.
Finally, It will appear publishing feature and page library lists.

SharePoint Server:
Disable-SPFeature identity 'publishingSite' -URL http://server/ -force
Disable-SPFeature identity 'PublishingResources' -URL http://server/ -force
Disable-SPFeature identity 'Publishing' -URL http://server/ -force
Disable-SPFeature identity 'PublishingLayouts' -URL http://server/ -force
Disable-SPFeature identity 'publishingweb' -URL http://server/ -force

Enable-SPFeature identity 'publishingSite' -URL http://server/ -force
Enable-SPFeature identity 'PublishingResources' -URL http://server/ -force
Enable-SPFeature identity 'Publishing' -URL http://server/ -force
Enable-SPFeature identity 'PublishingLayouts' -URL http://server/ -force
Enable-SPFeature identity 'publishingweb' -URL http://server/ -force
SharePoint Online/PnP-PowerShell:
Disable-SPOFeature Identity "F6924D36-2FA8-4f0b-B16D-06B7250180FA" -Scope Site
Disable-SPOFeature Identity "AEBC918D-B20F-4a11-A1DB-9ED84D79C87E" -Scope Site
Disable-SPOFeature Identity "22A9EF51-737B-4ff2-9346-694633FE4416" -Scope Web
Disable-SPOFeature Identity "D3F51BE2-38A8-4e44-BA84-940D35BE1566" -Scope Site
Disable-SPOFeature Identity "94C94CA6-B32F-4da9-A9E3-1F3D343D7ECB" -Scope Web

Enable-SPOFeature Identity "F6924D36-2FA8-4f0b-B16D-06B7250180FA" -Scope Site
Enable-SPOFeature Identity "AEBC918D-B20F-4a11-A1DB-9ED84D79C87E" -Scope Site
Enable-SPOFeature Identity "22A9EF51-737B-4ff2-9346-694633FE4416" -Scope Web
Enable-SPOFeature Identity "D3F51BE2-38A8-4e44-BA84-940D35BE1566" -Scope Site
Enable-SPOFeature Identity "94C94CA6-B32F-4da9-A9E3-1F3D343D7ECB" -Scope Web

Tuesday, January 15, 2019

Recovering the suspected SharePoint 2013 Config database

Issue:

Central Administrator site not accessible.



Open SQL Server -- New Query, run these command to repair the SharePoint config database.




— Use the Master database 
Use Master

— Verify that database has issues 
EXEC sp_resetstatus 'SharePoint_Config'

— Put the database in emergency mode 
ALTER DATABASE SharePoint_Config SET EMERGENCY 
DBCC checkdb('SharePoint_Config')

— Set the database in single user mode 
ALTER DATABASE SharePoint_Config SET SINGLE_USER WITH ROLLBACK IMMEDIATE

— Repair the database with data loss 
DBCC CheckDB ('SharePoint_Config', REPAIR_ALLOW_DATA_LOSS)

— Set the database in multi-user mode 
ALTER DATABASE SharePoint_Config SET MULTI_USER

— Verify that database is reset 
EXEC sp_resetstatus 'SharePoint_Config'

Monday, July 30, 2018

Deploy Sharepoint 2013 Solution Package(WSP Packages) using powershell

Add WSP Solution

Add-SPSolution -LiteralPath "C:\DeployLDACPCustom\LDAPCPCustom.wsp"

Install-SPSolution -Identity "LDAPCPCustom.wsp" -GACDeployment


Install-SPFeature -path "LDAPCPCustom" -CompatibilityLevel 15


Enable-SPFeature -identity "LDAPCPCustom" -URL http://test:30000/

Update Solution Package

Update-SPSolution -GACDeployment -Identity "LDAPCP.wsp" -LiteralPath "C:\DeployLDACP\LDAPCP.wsp"

Remove WSP

De activate feature by manually in the site URL

Disable-SPFeature -identity "LDAPCP.Custom"

Uninstall-SPSolution -Identity "LDAPCPCustom.wsp"

Remove-SPSolution -Identity "LDAPCPCustom.wsp"

Wednesday, March 7, 2018

How do I delete columns that workflows create in a sharepoint list

Here is what you should do:
1. Get SharePoint Manager from Codeplex, if you've not already. It's a freeware with very useful feature for people like us. you can download it.
2. Run SharePoint Manager as Administrator 
3. Under the site -> List -> Fields, change the property of Workflow field Allow Deletion True
4. Open the site in SPD, Edit List coulmns, Show Read Only columns & finally delete.
Sharepoint Manager Screen:


Sharepoint Designer