Data Backup and Recovery Discussions

Problems Migrating System DB's with SMSQL 7.2

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

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/

 


 

Re: Problems Migrating System DB's with SMSQL 7.2

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. 

Re: Problems Migrating System DB's with SMSQL 7.2

Forums