VMware Cloud Community
Xuti
Contributor
Contributor
Jump to solution

Backup SQL Server 2016 with vsphere Data Protection 6.1.3

Hello,

I have a small lab where I am testing VDP 6.1.3. This appliance is backing up some VM successfully. I have installed SQL server agent in a server with Windows Server 2016 and SQL Server 2016. I get This error:

2017-02-27 20:00:16 avsql Info <5008>: Logging to C:\Program Files\avp\var\XutiLabSQL-XutiLabSQL-1488222002981-3006-SQL.log

2017-02-27 20:00:18 avsql Info <6673>: CTL listening on port 57495

2017-02-27 20:00:18 avsql Info <10684>: Setting ctl message version to 3 (from 1)

2017-02-27 20:00:18 avsql Info <16136>: Setting ctl max message size to 268435456

2017-02-27 20:00:18 avsql Info <17376>: Working on stand alone environment.

2017-02-27 20:00:18 avsql Info <7838>: - Adding user exclude "*/tempdb"

2017-02-27 20:00:18 avsql Info <18482>: Adding SQL Database '*/tempdb' to EXCLUDE list

2017-02-27 20:00:18 avsql Info <19484>: ===> sqlconnectimpl::check_smo_version

2017-02-27 20:00:18 avsql Info <19484>: ===> sqlconnectimpl::get_smo_version

2017-02-27 20:00:18 avsql Info <19482>: Found assembly: 'Microsoft.SqlServer.Smo,fileVersion="12.0.2000.8",version="12.0.0.0000",culture="neutral",publicKeyToken="89845DCD8080CC91",processorArchitecture="MSIL"'

2017-02-27 20:00:18 avsql Info <19483>: Returning from SMO version check with value: 16

2017-02-27 20:00:18 avsql Info <0000>: <=== sqlconnectimpl::get_smo_version

2017-02-27 20:00:18 avsql Info <19484>: ===> sqlconnectimpl::get_smo_version

2017-02-27 20:00:18 avsql Info <19482>: Found assembly: 'Microsoft.SqlServer.Smo,fileVersion="12.0.2000.8",version="12.0.0.0000",culture="neutral",publicKeyToken="89845DCD8080CC91",processorArchitecture="MSIL"'

2017-02-27 20:00:18 avsql Info <19483>: Returning from SMO version check with value: 16

2017-02-27 20:00:18 avsql Info <0000>: <=== sqlconnectimpl::get_smo_version

2017-02-27 20:00:18 avsql Info <0000>: <=== sqlconnectimpl::check_smo_version

2017-02-27 20:00:18 avsql Info <19487>: Start checking for SMO DLL version 12...

2017-02-27 20:00:18 avsql Info <19484>: ===> sqlconnectimpl::is_SqlServ_2014

2017-02-27 20:00:18 avsql Info <19484>: ===> sqlconnectimpl::get_SqlServers_ver

2017-02-27 20:00:18 avsql Info <19468>: Connected to ROOT\CIMV2 WMI namespace.

2017-02-27 20:00:41 avsql Info <19475>: Detected version: 13.0.1601.5

2017-02-27 20:00:41 avsql Info <19476>: Add (13) to major version list.

2017-02-27 20:00:41 avsql Info <19475>: Detected version: 13.0.1601.5

2017-02-27 20:00:41 avsql Info <19471>: Reach the end of wmi qurery enumerator object.

2017-02-27 20:00:41 avsql Info <0000>: <=== sqlconnectimpl::get_SqlServers_ver

2017-02-27 20:00:41 avsql Info <0000>: <=== sqlconnectimpl::is_SqlServ_2014

2017-02-27 20:00:41 avsql Info <19494>: Start checking for SMO DLL version 10...

2017-02-27 20:00:41 avsql Info <19484>: ===> sqlconnectimpl::is_SqlServ_2008

2017-02-27 20:00:41 avsql Info <19484>: ===> sqlconnectimpl::get_SqlServers_ver

2017-02-27 20:00:41 avsql Info <19468>: Connected to ROOT\CIMV2 WMI namespace.

2017-02-27 20:00:44 avsql Info <19475>: Detected version: 13.0.1601.5

2017-02-27 20:00:44 avsql Info <19476>: Add (13) to major version list.

2017-02-27 20:00:44 avsql Info <19475>: Detected version: 13.0.1601.5

2017-02-27 20:00:44 avsql Info <19471>: Reach the end of wmi qurery enumerator object.

2017-02-27 20:00:44 avsql Info <0000>: <=== sqlconnectimpl::get_SqlServers_ver

2017-02-27 20:00:44 avsql Info <0000>: <=== sqlconnectimpl::is_SqlServ_2008

2017-02-27 20:00:44 avsql Error <19498>: Unable to load any of SMO managed DLL files.

2017-02-27 20:00:44 avsql Error <15744>: Unable to load SMO managed DLL: (symbol SMO_New not found)

2017-02-27 20:00:44 avsql Error <15760>: No targets after expansion!

2017-02-27 20:00:44 avsql Error <15760>: No targets after expansion!

2017-02-27 20:00:44 avsql Info <7271>: Final summary generated subwork 0, cancelled/aborted 0, snapview 0, exitcode 536870919

2017-02-27 20:00:49 avsql Info <6451>: avsql returning with exitcode 536870919

Is VDP 6.1.3 compatible with SQL Server 2016?

Thank you.

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
SavkoorSuhas
Expert
Expert
Jump to solution

SQL 2016 is unsupported by VDP 6.1.x

You will either need to image level backup or look into third party solutions.

Suhas

If you found this or any other answer useful please consider the use of the Helpful or Correct buttons to award points.

Don't Backup. Go Forward!
Rubrik

View solution in original post

0 Kudos
1 Reply
SavkoorSuhas
Expert
Expert
Jump to solution

SQL 2016 is unsupported by VDP 6.1.x

You will either need to image level backup or look into third party solutions.

Suhas

If you found this or any other answer useful please consider the use of the Helpful or Correct buttons to award points.

Don't Backup. Go Forward!
Rubrik

0 Kudos