Tuesday, December 15, 2009

Exchange 2007 - get the list of mailboxes from database

To get the list of mailboxes per databases: for ex. Exch2 SG1 DB1

Get-Mailbox –Database “EXCH1\EXCHSG1\DB1” | Format-Table DisplayName,WindowsEmailaddress,Database > exch2sg1db1.txt


or


Get-Mailbox –Database “EXCH2\EXCH2_SG1\DB1” | Format-Table DisplayName,WindowsEmailaddress,Database > exch2sg1db1.txt

Exchange 2007 mailbox migration in Bulks

Steps in moving mailboxes in Bulk:

1. Put all the users that need to be migrated in a text file containing just their email addresses. Name it like “names.txt”

2. Then login on one of the Exchange 2007 servers.

3. Open “Exchange Management Shell”

4. In the shell command prompt, the syntax is: gc {textfilename} | Move-Mailbox –TargetDatabase {nameOfDatabase} –Maxthreads 20

For example: gc names.txt | Move-Mailbox –TargetDatabase “XCH5\SG3\XCH5SG3DB” –Maxthreads 20

5. After the migration is complete, it will generate an xml file in “C:\Program Files\Microsoft\Exchange Server\Logging\MigrationLogs”

6. Open the XML file in Excel as XML table to see the results. All the result should be “This mailbox has been moved to the target database.” . If the mailbox has a different result then it has to be done from GUI and select the option to skip corrupted items.

Exchange 2007 - how to check backup status of databases

Using powershell

Get-MailboxDatabase -Status | FT name, LastFullBackup, LastIncrementalBackup

Microsoft provides Free Antivirus

http://www.microsoft.com/security_essentials

About Microsoft Security Essentials

Microsoft Security Essentials provides real-time protection for your home PC that guards against viruses, spyware, and other malicious software.

Microsoft Security Essentials is a free* download from Microsoft that is simple to install, easy to use, and always kept up to date so you can be assured your PC is protected by the latest technology. It’s easy to tell if your PC is secure — when you’re green, you’re good. It’s that simple.

Microsoft Security Essentials runs quietly and efficiently in the background so that you are free to use your Windows-based PC the way you want—without interruptions or long computer wait times.

Saturday, November 21, 2009

fix: Print Spooler high cpu usage :spoolsv.exe 99% of cpu

1) Stop Print Spooler Services.
2) go to C:\WINDOWS\system32\spool\PRINTERS and delete All the files there. ex. '00020.SHD' and '00020.SPL'.
3)Start print spoler service

Friday, September 25, 2009

how to reinstall blackberry os. OR "reload software 507 " error

source:http://forums.pinstack.com/f73/how_reinstall_os_computer_wont_recognize_device_connected-5178/

Problem: When trying to re-install an operating system that constantly intializes, Desktop Manager will not recognize the device.

Solution:

FYI this will work for any handheld that constantly initializes.. aka the hourglass of doom.

1. Install the desktop software.
2. Install the handheld software. (If it is a non Vendor software.. exp. T-Mobile. search and delete the "vendor.xml" file.)
3. Pull the battery out of your device.
4. With the battery out connect the device to the computer.
5. Go to Options and select "connection settings"
6. Select USB PIN this may take a few moments since there is no battery in the device. you might even have to select detect device in some rare cases.
7. Select the application loader icon.
8. Select all software you want installed.
9. Proceed to the end portion untill you see the "Finish" button.
10. Very IMPORTANT. do not hit the finish button, instead select the ADVANCED button.11. Make sure both boxes are checked.
12. Proceed until it asks you if you want to automatically back up and restore. Select DO NOT AUTOMATICALLY BACK UP MY HANDHELD.
13. Once the process starts. take care not to bump out the cord and re-insert the battery. Again on some rare occasions you might have to wait until it finishes saying connect to insert the battery.

THIS MAY FAIL THE FIRST OR SECOND TIME DONT WORRY JUST KEEP TRYING.

Tuesday, September 22, 2009

Troubleshooting Microsoft Message Queuing in Enterprise Vault.

source:
http://www.symantec.com/connect/articles/troubleshooting-microsoft-message-queuing-enterprise-vault

Troubleshooting Microsoft Message Queuing in Enterprise Vault.

