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

Posted on 2010-09-16
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 250 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...
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Utilizing an array to gracefully append to a list of EmailAddresses
Find out what you should include to make the best professional email signature for your organization.
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
how to add IIS SMTP to handle application/Scanner relays into office 365.

749 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