02-19-2015 10:35 PM
hi.
I migrate backup exec 2010 r2 from windows server 2008 r2 to another same version server.
All windows update and backup exec update are installed before migration.
I follow the instruction on the site.
But after migration i get error when i started the service "backup exec server"
The Backup Exec Server Service detected a schema version mismatch
The Backup Exec Server Service did not start. An internal error (-536813108) occurred in object 1
i use bemig and start the service again, but got the error.
I tried to restore BE to another server and got the same problem.
Can anybody help me?
02-19-2015 11:04 PM
Did you install the exact same version of BE on the new server, i.e. BE 2010 R2 ?
This usually occurs if a newer version of BE is installed on the new server and older DB is used. If you have a backup of the existing DB, stop all BE services, open a cmd and browse to the BE directory. Run the following command. Once the command completes successfully, try to restart all BE services and check.
bemig
02-19-2015 11:28 PM
Yes, on new server installed BE 2012 R2.
02-20-2015 12:08 AM
Would you open the BE executable and provide me the exact same version ? Thanks.
Secondly, open a cmd and browse to the BE directory. Run the following command and attach the output:
beserver.exe -console
02-20-2015 02:16 AM
see attach
02-20-2015 02:17 AM
version
02-20-2015 02:28 AM
Open a cmd and browse to the BE directory and run the following command:-
bemig
Does this complete successfully ? If yes, are you able to restart all BE services successfully ?
02-20-2015 02:39 AM
I ran this command before and it did not give effect.
02-20-2015 02:48 AM
The bemig seems to have completed successfully. Are you receiving the same error after running bemig and restarting all BE services (including the SQL instance) ?
If yes, would you list the exact steps which you took to migrate BE server over ? (Specifically the steps regarding the BEDB)
And is the new server name or different ?
02-20-2015 03:14 AM
I use this instruction
http://www.symantec.com/business/support/index?page=content&id=TECH67768
describe all the steps it is very long
I was confused by the fact that the command
SELECT partitionname FROM datapartition
gave me a blank
I could not migrate .*BKF data because they are stored on another device and shared.
Name of old and new servers are different.
02-20-2015 03:39 AM
In a nutshell, follow these steps instead:
1) Install same version of BE on the new server.
2) Do not launch the console and stop all BE services including the SQL instance.
3) Rename the newly created Data & Catalog folders to something else such as Data_Old, Catalogs_Old and paste the Data & Catalogs folder which were copied from the old BE server install.
4) Start only the SQL instance and not the BE services.
5) Open a cmd (using elevated rights) and run the following commands to update the server name in the DB:-
Sqlcmd -E -S servername\BKUPEXEC
Use bedb
<Press enter>
Type go
<Press enter>
SELECT partitionname FROM datapartition
<Press enter>
Type go
<Press enter>
The old server name should be listed.
UPDATE DataPartition SET PartitionName='<new server name>' WHERE PartitionID =0
<Press enter>
Type go
<Press enter>
Exit from the cmd. Backup the registry and then delete the Adamm\MachineGuid key.
6) Now start all BE services.
02-20-2015 08:01 AM
5)
C:\Program Files\Symantec\Backup Exec>Sqlcmd -E -S srv-bckp-kuba\BKUPEXEC
1> use bedb
2> go
Changed database context to 'BEDB'.
1> SELECT partitionname FROM datapartition
2> go
partitionname
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
---------------
(0 rows affected)
1> UPDATE DataPartition SET PartitionName='srv-bckp-kuba' WHERE PartitionID =0
2> go
(0 rows affected)
1> SELECT partitionname FROM datapartition
2> go
partitionname
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
---------------
(0 rows affected)
1> quit
6) I get same error then start service backupexec.
Maybe problem in partition name in sql what name of instanse on old server is MSSQLSERVER? instanse name on new server - BKUPEXEC.
02-22-2015 07:32 AM
Do you still have the old BE media server available ?
If yes, it would be easier to move over to the default SQL instance and then perform the migration. This KB can be used for moving the SQL instance - http://www.symantec.com/business/support/index?page=content&id=TECH37752
02-25-2015 06:25 AM
I start beutility on new server.
select my server.
choose New Backup Exec database location
cureny instanse SRV-BCKP-KUBA\BKUPEXEC
new instanse SRV-BCKP-KUBA\MSSQLSERVER
sql instanse on old server is srv-fs2-kuba\mssqlserver
I get error
Изменить расположение базы данных Backup Exec
Не удалось получить доступ к ключу реестра на выбранном сервере SRV-BCKP-KUBA, чтобы узнать номер версии SQL Server.
Операция по переносу базы данных Backup Exec в экземпляр SQL Server SRV-BCKP-KUBA выполнена с ошибками.
I use russian language on server
Translate this error
Change the location of the Backup Exec database
Failed to access the registry key for the selected server SRV-BCKP-KUBA, to check the version SQL Server.
The operation to transfer the Backup Exec database to an instance of SQL Server SRV-BCKP-KUBA is unsuccessful.
02-25-2015 08:13 AM
Is MSSQLSERVER the new instance on the new server ?
02-25-2015 09:18 AM
Curent (old) instance on the new server is BKUPEXEC
02-25-2015 05:53 PM
You should move the BEDB on the old server from the SQLSERVER instance to the BKUPEXEC instance and then migrate the database to the new server using the BKUPEXEC instance.
There is no point in migrating the BEDB from the BKUPEXEC instance to the SQLSERVER instance on the new server.
02-25-2015 11:05 PM
well, my action steps
1) On old server change sql instanse from MSSQLSERVER to BCKPEXEC using beutility.exe.
2) Migrate data and catalog folders from old server to new server.
3) Start all services on new servers.
Right?
02-25-2015 11:21 PM
Pretty much yes. You'll have to also update the BEDB with the new server name. Follow the steps which I had posted earlier.
02-27-2015 02:18 AM
On old server I get error
Изменить расположение базы данных Backup Exec
Не удалось получить доступ к ключу реестра на выбранном сервере SRV-BCKP-KUBA, чтобы узнать номер версии SQL Server.
Операция по переносу базы данных Backup Exec в экземпляр SQL Server SRV-BCKP-KUBA выполнена с ошибками.
Translate this error
Change the location of the Backup Exec database
Failed to access the registry key for the selected server SRV-BCKP-KUBA, to check the version SQL Server.
The operation to transfer the Backup Exec database to an instance of SQL Server SRV-BCKP-KUBA is unsuccessful.