Data Backup and Recovery
Data Backup and Recovery
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...
Was there a solution to this? I am having the same problem.
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
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/
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/
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.
I can see this
https://mysupport.netapp.com/NOW/download/software/snapmanager_sql2k/7.2.3/
with the fix for this https://mysupport.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=1036377
release notes here: https://library.netapp.com/ecm/ecm_get_file/ECMLP2839907