The Don's picture
Troubleshooting Microsoft Message Queues with Enterprise Vault.
Explanation of each queue
Enterprise Vault Exchange Mailbox task for server queue A1
Pending Items that are being updated. Sometimes referred to as post processing, where items are converted from pending to fully archived in user’s mailboxes.
Enterprise Vault Exchange Mailbox task for server queue A2
Individual items to process. Used for manual archive requests and whenever Enterprise
Vault cannot directly communicate with the Storage Archive queue of the Storage service.
Enterprise Vault Exchange Mailbox task for server queue A3
Used whenever a Run Now operation has been executed on the Archiving Task. Lists mailboxes to process.
Enterprise Vault Exchange Mailbox task for server queue A4
Individual items to process. Only used for retries when Enterprise Vault cannot directly
communicate with the Storage Archive queue of the Storage service.
Enterprise Vault Exchange Mailbox task for server queue A5
Mailboxes to process. Used during background archiving. This queue is not processed outside the
scheduled archiving times, so you cannot use Run Now to clear a backlog on this queue.
Enterprise Vault Exchange Mailbox task for server queue A6
Requests to update folders with items that have been moved inside a mailbox. In older versions of Enterprise Vault than version 8, this queue processed synchronization.
Enterprise Vault Exchange Mailbox task for server queue A7
Synchronization Requests. This queue was not included pre-EV8.
Enterprise Vault Exchange Mailbox task for server queue R1
Items to retrieve
Enterprise Vault Exchange Mailbox task for server queue R2
Items ready for retrieval.
Enterprise Vault Spool Queue
Items restored by the Storage service that are now ready to be processed by the Exchange Mailbox task (for retrieval).
Enterprise Vault Exchange Mailbox task for server queue J1
Shortcuts to update and failed operations.
Enterprise Vault Exchange Mailbox task for server queue J2
Items to process.
Enterprise Vault Exchange Mailbox task for server queue J3
Instructs the Exchange Journaling task to examine the journal mailbox for new messages. Up to 250 new messages will be marked as archive pending and a message is placed on queue j2 for each such message.
Enterprise Vault Storage Archive for Exchange Server
Messages to be stored in Vault Store. These messages are divided up into chunks.
Enterprise Vault Storage Restore for Exchange Server
Messages to be restored to Mailbox. These messages are also divided up into chunks.
Things to check and ensure are configured correctly before troubleshooting.
You need to check the system is configured correctly in the first place before proceeding with any troubleshooting. Below is a check list that should assist.
1: Are MSMQ’s installed on a non-system drive as recommended? This can be checked by opening the properties of Message Queuing via Computer Management and reviewing the Storage TAB. The following technote would assist with moving these. http://seer.entsupport.symantec.com/docs/284889.htm
2: Are the MSMQ’s installed in workgroup mode as required? Check via Add/remove Programs and Components.
3: What is the maximum size configured, again contained in properties of Message Queuing via Computer Management and reviewing the General TAB.
4: Ensure you have installed at least Windows 2003SP2, as this contains a huge amount of fixes from Microsoft for message queues.
5: Ensure the MSMQ Storage Location is excluded by Anti-Virus, both scheduled and on-access scans. Failure to do this will cause problems with Enterprise Vault and MSMQ’s.
General Troubleshooting of MSMQ’s
Check the System and Application Event for any errors relating to MSMQ’s.
Identify what queue for example is not processing to try and give you an indication of the issue. For example if the Enterprise Vault Exchange Mailbox task for server queue A1 is not processing then the issue that will occur is that items will not be converted to shortcut in user’s mailboxes and will remain pending until cancelled or timed out. Allot of the time monitoring MSMQ’s will alert you to other issues. For example if items are not being post processed and never placed on the A! queue for an Exchange Server then the issue is most likely the items have not been backed up.
You should also note what aspects of MSMQ’s appear to not be working. Is the issue, only occurring on one Exchange Server’s MSMQ’s? Which queue has the issue? Are other queues working? Can you see items being processed via the queue?
Sometimes enabling the Journaling feature in MSMQ’s can assist with capturing and showing items being processed. To access this open the properties of the queue concerned and enable journaling. A sub-folder under this will show the items captured in journaling. I always find it useful to ensure I have set a limit when I enable this feature, as without this, it is easy to forget that this has been set untul your disk is full!
Also check the permissions on the actual storage location, where the core files are held. Are MQ files being written?
Sometimes it is quicker and easier to simply reinstall the MSMQ’s to resolve issues. The instructions for this are below.
1. Confirm that the Message Queues are empty and determine the MSQM storage location
a. Log in as the Vault Service Account
b. Launch Computer Management
c. Expand "Services and Applications"
d. Determine the location of the MSMQ files. Right-click, Properties of the icon "Message Queuing". Choose the Storage tab and make note of the storage locations. Default is "c:\windows\system32\msmq\".
e. Expand "Message Queuing"
f. Expand "Private Queues" - check to make sure if these are empty. If not, then make sure you understand the ramifications of clearing the queues before doing so.
2. Stop the Enterprise Vault services.

