Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
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
Medium Priority
?
538 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
  • 2
12 Comments
 
LVL 44

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 42

Accepted Solution

by:
Adam Brown earned 2000 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 44

Expert Comment

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

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
 
LVL 42

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 42

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 42

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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
This video discusses moving either the default database or any database to a new volume.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

704 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