SQL Express Edition Backup by SQLCMD fails with error ‘Named Pipes Provider: Could not open’

Issue

Today I came across a situation that SQL backup by using script with SQLCMD fails.
Below is the error I got,

HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

Set Permission on Enterprise Vault Accounts with EVPM

Here we are going to discuss how to set permission on some EV account to a user by using EVPM script. Below script will help you with the same.

1. Create a file with notepad and save the same in UNICODE format, with an .ini extension.
2. Copy below script to the .ini file created in 1st step and modify with your environmental value on DirectoryComputerName, SiteName, ArchiveName and  Yourdomain\User.

Install Exchange server 2013 Preview

Here is the step by step instructions to install Exchange server 2013 preview version on the LAB. In this scenario I am installing Exch 2013 on Windows server 2008 R2 system.
Preparation Tasks
1. Log the server where you are going install Exchange 2013. In this example server version is Windows 2008 R2 SP2
2. Open powershell and type ‘import-module servermanager.
Then enter ‘Add-windowsFeature rsat-adds’ please refer the below screenshot.

How to Use EVDuplicateCleaner.exe

Symantec has found that under some circumstances post-processing failed to convert items to shortcuts resulting in duplicates in the archive. They have released a tool called EVDUplicateCleaner and the same is available in ClickHere. Since the documentation for the tool is not that clear I thought of writing my experience with the tool here

1 Create report of duplicated items

The tool has 2 options to create reports one is ‘summary’ and other is ‘report ‘. Summary gives you a just summary and report gives you detailed report of duplicate items from a specified archive or entire archive from a specific EV Store.

How to set ‘Archive Usage Limit’ above 16GB for a user in Enterprise Vault

Issue
When you try to set ‘Archive Usage Limit’ for a user from VAC, if the value is above 16Gb, you will get error ‘Enter and integer between 0 and 16000’,

Solution
Its by design and you have to apply the solution via SQL

Prepare Exchange 2010 for Enterprise Vault

To prepare Exchange 2010 for Enterprise vault you should do 2 steps from Exchange 2010 side, that are,
1. Create a throttling policy and assign to EV service account
2. Set permission for EV service account on Exchange
Note;- please make sure that your EV service account has a mailbox in Exchange 2010 before following the below steps.
Create a throttling policy and assign to EV service account
To create a required throttling policy Symantec has give proper PowerShell script which is available with installation media,
1. Go to EV installation media and brows ‘Symantec Enterprise Vault 9.0.3\Server\PowerShellScripts\PowerShellScripts’

EVPM Script for bulk archive

There was a bulk mailbox archive request and its was tough to run the script for each user to change the default policy which force EV to archive mails from users who already left the organization.  Finally we have decided to create a group and include LDAP query in the EVPM script, below is the script which i was using.
[Directory]
directorycomputername=localhost ; Localhost can be changed by the server name
sitename=EVSITE ; Site name of EV