Backup SQL Database to Share

 

For backing the SQL database to share you should make sure that below points are correct.

1. The service account should have access to share where you are going keep the backup file.

2. The account which you are using should have permission to backup the DB.

If above conditions are met then below query can be used,

USE VaultStore01
GO
BACKUP DATABASE VaultStore01
To Disk = '\\Server01\\SQLBackup\VaultStore01.bak' WITH FORMAT, INIT;
GO

Note;- in above example ‘VaultStore01’ is the name of Database and ‘\\Server01\\SQLBackup\’ is the share where backup file is kept. You should use WITH FORMAT, INIT otherwise the file will append and that create free space issues.

How to mount a vhd as a drive

If you want to open a vhd file and the content then there is builtin option available from Windows 7 or Windows 2008r2

1. Run command prompt as Administrator
2. From command prompt type ‘Diskpart’ and press Enter
3. Under diskpart type  select vdisk file="c:\winr2.vhd"
   
   Note- in this example the vhd file name is winr2.vhd and in your case you have to choose correct file name and path
4. type ‘attach vdisk’
   
5. Open windows explorer and see new drive is added

Exchange 2010–Deleted mailboxes are not able to connect

Its been found that there is a situation when an Exchange Administrator deletes mailboxes from Exchange 2010 and later when try connect from EMC its not able find the AD user to get it connected.

In this scenario please follow below steps for connecting it. In this scenario I was deleting a mailbox going by the name ‘Bad User’.

1. Login to server and open ADSIEDIT.
2. Locate the user from ADSIEDIT tool and go to properties of user.
3. Select the attribute ‘msExchRecipientTypeDetails’ and click on edit.
   
4. Click on ‘Clear’ then on OK
   
5. Make sure that the value changed to <not set> and click on OK
   
6. Go to EMC and locate the deleted user.
   
7. Right click and select connect
   
8. Click on Next
   
9. Click on Brows.. now you will be finding the user
   
10. Fill ‘Alias’ and click on Next
    
11. Click on Connect
    
12. Click on Finish
    

Configure Windows Search for Vault Cache

Enterprise vault is improving much and it has an option to enable/facilitate windows search on cached archived mails. This article will help you to configure Windows search for vault cache.

This article has 3 sections and these are easy steps to follow

I Enable WDS Search auto-enable from EV policy

1. Login to Enterprise Vault server by using EV service account.

2. From VAC got to Policies>Exchange>Desktop

3. Right click on policy and go to properties

4. In properties go to ‚Advanced‘ tab and Vault Cache from dropdown menu

5. Slect WDS search auto-enabled and click on Modify tab

6. From Modify Setting window select Foce On and click on OK

7. Click Apply from properties of polcy it will prompt that “….the change will take affect when the task syncrononize next time….” Click on OK

II Run EV tasks manually to force the policy change.

1. From VAC go to Enterprise Vault Servers>server>Taks

2. Select the tasks and go to properties

3. From properties go to Synchronization tab and make sure that ‘All mailboxes’ are selected and click on ‘Synchonize’

4. Follow above steps for all tasks

II Make sure that Windows search is enabled for EV Cache from client side

1. Login to client computer.

2. Go to Control Panel

3. Select Indexing Options

4. In Indexing Options go to Modify

5. From Indexed Locations make sure that Symantec Vault Cache is slected for the user.

6. Click on OK

Clear Deleted Item folder from Exchange mailbox with out opening.

 

I could find a script to do this job, this script is utilizing OWA and clearing the Deleted Items folder. For executing this script you may need a account which has rights on all mailboxes from where you want to clear deleted items.

strURL = "http://”ExchangeServer'”/exchange/”E-Mail of the user”/deleted items"
Set objXMLHTTP = CreateObject("Microsoft.XMLHTTP")
objXMLHTTP.Open "DELETE", strURL, False, strUName, strPwd
objXMLHTTP.setRequestHeader "Depth", "infinity,noroot"
objXMLHTTP.Send().

Delete empty directories by using PowerShell script

It was interesting to create a script for finding empty folder under file share and delete with creating a log of directories.

##########################################################################
#Purpose of this script is to find blank folders from particular location
#and report into a text file and delete.
#Version - 1
#Auther - Prajeesh
##########################################################################

$date = ( get-date ).ToString('yyyyMMdd-HHmm')
$items = Get-ChildItem ‘\\Server1\Operations\2006’ -Recurse
foreach($item in $items)
{
      if( $item.PSIsContainer )
      {
            $subitems = Get-ChildItem -Recurse -Path $item.FullName
            if($subitems -eq $null)
            {
               $item.Fullname | Out-File -FilePath C:\Users\Prajeesh\Desktop\"EmtyFolder-$date.txt" -Append
                "Remove item: " + $item.FullName
                  Remove-Item $item.FullName
            }
      }
}

 

Just copy paste above script into a PowerShell Editor and edit locations [where to scan and where to store the log file] save file as ps1 and execute.

How to reset Enterprise Vault Cache from outlook 2003 and 2010

This post has 2 sections, section 1 talks about how we do it from Outlook 2010 and Section 2 talks about how we do it from Outlook 2003. This article can be used when you see your EV cache is not syncing due to ‘x’ reasons.

I. Reset Vault Cache from Outlook 2010.

1. Open Outlook

2. Hold the Ctrl+Shift keys and click on any of the EV icons on either, refer below screenshot

This will launch the EV Diagnostics window ,