3. Stop the Message Queuing service.

4. Rename the old message queue directory to "msmq_old"

5. Uninstall the message queue from 'Add/Remove Programs - Windows components'

a. This should remove the old directory if it still exists delete the directory.
6. Reinstall the message queues (select 'Common', Active Directory will be selected by default, but is not needed - and causes a performance hit)

7. The Message queue service should automatically start, but if it is not started, start it up.

8. Confirm the newly created msmq directory exists.

9. Restart the Enterprise Vault services

a. The missing message queues will be recreated in "Private Queues" when the Tasks begin to process.
10. Delete the "msmq_old" directory created earlier to reclaim disk space.
a. No reboot should be necessary.
Message queues are recreated by the Enterprise Vault Services. Therefore, you could also, after ensuring the queues are empty, remove these by right clicking and deleting, then restart the Enterprise Vault services. This should recreate the necessary queues.
If you purge data in MSMQ’s (you should take care doing this) you may receive messages in the Enterprise Vault Event Log relating to negative acknowledgements which is normal and can be ignored. Refer to the following technote for further details. http://support.veritas.com/docs/276082
You should also be aware that when monitoring MSMQ’s through a cluster, you will need to connect via Computer Management to the virtual cluster name not the physical name of the nodes. You can right click on Computer Management when this is open in a MMC and select connect to.
There are a number of useful technotes relating to MSMQ’s on the Enterprise Vault Support site, and this should well be worth reviewing before logging a case with Symantec. Refer to http://support.veritas.com

Wednesday, September 2, 2009

Create a Saved Query that Displays Group Members

When you create a Saved Queries in ADUC that will query the members of a particular group, entering the Group Name is not enoguh. You have to enter the "Distinguish name" of the group.


Here's the step by step solution from Jeff Guillet:
http://www.expta.com/2008/02/create-saved-query-that-displays-group.html


•Use ADSIEdit.msc (in the Windows Support Tools) and navigate to the group


•View the properties of the group to reveal the distinguishedName attribute value and copy it to the clipboard (shown above)


•Open ADUC, right-click Saved Queries and select New query


•Enter a name for your query, "Accounting Group Members"


•Click the Define Query button


•Select Users, Contacts, and Groups from the Find: dropdown list


•Click the Advanced tab


•Click Field User Member of


•With the condition of "is (exactly)", paste the group's distinguishedName into the Value field and click Add


•Click OK twice to complete the query

Friday, August 28, 2009

Feeding Crystal Reports from your application(Visual Studio)

Published date: Friday, September 1, 2006
On: Éric Moreau's web site
Original URL: http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx

The article will show you how to use Crystal Report in Visual Studio.

Wednesday, August 5, 2009

Automating Database maintenance in SQL 2005 Express Edition

http://www.sqldbatips.com/showarticle.asp?ID=27

Author: Jasper Smith

Overview

In this series of articles, I'll demonstrate a couple of different approaches to writing a maintenance utility that mimics some of the behavior of the sqlmaint utility that is included with SQL Server 2000. SQL Server 2005 Express Edition does not include such a utility, so these articles will show how we can easily create one ourselves using either TSQL or SMO (SQL Management Objects - the successor to SQL-DMO). Rather than dive into the code, these articles will demonstrate how to use these utilities for backing up and maintaining your databases and how to schedule these tasks using the Scheduled Tasks facility in Windows XP and Windows 2003. In this article we will concentrate on the TSQL version of the utility which is in the form of a stored procedure - expressmaint. To download a command line version built using SMO go to Automating Database maintenance in SQL 2005 Express Edition Part II.


Thursday, May 7, 2009

good stuff about exchange and scripting

