Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Create a secondary Exchange 2007 DB on live production server for testing

Posted on 2010-09-16
Medium Priority
Last Modified: 2012-08-13
Hi I need to create a secondary Exchange 2007 DB on live production server for testing
I am not sure how abouts to do this without risking anything
we have a 3rd party company that is implement a contact management database that is accessed through https://x.x.x.x that they will push updates to the Exchange Server, and they jus twant to test this with a test DB in our production environment.

pls advise.
Question by:nutekconsultants
  • 2
  • 2
  • 2
  • +1

Expert Comment

ID: 33696768
Generally speaking you can create another storage group and do your testing with out any major issues. BUT when you want to do testing on mail redirection and spam filters and other intresting things you will affect everyone if you are not careful... Doing testing on production is almost always a bad idea especially when you are not sure of the implications. I would say get a test box and run your tests on that:)

Author Comment

ID: 33696998
So I think i know how to create a new test Storage group in ESM 2007, but how can I make a copy of the current production DB and "paste" it into the new test storage group... I understand where you are coming from Royco2 - I feel the same about doing this in an production environment, but the company is limited with budget.... and cannot aford a test server for this, hence I am forced to do this on live production, I will ensure backups are done though

Accepted Solution

royco2 earned 1000 total points
ID: 33697037
I believe it will go down the path of (requires a bit of research on the net for the commands) -
1. take a backup of your data
2. restore to a restore storage group
3. move to new storage group

I think you would be ok with the restore as long as you dont link the mailboxes to the users... mind you i have NEVER tried doing something like this and still would say, do this on a different test box before proceeding...
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 32

Expert Comment

ID: 33697045
you best bet for this is going to be to create the second database with test accounts
you cannot access a database within the recovery storage group with any type of client
LVL 32

Expert Comment

ID: 33697049
otherwise you need to build out a lab environment to restore your database and deploy this third party solution for testing

Expert Comment

ID: 33697428
Create a new storage group

Create a new Database

Create some test accounts and mailboxes in the new database.
or if you already have test accounts, move their mailboxes to the new storage group\database

Ensure you have enough storage to accommodate a new database and corresponding log files.

Author Comment

ID: 33705522
so i have created a new storage group on difft partition on the exchange 2007 server
i am now going to make a full backup using symantec be 12.5
then restore it to the new storage group
then i will tell the 3rd party company to do what they need to do

it should be ok i think?>


Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

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

This article describes Top 9 Exchange troubleshooting utilities that every Exchange Administrator should know. Most of the utilities are available free of cost. List of tools that I am going to explain in this article are:   Microsoft Remote Con…
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
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…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

578 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