cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

epo db backup and restore

Hello

i am not much familar with sql, please guide me the syntax to backup sql and restore.

I am planning to migrate ePO4.5 on windows server 2003 x86, SQL 2005 to a VM  on windows server 2008 x64 R2 and SQL 2008 R2 and go with ePO4.6

I tried to backup sql using OSQL command but it is giving me errors.

My Physical machine hostname is AVS, Database name : EPODB

  osql -E -S ePO4_AVS\EPODB -n -Q "BACKUP DATABASE  [EPODB] TO DISK = 'C:\backup.bak' WITH INIT,SKIP" (please correct this syntax)

and also please guide me the syntax to restore.

The new VM will also have the same old hostname and the same DB name and i want to export the database on SQL 2008 R2

osql -E -S ePO4_AVS\EPODB -Q "RESTORE DATABAE ePO4_AVS FROM DISK='C:\backup\backup.bak' WITH MOVE 'ePO4_AVS TO

'c:\SQL\data\ePO4_AVS.mdf' , MOVE 'ePO4_AVS_log' TO 'c:\SQL\data\ePO4_AVS.ldf'" (correct the syntax please)

3 Replies
Hem
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 4

Re: epo db backup and restore

SQL mangement studio will give you GUI to backup and store the DB. Please look at KB#: https://kc.mcafee.com/corporate/index?page=content&id=KB52126&actp=search&viewlocale=en_US&searchid=...

Re: epo db backup and restore

can you please correct the syntax

alexn
Level 14
Report Inappropriate Content
Message 4 of 4

Re: epo db backup and restore

Also follow, KB66616 for upgrade to a new machine when system types are different, its really important that you are transferring ePo from x86 to x64, so you must be carefull and follow exactly according to KB.

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community