Hi, i have semp 12.1 RTM with a SQL Server 2000, so i cant upgrade to the latest version of SEPM 12.X cause SQL Server 2000 isnt supported. My question is if i change the database using the Managemente Server Configuration Wizard to a new blank database on another server (with SQL 2008)  i will loose all the clients, policies, and another configurations? Or i will loose only the historical data?

You can follow this KBA

Migrating to Microsoft SQL 2008 from a previous version

YEs if you point to the new SQL Blank database obviously you will loose the group structure policy everything.

So you can refer these articles and it will help you to fix the issue and give you a bette picture about SQL DB Migration of SEPM.

Best Practices guide to moving the Symantec Endpoint Protection Manager SQL Server database from an existing SQL Server database to a new SQL Server database

http://www.symantec.com/docs/TECH104723

How to move the Symantec Endpoint Protection Manager SQL database to a new SQL Server

http://www.symantec.com/docs/TECH174821

Moving the SEPM database to a new SQL server or instance using SQL backup/restore.

http://www.symantec.com/docs/TECH132761

Hope this helps...........

Yes, you will loose all the existing database means policies, configuration etc.

Best Practices guide to moving the Symantec Endpoint Protection Manager SQL Server database from an existing SQL Server database to a new SQL Server database

http://www.symantec.com/docs/TECH104723http://www.symantec.com/docs/TECH104723

Best Practices guide to moving the Symantec Endpoint Protection Manager SQL Server database from an existing SQL Server database to a new SQL Server databas

http://www.symantec.com/docs/TECH167300

Thanks to all, i will do the migration in a couple of days.

Hi

Please refer the article below if it helps

http://www.symantec.com/business/support/index?page=content&id=TECH104723&actp=search&viewlocale=en_US&searchid=1368159554513

Regards

Check it.

How to move the Symantec Endpoint Protection Manager SQL database to a new SQL Server

Best Practices guide to moving the Symantec Endpoint Protection Manager SQL Server database from an existing SQL Server database to a new SQL Server database

http://www.symantec.com/business/support/index?page=content&id=TECH104723&actp=search&viewlocale=en_US&searchid=1337691896765

Hi again, im trying to move the DB from the SQL 2000 to 2008. I do all the procedure with no problems but when i run the management server configuration wizard, when i change the sql server location i get the error: "Error- Preparing Database. Invalid object name "LOCAL_METADATA".

Any suggestions?

Check this

Article URL http://www.symantec.com/docs/TECH157962

Hello

Kindly confirm have you tried the above attach link, what is the current status of your issue.

If it resolve then please Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.

HI, 

Have you got your problem resolved please mark the comments which helps you as solution.

Regards

Ajin