Solved

Migration 1 SQL Server for new SQL server by commvault


Userlevel 3
Badge +13

Hello,

the cliente need to migrate MS SQL Server database for the new server by Continuous Data Replicator.

Someone already made this procedure and can help me?

I install SQL Server in 2 servers and add to Commcell.

Current version of Commvault: 11 SP 13+

**Do i need to upgrade Commvault before migrating?

Current version of SQL: 2012

And the cliente is asking to me what the best version will migrate? 2019 standard or enterprise?

 

icon

Best answer by Sean Crifasi 13 May 2021, 20:11

View original

89 replies

Userlevel 5
Badge +13

It is license related. You have 3 licenses for the 3 production servers however there is a 4th server named sql01 where you are trying to run a job, not sure if a backup or a restore because you don’t provide the right details.

Release SQL license in sql01 if you are running a restore, if you are running a backup, buy additional licenses or release one for the three SQL production servers.

Userlevel 3
Badge +13

Hello @Ledoesp @Mike Struening @Sean Crifasi 

i made the restore of the database(production) to the new machines, but i´m getting this error, i think is related to licensing, could you help me?
Or am i doing wrong?

i have 3 three license for MS SQL, ok?
 

Production servers:
 

 

New servers:
 

 

Userlevel 3
Badge +13

Hello Guys,

How can i remove this? i created last month and i don´t know how to remove. This is a test.

 

Userlevel 3
Badge +13

Hello 

@Ledoesp @Mike Struening @Sean Crifasi 

The sql database admin verified the restore and it´s OK.

Then now i need to replicate to another SQL Database, in the same version, 

Do i use “Live Sync” or “Continuous Data Replicator" to replicate database SQL?

 

Userlevel 3
Badge +13

Procedure:
 

Select the MS SQL Database

Recover All Selected

Example:
Change the destination cliente and path

and after “Job Controller”

ok?

 

 

 

 

 

Userlevel 3
Badge +13

Hello

@Ledoesp @Mike Struening @Sean Crifasi 

I was able to do thanks for all!! i´ll put the procedure that i made here.

Userlevel 4
Badge +9

Hi @Fernando Souza 

 

  • Can you confirm the databases are configured in full mode on the sql server?
  • Have you completed an initial full backup of the SQL subclient yet?

You must have a backup in order to perform a Live Sync operation. If you have installed the SQL Server agent on the client, but have not yet performed a backup, then the software does not display any databases in the SQL Live Sync Options dialog box.

Note: You can only use the Live Sync feature with SQL databases that use the Full Recovery model.

https://documentation.commvault.com/commvault/v11/article?p=92004.htm

Userlevel 5
Badge +13

you have to follow these steps: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-to-a-new-location-sql-server?view=sql-server-ver15

Userlevel 3
Badge +13

All these MS SQL Database restores brings *.bak
Example:

 

Userlevel 3
Badge +13

Hello @Ledoesp @Mike Struening 

In short, i was unable to do it, continue to restore *.bak files.

 

Userlevel 5
Badge +13

https://documentation.commvault.com/commvault/v11_sp20/article?p=61506.htm

Yes you restore to disk and you get these files, now you can try to use Management Studio to restore from these files or select the additional option Attach to SQL server.

Userlevel 3
Badge +13
  1. All Tasks\Browser and Restore

Restore do Disk:
 

View Content:
Test_Mirroring Database

Recover All Selected

 

Userlevel 3
Badge +13

Hello @Ledoesp 

i use this for restore to Disk:
https://documentation.commvault.com/commvault/v11_sp20/article?p=112754.htm

but still restore *.bak Files:
 

 

Userlevel 5
Badge +13

Fernando, perform a database restore from the console, once you have performed the SQL database backup from our SQL agent. You have a simplified restore, just select the right choice for you: https://documentation.commvault.com/commvault/v11_sp20/article?p=112786.htm

Userlevel 3
Badge +13

Hello @Ledoesp @Mike Struening 

I need to restore the MDF and/or LDF files. How can i do this?

 

Userlevel 5
Badge +13

As a summary, you have already working in your lab the SQL Live Sync between source SQL client publico01 and destination SQL client publico02. Live Sync for SQL is used to have and SQL standby server in sync for the instance and databases specified from a source production machine. For performing a migration from 1 server to another, it is enough performing backup on source and restoring to destination.

For configuring now CommServe Live Sync, follow the documentation starting with the prerequisites: https://documentation.commvault.com/commvault/v11_sp20/article?p=102842.htm

Userlevel 3
Badge +13

I need to replicate to another server, this is a Laboratory.

But when i finish the LyveSync setup, it does nothing; and i saw that CommServe LiveSync” is not installed:
 

 

Userlevel 3
Badge +13

Yes, 

And the database appears to be made the Sync:
 

 

Userlevel 5
Badge +13

Are you planning now to configure CommServe Live Sync between a production CommServe and a standby CommServe? 

Userlevel 3
Badge +13

Hello @Ledoesp @Mike Struening 

Do i need to install CommServe LiveSync package in my CommServe?
 

 

Userlevel 3
Badge +13

Hello @Ledoesp 

ok, i will make the change and then I will let you know.

thanks

Userlevel 5
Badge +13

CDR stands for Continous Data Replication, so having the phase of Replication in Unavailable is normal status.

Why are you still using CDR? I already mentioned a few times that is not the proper way to migrate SQL from source machine to destination machine. You have already configured SQL Live Sync, this relies on SQL agent for backup and restore, CDR is not needed for SQL Live Sync to work so please don’t use it.

 

Userlevel 3
Badge +13

@Mike Struening @Ledoesp 

Some questions to ask you:
1) After preparing the CDR for another server, didn´t migrate the transaction logs, does anyone know why this doesn´t work?
Note: I had already setup to configure Live Sync and CDR.
2) Do i need to use live sync with the CDR and do a full backup before setup it on the CDR?

Userlevel 7
Badge +23

As long as you have a valid maintenance contract for that lab, you can call in a ticket.  It might not get Premier support, but you can check.

Userlevel 3
Badge +13

@Mike Struening 

The environment is in Lab and need to apply this in the cliente. 

Reply