New ePo 4 DB in SQL 2005

Hello all,
I would like to create an ePo 4 server for testing purposes. I would like to setup the ePo DB on another SQL 2005 server, can anyone please provide me some guidelines/steps on how to create my SQL 2005 DB for ePo 4 on another SQL server?

Also, I have a production ePo server, would it be easier to simply backup the current SQL DB and create the test one with by restoring it in the test SQL 2005 server? if yes, can you please explain me how to?

Thank you all for your inputs!

P.S: Please let me know if more information is required
SecureOps-01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Since I am not aware of ePo server, Shall I assume its a database created by some application.

In that case if you want to backup the database from production server and restore it in your test server.

http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups

Just follow the steps given in the link above which contains steps for both SSMS and using T-sql scripts.

Hope this helps.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SecureOps-01Author Commented:
Thank you for the quick guide, but I was under the impression that I had to create the ePo DB manually, which wasn't the case. The Database is automatically created during the installation of the ePo server.

Nonetheles, thank you for the information and effort.
0
B-dataCommented:
Hello.

I have a problem similar to this. Though im trying to install EPO 4.5 evaluation on 64-bit system. On 64 bit it cannot install its own SQL DB. So i have installed SQL 2005 express and just created a "new database" called EPOSERVER. But my problem is that it cannot find the database server. Not sure if i have created the database right?

Can anyone give me some advice?

Thank you
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Robert_ITCommented:
B-Data,
Sounds like you should open a seperate question on the topic, but EPO can create a new instance of a database on it's own.
When I installed 4.5, I put the SQL database on the same hardware (test lab). Used SQL 2008 on a Windows 2008 platform without any issues.
Install following the directions, and you should be ok. Just ensure that you account has appropriate rights on the server, and the ports are opened up. All of this is covered in the manual, so I not going to go into details here.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> But my problem is that it cannot find the database server

B-data, Can you explain what you meant by that..
Have you checked in the appropriate server instance.
0
B-dataCommented:
Sorry. im new to this forum.

Its the Mcafee installation that asks for a database. When i type in the servername it doesnt recognise the database. I have not checked in the appropriate server instance?, im new to SQL aswell.

So i still havent got the EPO server installed because i could not get past this problem with the database.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.