Sunday, December 15, 2013

Archieve/Backup Visual SourceSafe file using CMD


@ECHO OFF
@TITLE Backing up source safe databases
FOR /F "tokens=2-4 delims=/ " %%i IN ('date /t') DO SET DATE=%%k%%j%%i
FOR /F "TOKENS=1-2 DELIMS=: " %%I IN ('time /t') DO SET TIME=%%I%%J
FOR /F "TOKENS=2 DELIMS= " %%K IN ('time /t') DO SET AMPM=%%K
"C:\Program Files\Microsoft Visual SourceSafe\ssarc" -d- "E:\Today.ssa" $/ "-sE:\Vss-Projects" -yadmin,pass@word1
@ECHO Finished backups


Here - C:\Program Files\Microsoft Visual SourceSafe\ssarc is SourceSafe Archieve application (ssarc.exe) path
E:\Today.ssa - Backup File Location and Name
E:\Vss-Projects - Current Srcsafe stored Location.
admin and pass@word1 is credential for the VSS admin who has permission to backup and restore. 

Thursday, November 28, 2013

Add a crawled property in SharePoint 2013 with sortable/Refinable using Powershell

Add a crawled property in SharePoint 2013 with sortable/Refinable using Powershell

For Sortable:

New-SPEnterpriseSearchMetadataCrawledProperty -Category SharePoint -IsNameEnum $false -Name "ows_MyCrawledProperty" -PropSet 00130329-0000-0130-c000-000000131346 -SearchApplication "Search Service Application" -VariantType 0
 
New-SPEnterpriseSearchMetadataManagedProperty -Name "MyCrawledProperty" -SearchApplication "Search Service Application" -Type 1 -Queryable $true -Retrievable $true
 
$cp = Get-SPEnterpriseSearchMetadataCrawledProperty -SearchApplication "Search Service Application" "ows_MyCrawledProperty"
 
$mp = Get-SPEnterpriseSearchMetadataManagedProperty -SearchApplication "Search Service Application" -Identity "MyCrawledProperty"

$mp.sortable= $true

$mp.update
 
New-SPEnterpriseSearchMetadataMapping -SearchApplication "Search Service Application" -CrawledProperty $cp -ManagedProperty $mp


For Refinable:

New-SPEnterpriseSearchMetadataCrawledProperty -Category SharePoint -IsNameEnum $false -Name "ows_MyCrawledProperty" -PropSet 00130329-0000-0130-c000-000000131346 -SearchApplication "Search Service Application" -VariantType 0
 
New-SPEnterpriseSearchMetadataManagedProperty -Name "MyCrawledProperty" -SearchApplication "Search Service Application" -Type 1 -Queryable $true -Retrievable $true
 
$cp = Get-SPEnterpriseSearchMetadataCrawledProperty -SearchApplication "Search Service Application" "ows_MyCrawledProperty"
 
$mp = Get-SPEnterpriseSearchMetadataManagedProperty -SearchApplication "Search Service Application" -Identity "MyCrawledProperty"

$mp.Refinable= $true

$mp.update
 
New-SPEnterpriseSearchMetadataMapping -SearchApplication "Search Service Application" -CrawledProperty $cp -ManagedProperty $mp

Wednesday, November 6, 2013

Error: cannot generate SSPI context



Issue: Got the error cannot generate SSPI context in 2008 sql, when I access 
(machine1) Destination machine’s SQL instance from (machine2)Source Machine SQL instance.

Solution: Checked the error machine<machine1> is remote accessible using machine name and got the below error.

Remote Desktop Connection fails - outdated entry in the DNS cache.

Took RDP using IP, Works fine and checked the time, the time was off by an hour. 

Run the below comments in cmd

· net stop w32time
· net start w32time

The both the problem has been solved.

Email sent from a shared mailbox are not saved to the Sent Items

  Issue : When a user sends an Email from his delegated (shared) mailbox the Email which sent from the delegated mailbox are stored in user...