Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL Server migration for EV 10.0.1

Created: 29 Aug 2012 • Updated: 29 Aug 2012 | 3 comments
This issue has been solved. See solution.

Hi,

Does anyone knows the process for migrating Enterprise Vault SQL databases from old server to a new server for increased capacity and moving to 64bit OS for SQL please?

Basically currently we have EV databases on a SQL server - windows 2003 32bit OS and SQL 2005

We would like to move those databases to a new SQL server windows 2008 R2 - SQL 2008

Please let us know the steps and any concerns that we need to keep in mind?

Many Thanks

Comments 3 CommentsJump to latest comment

AmolB's picture

Refer to http://www.symantec.com/docs/TECH35744

LCT's picture

One vital note from the technote that Amol pointed out.

  • Make sure the collation set on the New SQL server is EXACTLY the same as set on the Old SQL server, or there will be collation mismatches.

This will cause major/critical errors if they don't match and it will be messy.

SOLUTION
ia01's picture

Thanks very much! Really appreciate your help