NetApp Community Update
This site will enter Read Only mode on July 23 as we prepare to move to a new platform. You will still be able to view content, but posting and replying will be temporarily disabled.
We're excited to launch our new Community experience on July 30 and more information will follow soon.
Stay connected during the transition - Join our Discord community today.

Data Protection

Problems Migrating System DB's with SMSQL 7.2

Wvanderspek
9,470 Views

Hello,

I have a customer who is installing a new sql server, they use iSCSI and part of the configuration wizard process, the system databases have to migrate from local disk to a LUN.
But this process failes with error code: Error Code: 0x80004005

here is a complete log:

[09:52:01.752] [DB]
[09:52:01.752] [DB] *** SnapManager for SQL Server Report

[09:52:01.752] [DB] Configuration Time Stamp: 08-31-2016_09.51.51
[09:52:01.752] [DB] Host Name: DB
[09:52:01.752] [DB] Verification Server: DB
[09:52:01.752] [DB] New SnapManager Share:
[09:52:01.752] [DB] Database: master
[09:52:01.752] [DB] [PRIMARY] New database file - 1 : [G:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\master.mdf]
[09:52:01.752] [DB] [PRIMARY] Original database file : [C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\master.mdf]
[09:52:01.752] [DB] New log file - 1 : [G:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\mastlog.ldf]
[09:52:01.752] [DB] Original log file : [C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\mastlog.ldf]
[09:52:01.752] [DB] System Database: Yes
[09:52:01.752] [DB]
[09:52:01.752] [DB] Database: model
[09:52:01.752] [DB] [PRIMARY] New database file - 1 : [G:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\model.mdf]
[09:52:01.752] [DB] [PRIMARY] Original database file : [C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\model.mdf]
[09:52:01.752] [DB] New log file - 1 : [G:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\modellog.ldf]
[09:52:01.752] [DB] Original log file : [C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\modellog.ldf]
[09:52:01.752] [DB] System Database: Yes
[09:52:01.752] [DB]
[09:52:01.752] [DB] Database: msdb
[09:52:01.752] [DB] [PRIMARY] New database file - 1 : [G:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf]
[09:52:01.752] [DB] [PRIMARY] Original database file : [C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf]
[09:52:01.752] [DB] New log file - 1 : [G:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf]
[09:52:01.752] [DB] Original log file : [C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf]
[09:52:01.752] [DB] System Database: Yes
[09:52:01.752] [DB]
[09:52:01.752] [DB] There is no change for SQL Server user database.
[09:52:01.752] [DB] Maximum databases of concurrent backup: 35

[09:52:01.752] [DB] New SnapInfo path for LUN [D]: F:\SMSQL_SnapInfo
[09:52:01.752] [DB] Old SnapInfo path: F:\SMSQL_SnapInfo
[09:52:01.752] [DB] Set SnapInfo Directory...
[09:52:01.752] [DB] Configuration of the multiple databases per disk SnapInfo directory completed.


[09:52:01.752] [DB] No change to default SnapInfo directory of [DB] :
[09:52:01.752] [DB] F:\SMSQL_SnapInfo
[09:52:01.752] [DB] Copying new loginfo sml file...
[09:52:01.752] [DB] Set LogInfo directory path to registry...
[09:52:01.752] [DB] New LogInfo Path for Server DB: [F:\SMSQL_SnapInfo]

[09:52:01.752] [DB] Configuration of the normal Snapinfo directory completed.


[09:52:01.767] [DB] Checking SQL Server [DB]...
[09:52:01.767] [DB] Connecting to SQL Server [DB]...
[09:52:01.767] [DB] Getting SQL Server Agent status...
[09:52:01.767] [DB] DBCC CHECKDB (N'master')
[09:52:02.142] [DB] DBCC CHECKDB completed successfully.

[09:52:02.142] [DB] DBCC CHECKDB (N'model')
[09:52:02.283] [DB] DBCC CHECKDB completed successfully.

[09:52:02.283] [DB] DBCC CHECKDB (N'msdb')
[09:52:02.783] [DB] DBCC CHECKDB completed successfully.

[09:52:02.783] [DB] Set SQL Server to start with T3608...
[09:52:02.783] [DB] Invalid SMO WMI service pointer
[09:52:02.783] [DB] Stopping SQL Server...
[09:52:06.813] [DB] Unable to get SQL Server service from WMI.
[09:52:06.813] [DB] Creating directory...
[09:52:06.813] [DB] Creating directory...

[09:52:06.813] [DB] Restarting SQL Server...[DB]
[09:52:15.860] [DB] Failed to start SQL Server.
[09:52:15.860] [DB] SnapManager failed to restart SQL Server during system database migration.

[09:52:15.860] [DB] Removing T3608 flag...
[09:52:15.860] [DB] Invalid SMO WMI service pointer
[09:52:15.860] [DB] External component has thrown an exception.
[09:52:15.860] [DB] Failed to migrate SQL Server system databases.

[09:52:15.860] [DB] Error occurred during system database migration.


[09:52:15.860] [DB] ***ADD MSISCSI SERVICE AS A DEPENDENCY OF [MSSQLSERVER]
[09:52:15.860] [DB]
[09:52:15.860] [DB] Adding service [MSiSCSI] as a dependency of [MSSQLSERVER]...
[09:52:15.860] [DB] Server [MSiSCSI] was on the dependency list of the specified service.

[09:52:15.860] [DB] SnapManager Repository Share is not specified.
[09:52:15.860] [DB]
[09:52:15.860] [DB] *** SNAPMANAGER CONFIGURATION JOB ENDED AT: [08-31-2016 09.52.15]

[09:52:15.860] [DB] Error Code: 0x80004005
Unspecified error

[09:52:15.860] [DB] Preparing for sending filer AutoSupport...

6 REPLIES 6

CSCOTTENO
8,875 Views

Was there a solution to this?  I am having the same problem.

RAhlbrandt
8,726 Views

I had this problem with SMSQL 7.2.2.  Support had me downgrade to 7.2.1 and that seems to work.

 

I was using SQL Server 2012 Standard SP3 with SnapDrive 7.1.3.6796

 

Hammer
8,154 Views

Not fixed in 7.2.2P2. I face the same problem and I have installed 7.2.2P2


@matte wrote:

Hi

 

the problem here is this

 

http://mysupport.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=1036377

 

fixed in 7.2.2P2

 

http://mysupport.netapp.com/NOW/download/software/snapmanager_sql2k/7.2.2P2/

 


 

JIMMY_ERLANDSSON
7,222 Views

Also having the same problem with 7.2.2P2. Had to downgrade to 7.2.1 just to do the config wizard and then upgrade to 7.2.2P2 again. 

Public