Video Screencast Help

ENTERPRISE VAULT FILE SYSTEM ARCHIVING SQL Requirements

Created: 15 Oct 2012 • Updated: 09 Nov 2012 | 7 comments
This issue has been solved. See solution.

Hi,

Can anybody tell me if Enterprise Vault File System Archiving will be compatible using SQL Server Workgroup 2008R2 as the database?

Comments 7 CommentsJump to latest comment

MikeFindlay's picture

Hi,

Version 10.0

I have the document but there is no mention of :

SQL Server Workgroup 2008R2

AmolB's picture

If its not listed in the compatibility list than its not supported by Symantec.

JesusWept3's picture

OK so...
If its not listed, its not supported, doesn't mean that it won't work, just means it wasn't tested with EV and not QA'd, so if you have any SQL based issues and call in a case, this may be flagged and may be asked to move it to a Standard installation to see if it works.

There are some limitations of Workgroup edition.
Mainly that it will only use 2 Cores maximum and 4GB of memory maximum, so if you have a Quad Core or more type of machine with more than 4GB of memory, those resources will not be utilized

Also if you plan on using FSA reporting or operations reports through SQL Server Reporting Services, you will not be able to use them because Workgroup edition, like Express and Web editions do not allow custom datasources that EV sets up when you deploy reports

That being said, it does not have any database size restrictions like Express does (Express only supports a 10GB database, which you will more likely than not exceed), workgroups maximum database size is 524PB

Based on this technote, Workgroup edition does at least meet the minimum memory and CPU requirements
http://www.symantec.com/business/support/index?page=content&id=HOWTO28239

Jeff Shotton's picture

It doesn't even meet the base specs required by Enterprise Vault (8GB RAM for SQL) so im not surprised it isn't listed.

You might want to read this :)

SQL Best practices : http://www.symantec.com/docs/DOC5365

Regards,

Jeff

Jeff Shotton

Principal Consultant

Adept-tec Ltd

Website: here

Jeff Shotton's picture

I should add, having just seen the post by Alex, that the base SQL spec was raised (doubled) in EV10. It meets the base spec for older versions of EV.

 

Jeff Shotton

Principal Consultant

Adept-tec Ltd

Website: here

JesusWept3's picture

Yup, its good for test environments, but would never recommend it for production. I mean honestly it will work, just won't work very well...also the document was from 2010, so just around the Ev9 time frame

SOLUTION