Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Migration to SQL?

Updated: 21 May 2010 | 9 comments
Charlatat's picture
0 0 Votes
Login to vote
This issue has been solved. See solution.

SEPM 11.0.4202.75 on Windows Server 2003 R2
SQL Server 2008 Standard SP3 on Windows Server 2008 SP2

Looking to migrate our default database to SQL Server. Are there any articles that someone can point me to, for this process?  Read a few forum posts regarding creating the SQL database upon installation, so would it be better to wait until the MR5 release and take care of both at once (migration to SQL and upgrade SEPM)? Any advice would be appreciated.

Comments

kavin's picture
24
Aug
2009
0 Votes 0
Login to vote

If you only want to move the

If you only want to move the database then check this document

 

http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2008041601053448

If you want to move the SEPM & the database then check this document

 

http://service1.symantec.com/support/ent-security.nsf/docid/2008031204405448

 

AravindKM's picture
24
Aug
2009
1 Vote -1
Login to vote

SQL 2008 is not supported yet

SQL 2008 is not supported yet so you have to stick to 2005.
https://www-secure.symantec.com/connect/forums/database-migration-intergrated-sql-express
Pls refer the below link for migration
http://service1.symantec.com/support/ent-security.nsf/docid/2008063014073748

Please don't forget to mark your thread solved with whatever answer helped you : ) Thanks & Regards Aravind

kavin's picture
24
Aug
2009
2 Votes 0
Login to vote

I dont agree with Arvind we

I dont agree with Arvind

we do can install SEPM on SQL 2008 server.

Prachand's picture
24
Aug
2009
0 Votes 0
Login to vote

I agree with Kavin, SEPM can

I agree with Kavin, SEPM can be installed with SQL 2008 server but it is not supported.

Yes, it is possible to install the Symantec Endpoint Protection Manager using SQL Server 2008 as the backend, but the procedure for the same is at present unsupported, since the present builds of the SEPM do not recognize SQL 2008 as a valid backend source, unless manually specified.

I would advice you to wait for some more time as MR5 will be relaesed in the early part of Sep, 2009  which will have support for SQL server 2008 and 2008 R2 both

Waiting for 2 weeks will minimize your  efforts when MR 5 is released

Prachand Kumar MCSE-2003 Symantec Technical Specialist (SCTS)

kavin's picture
24
Aug
2009
0 Votes 0
Login to vote

Yes waiting for MR5 will be a

Yes waiting for MR5 will be a good option accourding to me as well.

Charlatat's picture
24
Aug
2009
1 Vote -1
Login to vote

will wait then, thanks much

will wait then, thanks much for the responses.

kavin's picture
24
Aug
2009
0 Votes 0
Login to vote

Please mark a solution to

Please mark a solution to this thread if your issue is resolved.:)

teiva-boy's picture
24
Aug
2009
1 Vote +1
Login to vote

 Interestingly enough, moving

 Interestingly enough, moving to SQL from the embedded database is well documented in the installation guide.  

Who knew that a manual which is a document not a person named Manuel....  Has real useful information...

If you are a man, suck it up and look through the "Installation guide."  It's documented with step by step instructions.  Oh dont forget the DR section as well, it's quite informative too.


There is an online portal, save yourself the long hold times. Create ticket online, then call in with ticket # in hand :-) http://mysupport.symantec.com "We backup data to restore, we don't backup data just to back it up."

Charlatat's picture
25
Aug
2009
0 Votes 0
Login to vote

Wow, didn't know that waiting

Wow, didn't know that waiting for the release to MR5 was in the manual!!  Symantec, you guys rock!!