Subscribe

Problems Migrating System DB's with SMSQL 7.2

[ Edited ]

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...

Re: Problems Migrating System DB's with SMSQL 7.2

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

Re: Problems Migrating System DB's with SMSQL 7.2

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

 

Re: Problems Migrating System DB's with SMSQL 7.2

Re: Problems Migrating System DB's with SMSQL 7.2

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/