Solved

I need to create a new Storage Group on an Exchange 2007 server and move mailboxes from an old Exchange 2007 server to the new Store Group on the newer Exchange 2007 server

Posted on 2013-06-13
12
517 Views
Last Modified: 2013-06-27
We have two exchange 2007 servers in the office I work out of. Both are running Exchange 2007. The new of the two is more robust and we went to get all the mailboxes moved over to it. We already have 5 Storage Groups built on the new server and I have been told that is the limit with Exchange 2007 standard. I have also been told that one of the current storage groups (Management) only has about 5 users in it and I need to move everyone out of it and delete it, so I can create one called "terminated" for our terminated user's mailboxes. My question starts with; How can I see who is actually in the Management Storage Group? I certainly do not want to delete the group with users still in it, much less managers! If I right click the group and look at properties, I do not get any info on which mailboxes are stored there and if I look at each individual mailbox I can see which server they are on, but I do not see the actual Storage Group. Am I missing something or is there perhaps a shell command that will list all the users in a particular storage group?
0
Comment
Question by:Thor2923
  • 5
  • 5
  • 2
12 Comments
 
LVL 42

Expert Comment

by:Amit
ID: 39245347
Mailboxes are stored at DB level no at SG level. Use below cmd
Get-MailboxStatistics -Database "Your DB Name"
0
 
LVL 38

Accepted Solution

by:
Adam Brown earned 500 total points
ID: 39245353
You'll have to go into the Exchange Management Shell to get this information easily. Open the shell and run
get-mailbox | select username,database
to determine which databases each users' mailbox is on. You can add
| export-csv c:\file.csv
to the end to export the data to a CSV that can be opened in Excel.

The shell handles stuff by database rather than storage group. The default function of 2007 is to have one database per storage group, so this is fine. Exchange 2010 did away with the storage group concept altogether. You can view users in a specific database by running:
get-mailbox | where {$_.database -eq "databasename"}

Once you have the info, you could run this to move the mailboxes to a new database:
get-mailbox | where ($_.database -eq "databasename"} | move-mailbox -targetdatabase "targetdatabasename"
0
 
LVL 1

Author Comment

by:Thor2923
ID: 39245431
I found something called a "systemmailbox with a name like this; SystemMailbox{4231D9C3-E943-40D8-B17B-06C4C7B5B01B}

Does that look like something that was built into exchange? Does it look like something I need to worry about copying over to the new server and new database?
0
 
LVL 42

Expert Comment

by:Amit
ID: 39245448
Don't need to copy these mailboxes.
0
 
LVL 38

Expert Comment

by:Adam Brown
ID: 39245452
SystemMailboxes are usually there to act as storage when emails are in the process of arbitration. They can be moved and removed without too many problems, but I would recommend moving it to a new database rather than removing, since you need to have those mailboxes. You won't be able to delete the database it's on without moving it.
0
 
LVL 1

Author Comment

by:Thor2923
ID: 39249062
when I do the Get-MailboxStatistics -Database  command in shell, I see a system mailbox in the database I need to delete, however I do not see it listed in the Exchange management console with the rest of the mailboxes. How can I move that to another database?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 38

Expert Comment

by:Adam Brown
ID: 39249117
you can use
get-mailbox | move-mailbox -targetdatabase databasename
to move all mailboxes. If the system mailbox is an arbitration mailbox, do this:
get-mailbox -arbitration | move-mailbox -targetdatabase databasename
0
 
LVL 1

Author Comment

by:Thor2923
ID: 39253719
well I have my database down to one system mailbox. I have tried to move it with the;

get-mailbox | where {$_.database -eq "ManagmentDB"} | move-mailbox -targetdatabase "BenefitsDB

and everything appears to run, but then I try the Get-MailboxStatistics -Database command and get the results below, displaying there is still a system mailbox in the ManagementDB database. Does this appear like something I should be concerned with? Will I have to remove this database so I can create a new one?





[PS] C:\Windows\system32>Get-MailboxStatistics -Database "ManagementDB"

DisplayName               ItemCount    StorageLimitStatus         LastLogonTime
-----------               ---------    ------------------         -------------
SystemMailbox{7D43BF29-FA 402                  BelowLimit   6/7/2013 3:32:34 PM
52-47BF-9FA1-DC0B4CFF536A
}
0
 
LVL 38

Expert Comment

by:Adam Brown
ID: 39253864
It does take some time for the move to complete. How long did you wait?
0
 
LVL 1

Author Comment

by:Thor2923
ID: 39254096
it has been a few hours now and I re reran the move command, it is like that mailbox is not meant to move. I can dismount the database and remount but that does not change anything.
I can probably live without this mailbox, but not sure it will let me remove the database with it still existing
0
 
LVL 1

Author Comment

by:Thor2923
ID: 39254099
this is my screen and the two commands I ran.  As you can see after the second command I still have one mailbox

[PS] C:\Windows\system32>get-mailbox | where {$_.database -eq "ManagmentDB"} | m
ove-mailbox -targetdatabase "BenefitsDB"
[PS] C:\Windows\system32>Get-MailboxStatistics -Database "ManagementDB"

DisplayName               ItemCount    StorageLimitStatus         LastLogonTime
-----------               ---------    ------------------         -------------
SystemMailbox{7D43BF29-FA 402                  BelowLimit  6/17/2013 2:22:34 PM
52-47BF-9FA1-DC0B4CFF536A
}
0
 
LVL 38

Expert Comment

by:Adam Brown
ID: 39254463
Oh. Add the -arbitration switch after get-mailbox on the move command. So
get-mailbox -arbitration | where {$_.database -eq "ManagmentDB"} | move-mailbox -targetdatabase "BenefitsDB"
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now