SCRIPT: Reset Mailbox Limits
http://www.exchangepedia.com/blog/2006/02/script-reset-mailbox-limits.html

SCRIPT: Show mailbox limits
http://www.exchangepedia.com/blog/2005/10/script-show-mailbox-limits.html


SCRIPT: Show mailbox quotas (including Store & Policy quotas)
http://www.exchangepedia.com/blog/2007/01/script-show-mailbox-quotas-including_17.html

Wednesday, February 11, 2009

VMware ESX vs Microsoft Hyper-V

VMware ESXi vs Microsoft Hyper-V Server 2008
http://www.itcomparison.com/Virtualization/VMwareesxivsHyperv/VMwareesxivsHyperv.htm


Microsoft Windows Hyper-V VS VMware Virtual Infrastructure 3.5
http://itcomparison.com/Virtualization/MShypervvsvi35/HyperVvsvmware35esx.htm

Windows Vista Service Pack 1 Management Tools update for the release version of Hyper-V

Windows Vista Service Pack 1 Management Tools update for the release version of Hyper-V

http://support.microsoft.com/kb/952627

http://blogs.technet.com/virtualization/archive/2008/03/25/hyper-v-manager-mmc-now-available.aspx

The Windows Vista Service Pack 1 Management Tools update for the release version of Hyper-V is now available from the Microsoft Download Center. This update package installs the management tools for the release version of Hyper-V technology on a computer that is running Windows Vista Service Pack 1 (SP1). This update package includes the following items:
The Hyper-V Manager Microsoft Management Console (MMC) snap-inThe Hyper-V Manager MMC snap-in provides management access to servers that are running Hyper-V.
The Virtual Machine Connection toolYou can use this remote connection tool to establish an interactive session on a virtual machine host.

standalone-Microsoft Hyper-V Server 2008 - English

The standalone hypervisor-based virtualization solution

http://www.microsoft.com/downloads/details.aspx?FamilyId=6067CB24-06CC-483A-AF92-B919F699C3A0&displaylang=en

Microsoft® Hyper-V™ Server 2008 is a stand-alone product that provides a simplified, reliable, cost-effective and optimized virtualization solution enabling organizations to improve server utilization and reduce costs. It allows organizations to consolidate workloads onto a single physical server and is a good solution for organizations who want a basic and simplified virtualization solution for consolidating servers as well as for development and test environments. Low utilization infrastructure workloads, departmental applications and simple branch office workloads are also candidates to virtualize using Hyper-V Server 2008. Hyper-V Server 2008 is a cost-effective solution that is convenient because it plugs into existing IT infrastructures enabling companies to reduce costs, improve utilization and provision new servers. It allows IT professionals to leverage existing patching, provisioning, management and support tools and processes. IT Professionals can continue to leverage their individual skills and the collective knowledge of Microsoft tools, minimizing the learning curve to manage Microsoft Hyper-V Server 2008. In addition, with Microsoft providing comprehensive support for Microsoft applications and heterogeneous guest operating systems support, customers can virtualize with confidence and peace of mind.

Tuesday, February 10, 2009

Server Core Installation Option of Windows Server 2008 Step-By-Step Guide

Server Core Installation Option of Windows Server 2008 Step-By-Step Guide

This step-by-step guide provides instructions for building a server in your test lab that is based on the Server Core installation option of the Windows Server® 2008 operating system. It includes information about installation, initial configuration, and managing a server that is running a Server Core installation.

http://technet.microsoft.com/en-us/library/cc753802.aspx

Release Update NB_CLT_6.5.2.WIN2008SC.x86.exe provides platform proliferation for the Veritas NetBackup (tm) Enterprise Server / Server 6.5 Clients on

Release Update NB_CLT_6.5.2.WIN2008SC.x86.exe provides platform proliferation for the Veritas NetBackup (tm) Enterprise Server / Server 6.5 Clients on Microsoft Windows 2008 Server Core.


http://seer.entsupport.symantec.com/docs/304423.htm

Group Policy Settings Reference for Windows Server 2008 and Windows Vista SP1

This spreadsheet lists the policy settings for computer and user configurations included in the Administrative template files (.admx/.adml) delivered with Windows Server 2008 and Windows Vista Service Pack 1 (SP1).

http://www.microsoft.com/downloads/details.aspx?familyid=2043B94E-66CD-4B91-9E0F-68363245C495&displaylang=en