3. From ‘Enterprise Vault Diagnostic’ window click on ‘Reset’ icon under Vault Cache.

4. Click on ‘Yes’

5. Click on OK

6. Close ‘Enterprise Vault Diagnostic’ window by clicking on OK .

7. Restart Outlook and check the status.

II. Reset Enterprise Vault Cache from Outlook 2003.

1. Open outlook 2003

2. Hold CTRL + SHIFT and click on an EV button in Outlook

3. Click on the button to reset the offline vault.

4. Respond Yes to the warning message

5. Close outlook.

6. Open outlook and see the status.

Edit Exchange 2010 Quota Message with HTML format

This summary is not available. Please click here to view the post.

Export owner information of folders into a CSV file by using Power Shell command

 

I have been in search of getting a command which help me to find out owner of folders in a share. My ideas was to create a report of folder with owner information so that I can send the report to the owners and ask them to clear it off from the share if not required or get back to me with proper justification why they want to keep it there.

I did lot of search in google  but nothing turned, I know there is easy way in powershell. [as you may know Power Shell is the tool which will help you to hack windows]

Lets check how I figured it,

1. From PS locate the folder.
2. type ‘Dir |get-acl’ and enter,
   This will list all the folders and files with owner information.
3. Below command will help you to export the owner information to CSV file.
   dir |get-acl |select-object path,owner |Export-Csv test.csv -NoTypeInformation

How to make USB drive as bootable by using Windows 7

Its nice to know that by only using Windows Media you can convert you Thump dive/USB drive into bootable. Fore performing this you only need Windows 7 Media and a USB drive which is sized above 4 GB.
Trust me its not a big deal and its too interesting.
OK, lets get started..

1. Connect your thump drive/usb Drive to system.
2. Run the command prompt as Administrator
3. From command prompt type ‘Diskpart’ and press Enter.
4. From diskpart prompt type ‘List disk’ and press Enter. This will list all the drives which is connected to the system, from the screen you can find whether the disk you have just connected is detected by system or not.
   
5. Type ‘Select disk 1’ and press Enter. This command will select the disk 1, please get the disk number from ‘list disk’ output.
   
6. Type ‘clean’ and press Enter.
   
7. Type ‘Create Partition Primary’ and press Enter
   
8. Type ‘Select Partition 1’ and press Enter.
   
9. Type ‘Active’ and press Enter.
   
10. Type ‘Format fs=ntfs’ and press enter.
    
11. Type ‘assign’ and press enter to assign a drive letter to the formatted drive.
    
12. Type ‘exit’ and press to exit diskpart.
    
13. Insert windows 7 DVD into drive and from command prompt go to D:\boot
14. Type ‘Bootsect /nt60 E:’ and press enter.
    In this example the drive is E and please choose drive letter according to your drive letter.
    
15. Close the command prompt by typing ‘Exit’
16. Brows Windows 7 Media and copy entire files to the drive E [the drive which we just prepared].

We are done!!
Now boot your system, go to Bios setup and configure the USB as first boot device.

How to configure connectivity between Exchange 2010 and SAP system

It was a tough job for me to configure a connectivity between Exchange 2010 and SAP system as I am a student in Exchange 2010 .
The requirement was to receive mails in SAP but with out publishing SAP domain. SAP team was not ready to do any configuration change and the request was from high level of the Organization. SAP team just want to receive mails which sent to a particular mail address [User] that means they wanted us to receive mails and forward that to a SAP server to a particular port 250xx. The funniest thing is I was not aware that we can change destination port from settings of a ‘send connector’ . Let us check how I did it.
Note;- this method which is mentioned in this article can be used for any destination system where you want forward mail to a particular port.
For getting this happen you have to have some pre-requisites, they are,

1. One user mailbox with proper mail address.
   -This is for receive mails. Set forwarder from the properties to the mail-enabled contact. [Pre-requisites 2]

2. One mail enabled contact
  -This can be used to forward mails to SAP SMTP address.

Create Send Connector
1. Go the EMC from Exchange 2010 server.
2. Brows through and locate ‘Hub Transport’ under ‘Organization Configuration’

3. Right click on ‘New Send Connector…’

4. Give proper name and click on ‘Next’
note that its recommended to use ‘_’ in the name when you use multiple words in name that will help you when you use EPS

5. From next screen, go to Add dropdown and select ‘SMTP Address Space..’

6. Enter the destination domain/SAP and click on OK.
Note;- Choose proper cost according to your needs, its recommended to use cost 1 if you don’t have more than one connector to SAP.

7. Review the settings that you have just made and click on Next

8. From next screen select ‘Route Mail through the following host:’ and click on Add.

Enter the destination IP address and click on OK

9. Review the settings and click on Next

10. Leave it as default and click on Next

11. By using ‘Add..’ button add the Hub Transport server/Edge Transport server and  click on Next

12. Review the settings and click on New
13. Now you are done with creating a send connector. Click on Finish to complete.

Configure send Connector with proper destination SMTP port.
1. Go to EMS from Exchange server 2010.
2. From Shell type below command and press enter.
Note choose the
Get-SendConnector -identity Connector_to_SAP |Set-SendConnector -port 2500

3. Use the below command and make sure that SMTP port address is updated,
Get-SendConnector -identity Connector_to_SAP |fl
Send a test mail and track it, trust me you will be happy to read the track log
Note;- If you are confused somewhere in this article then I request you to write the comment, I will be happy to assist you.