Data Backup and Recovery Discussions

Problem with Verification

DKJMM2012

Trying to complete a backup and verification of SQL server. It appears backup  works but verifcation fails.

[08:56:39.596] *** SnapManager for SQL Server Report

[08:56:39.611] Backup Time Stamp: 01-24-2012_08.56.38

[08:56:39.627] Getting SQL Server Database Information, please wait...

[08:56:39.627] Getting virtual disks information...

[08:56:43.549] Querying SQL Server instances installed...

[08:56:43.549] Querying installed SQL Server instances on [EI-SQL-QA]...

[08:56:43.549] Allocating ODBC environment handle...

[08:56:43.549] Setting environment attribute...

[08:56:43.580] Setting SQLBrowseConnect option...

[08:56:43.580] SQLBrowseConnect...

[08:56:43.580] Parsing SQLBrowseConnect server string...

[08:56:43.596] Creating threads for enumerating databases of different SQL Server instances.

[08:56:43.596] Waiting for the threads to finish enumerating databases.

[08:56:43.596] Connecting to SQL Server instance - EI-SQL-QA...

[08:56:43.611] Getting SQL Server version information...

[08:56:43.627] Querying database information...

[08:56:43.705] All threads finished enumerating databases.

[08:56:43.721] Validating database configuration...

[08:56:43.721] Setting database disk configuration...

[08:56:43.721] Setting database locating on SQLRoot path...

[08:56:43.721] Querying database disk volume configuration...

[08:56:43.721] Getting SnapInfo directories configuration...

[08:56:43.721] Checking dataset availability, connecting to SnapDrive...

[08:56:43.721] Dataset feature is currently unavailable.

[08:56:43.721] Getting SnapManager dataset info from...

[08:56:43.721] Dataset info file has not yet created.

[08:56:43.736] Getting SnapMirror Destinations Volumes...

[08:56:46.486] Update selected destination volumes information for SQL Server EI-SQL-QA succeeded.

[08:56:46.486] Get all destination volumes state successfully.

[08:56:46.486] Preparing for sending filer AutoSupport...

[08:56:48.783] No filer autosupport message is sent on success.

[08:56:48.799] Full database backup

[08:56:48.799] Maximum databases of concurrent backup: 255

[08:56:48.799] Naming convention: Generic

[08:56:48.799] Run transaction log backup after full database backup: Yes

[08:56:48.799] Transaction logs will be truncated after backup: Yes

[08:56:48.799] Archive backup to SnapVault secondary: No

[08:56:48.799] Keep the oldest 7 full backups.

[08:56:48.799] Retain up-to-the-minute restore ability for older backups in other management groups: Yes

[08:56:48.799] Verify database after backup (run DBCC) on ECO_SQL_QA1: Yes

[08:56:48.799] Verify on selected SnapMirror destination volumes: No

[08:56:48.815] Leave database attached after DBCC: No

[08:56:48.815] Run DBCC CHECKDB with Live Database Before Backup: No

[08:56:48.815] Run DBCC CHECKDB with Live Database After Backup: No

[08:56:48.815] Backup Management Group: Standard

[08:56:48.815] Update SnapMirror after operation: No

[08:56:48.815] Run Command before the operation: No

[08:56:48.815] Run Command after the operation: No

[08:56:48.815] 

[08:56:48.815] Backup Database 1: EI-SQL-QA : acct_rpt

[08:56:48.815] Backup Database 2: EI-SQL-QA : APCO

[08:56:48.815] Backup Database 3: EI-SQL-QA : apco_conv

[08:56:48.815] Backup Database 4: EI-SQL-QA : asrating

[08:56:48.815] Backup Database 5: EI-SQL-QA : CopyOfrates2003

[08:56:48.830] Backup Database 6: EI-SQL-QA : DOL_PUSH

[08:56:48.830] Backup Database 7: EI-SQL-QA : master

[08:56:48.830] Backup Database 8: EI-SQL-QA : model

[08:56:48.830] Backup Database 9: EI-SQL-QA : msdb

[08:56:48.830] Backup Database 10: EI-SQL-QA : RateBooks

[08:56:48.830] Backup Database 11: EI-SQL-QA : rates2003

[08:56:48.830] Backup Database 12: EI-SQL-QA : RevRpt

[08:56:48.830] Backup Database 13: EI-SQL-QA : security

[08:56:48.830] Backup Database 14: EI-SQL-QA : unix_reports

[08:56:48.830] Backup Database 15: EI-SQL-QA : webreports

[08:56:48.830] Backup database list:

[08:56:48.830] 1 - EI-SQL-QA : master

[08:56:48.830] 2 - EI-SQL-QA : model

[08:56:48.830] 3 - EI-SQL-QA : msdb

[08:56:48.830] Getting SnapInfo directory info...

[08:56:48.846] 1 - Database [master] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:48.846] S:\SMSQL_SnapInfo\SQL__EI-SQL-QA\DB__master

[08:56:48.846] Failed to create SnapInfo Directory.

[08:56:48.846] Failed to Get SnapInfo Directory from Registry

[08:56:48.846] 

[08:56:48.846] Deletion of the oldest backup sets does not proceed, as there is an error during backup of this database.

[08:56:48.846] Backup Database Group #1:

[08:56:48.846] EI-SQL-QA : acct_rpt

[08:56:48.846] EI-SQL-QA : APCO

[08:56:48.846] EI-SQL-QA : apco_conv

[08:56:48.846] EI-SQL-QA : asrating

[08:56:48.846] EI-SQL-QA : CopyOfrates2003

[08:56:48.846] EI-SQL-QA : DOL_PUSH

[08:56:48.846] EI-SQL-QA : RateBooks

[08:56:48.846] EI-SQL-QA : rates2003

[08:56:48.846] EI-SQL-QA : RevRpt

[08:56:48.846] EI-SQL-QA : security

[08:56:48.846] EI-SQL-QA : unix_reports

[08:56:48.846] EI-SQL-QA : webreports

[08:56:48.846] 

[08:56:48.861] Backup job based on volume: #1

[08:56:48.861] Sub Job: #1 of Job#1

[08:56:48.861] 1 - EI-SQL-QA : acct_rpt

[08:56:48.861] 2 - EI-SQL-QA : APCO

[08:56:48.861] 3 - EI-SQL-QA : apco_conv

[08:56:48.861] 4 - EI-SQL-QA : asrating

[08:56:48.861] 5 - EI-SQL-QA : CopyOfrates2003

[08:56:48.861] 6 - EI-SQL-QA : DOL_PUSH

[08:56:48.861] 7 - EI-SQL-QA : RateBooks

[08:56:48.861] 8 - EI-SQL-QA : rates2003

[08:56:48.861] 9 - EI-SQL-QA : RevRpt

[08:56:48.861] 10 - EI-SQL-QA : security

[08:56:48.861] 11 - EI-SQL-QA : unix_reports

[08:56:48.861] 12 - EI-SQL-QA : webreports

[08:56:48.861] **** BACKUP JOB **** #1

[08:56:48.861] Backup Time Stamp: 01-24-2012_08.56.38

[08:56:48.877] **** Backup Group [#1] of Job#1

[08:56:48.877] Backup Database List:

[08:56:48.877] 1 - EI-SQL-QA : acct_rpt

[08:56:48.877] 2 - EI-SQL-QA : APCO

[08:56:48.877] 3 - EI-SQL-QA : apco_conv

[08:56:48.877] 4 - EI-SQL-QA : asrating

[08:56:48.877] 5 - EI-SQL-QA : CopyOfrates2003

[08:56:48.877] 6 - EI-SQL-QA : DOL_PUSH

[08:56:48.877] 7 - EI-SQL-QA : RateBooks

[08:56:48.877] 8 - EI-SQL-QA : rates2003

[08:56:48.877] 9 - EI-SQL-QA : RevRpt

[08:56:48.877] 10 - EI-SQL-QA : security

[08:56:48.877] 11 - EI-SQL-QA : unix_reports

[08:56:48.877] 12 - EI-SQL-QA : webreports

[08:56:48.877] Maximum worker threads setting for [EI-SQL-QA] = 0

[08:56:48.877] Current worker threads number for [EI-SQL-QA] = 25

[08:56:48.877] GETTING ALL DATABASES INFO SHARING THE SAME VOLUMES...

[08:56:48.893] Getting SnapInfo directory info...

[08:56:48.893] 1 - Database [acct_rpt] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:48.893] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:48.908] 2 - Database [APCO] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:48.908] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:48.908] 3 - Database [apco_conv] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:48.908] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:48.908] 4 - Database [asrating] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:48.908] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:48.908] 5 - Database [CopyOfrates2003] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:48.908] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:48.908] 6 - Database [DOL_PUSH] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:48.908] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:48.908] 7 - Database [RateBooks] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:48.908] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:48.908] 8 - Database [rates2003] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:48.908] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:48.908] 9 - Database [RevRpt] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:48.908] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:48.908] 10 - Database [security] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:48.924] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:48.924] 11 - Database [unix_reports] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:48.924] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:48.924] 12 - Database [webreports] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:48.924] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:48.924] CHECK SNAPMANAGER LICENSE ON LUN.

[08:56:48.924] Querying LUN license: S...

[08:56:53.033] Querying LUN license: E...

[08:56:55.252] Getting SnapInfo directory info...

[08:56:55.252] 1 - Database [acct_rpt] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:55.252] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:55.268] 2 - Database [APCO] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:55.268] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:55.268] 3 - Database [apco_conv] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:55.268] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:55.268] 4 - Database [asrating] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:55.268] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:55.268] 5 - Database [CopyOfrates2003] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:55.268] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:55.268] 6 - Database [DOL_PUSH] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:55.268] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:55.268] 7 - Database [RateBooks] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:55.283] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:55.283] 8 - Database [rates2003] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:55.283] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:55.283] 9 - Database [RevRpt] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:55.283] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:55.283] 10 - Database [security] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:55.283] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:55.299] 11 - Database [unix_reports] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:55.299] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:55.299] 12 - Database [webreports] of [EI-SQL-QA] SnapInfo directory located at:

[08:56:55.299] S:\SMSQL_SnapInfo\VDISK__E&F

[08:56:55.299] 

[08:56:55.299] RENAME MOST RECENT SNAPINFO BEFORE NEW BACKUP : EI-SQL-QA : acct_rpt - [#1]

[08:56:55.330] Rename old recent snapinfo folder from and to:

[08:56:55.330] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\EI-SQL-QA__recent

[08:56:55.330] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\01-24-2012_08.03.56

[08:56:55.330] SnapManager finds an alternative snapinfo directory for database [acct_rpt] of [EI-SQL-QA] at:

[08:56:55.330] S:\SMSQL_SnapInfo\SQL__EI-SQL-QA\DB__acct_rpt

[08:56:55.330] 

[08:56:55.346] RENAME MOST RECENT SNAPINFO BEFORE NEW BACKUP : EI-SQL-QA : APCO - [#2]

[08:56:55.346] The recent backup snapinfo directory has already been renamed, it is sharing with other datatabases.

[08:56:55.346] SnapManager finds an alternative snapinfo directory for database [APCO] of [EI-SQL-QA] at:

[08:56:55.346] S:\SMSQL_SnapInfo\SQL__EI-SQL-QA\DB__APCO

[08:56:55.346] 

[08:56:55.346] RENAME MOST RECENT SNAPINFO BEFORE NEW BACKUP : EI-SQL-QA : apco_conv - [#3]

[08:56:55.346] The recent backup snapinfo directory has already been renamed, it is sharing with other datatabases.

[08:56:55.346] SnapManager finds an alternative snapinfo directory for database [apco_conv] of [EI-SQL-QA] at:

[08:56:55.346] S:\SMSQL_SnapInfo\SQL__EI-SQL-QA\DB__apco_conv

[08:56:55.346] 

[08:56:55.346] RENAME MOST RECENT SNAPINFO BEFORE NEW BACKUP : EI-SQL-QA : asrating - [#4]

[08:56:55.346] The recent backup snapinfo directory has already been renamed, it is sharing with other datatabases.

[08:56:55.362] SnapManager finds an alternative snapinfo directory for database [asrating] of [EI-SQL-QA] at:

[08:56:55.362] S:\SMSQL_SnapInfo\SQL__EI-SQL-QA\DB__asrating

[08:56:55.362] 

[08:56:55.362] RENAME MOST RECENT SNAPINFO BEFORE NEW BACKUP : EI-SQL-QA : CopyOfrates2003 - [#5]

[08:56:55.362] The recent backup snapinfo directory has already been renamed, it is sharing with other datatabases.

[08:56:55.362] SnapManager finds an alternative snapinfo directory for database [CopyOfrates2003] of [EI-SQL-QA] at:

[08:56:55.362] S:\SMSQL_SnapInfo\SQL__EI-SQL-QA\DB__CopyOfrates2003

[08:56:55.362] 

[08:56:55.362] RENAME MOST RECENT SNAPINFO BEFORE NEW BACKUP : EI-SQL-QA : DOL_PUSH - [#6]

[08:56:55.362] The recent backup snapinfo directory has already been renamed, it is sharing with other datatabases.

[08:56:55.362] SnapManager finds an alternative snapinfo directory for database [DOL_PUSH] of [EI-SQL-QA] at:

[08:56:55.362] S:\SMSQL_SnapInfo\SQL__EI-SQL-QA\DB__DOL_PUSH

[08:56:55.362] 

[08:56:55.362] RENAME MOST RECENT SNAPINFO BEFORE NEW BACKUP : EI-SQL-QA : RateBooks - [#7]

[08:56:55.362] The recent backup snapinfo directory has already been renamed, it is sharing with other datatabases.

[08:56:55.377] SnapManager finds an alternative snapinfo directory for database [RateBooks] of [EI-SQL-QA] at:

[08:56:55.377] S:\SMSQL_SnapInfo\SQL__EI-SQL-QA\DB__RateBooks

[08:56:55.377] 

[08:56:55.377] RENAME MOST RECENT SNAPINFO BEFORE NEW BACKUP : EI-SQL-QA : rates2003 - [#8]

[08:56:55.377] The recent backup snapinfo directory has already been renamed, it is sharing with other datatabases.

[08:56:55.377] SnapManager finds an alternative snapinfo directory for database [rates2003] of [EI-SQL-QA] at:

[08:56:55.377] S:\SMSQL_SnapInfo\SQL__EI-SQL-QA\DB__rates2003

[08:56:55.377] 

[08:56:55.408] RENAME MOST RECENT SNAPINFO BEFORE NEW BACKUP : EI-SQL-QA : RevRpt - [#9]

[08:56:55.408] The recent backup snapinfo directory has already been renamed, it is sharing with other datatabases.

[08:56:55.408] SnapManager finds an alternative snapinfo directory for database [RevRpt] of [EI-SQL-QA] at:

[08:56:55.408] S:\SMSQL_SnapInfo\SQL__EI-SQL-QA\DB__RevRpt

[08:56:55.408] 

[08:56:55.408] RENAME MOST RECENT SNAPINFO BEFORE NEW BACKUP : EI-SQL-QA : security - [#10]

[08:56:55.408] The recent backup snapinfo directory has already been renamed, it is sharing with other datatabases.

[08:56:55.408] SnapManager finds an alternative snapinfo directory for database [security] of [EI-SQL-QA] at:

[08:56:55.408] S:\SMSQL_SnapInfo\SQL__EI-SQL-QA\DB__security

[08:56:55.408] 

[08:56:55.408] RENAME MOST RECENT SNAPINFO BEFORE NEW BACKUP : EI-SQL-QA : unix_reports - [#11]

[08:56:55.408] The recent backup snapinfo directory has already been renamed, it is sharing with other datatabases.

[08:56:55.408] SnapManager finds an alternative snapinfo directory for database [unix_reports] of [EI-SQL-QA] at:

[08:56:55.408] S:\SMSQL_SnapInfo\SQL__EI-SQL-QA\DB__unix_reports

[08:56:55.408] 

[08:56:55.408] RENAME MOST RECENT SNAPINFO BEFORE NEW BACKUP : EI-SQL-QA : webreports - [#12]

[08:56:55.408] The recent backup snapinfo directory has already been renamed, it is sharing with other datatabases.

[08:56:55.408] SnapManager finds an alternative snapinfo directory for database [webreports] of [EI-SQL-QA] at:

[08:56:55.408] S:\SMSQL_SnapInfo\SQL__EI-SQL-QA\DB__webreports

[08:56:55.408] 

[08:56:55.408] RENAME OLD MOST RECENT SNAPSHOT

[08:57:00.299] Rename Snapshot for LUN [E] from [sqlsnap__ei-sql-qa__recent]

[08:57:00.299] To [sqlsnap__ei-sql-qa_01-24-2012_08.03.56]

[08:57:04.971] Rename snapshot successfully completed.

[08:57:04.971] 

[08:57:04.971] CREATE NEW RECENT SNAPINFO DIRECTORY : acct_rpt - [#1]

[08:57:04.971] SnapInfo file Name:

[08:57:04.971] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\EI-SQL-QA__recent\SnapInfo__01-24-2012_08.56.38.sml

[08:57:04.971] 

[08:57:04.987] CREATE NEW RECENT SNAPINFO DIRECTORY : APCO - [#2]

[08:57:04.987] SnapInfo file Name:

[08:57:04.987] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\EI-SQL-QA__recent\SnapInfo__01-24-2012_08.56.38.sml

[08:57:04.987] 

[08:57:04.987] CREATE NEW RECENT SNAPINFO DIRECTORY : apco_conv - [#3]

[08:57:04.987] SnapInfo file Name:

[08:57:04.987] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\EI-SQL-QA__recent\SnapInfo__01-24-2012_08.56.38.sml

[08:57:04.987] 

[08:57:04.987] CREATE NEW RECENT SNAPINFO DIRECTORY : asrating - [#4]

[08:57:04.987] SnapInfo file Name:

[08:57:04.987] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\EI-SQL-QA__recent\SnapInfo__01-24-2012_08.56.38.sml

[08:57:04.987] 

[08:57:04.987] CREATE NEW RECENT SNAPINFO DIRECTORY : CopyOfrates2003 - [#5]

[08:57:05.002] SnapInfo file Name:

[08:57:05.002] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\EI-SQL-QA__recent\SnapInfo__01-24-2012_08.56.38.sml

[08:57:05.002] 

[08:57:05.002] CREATE NEW RECENT SNAPINFO DIRECTORY : DOL_PUSH - [#6]

[08:57:05.002] SnapInfo file Name:

[08:57:05.002] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\EI-SQL-QA__recent\SnapInfo__01-24-2012_08.56.38.sml

[08:57:05.002] 

[08:57:05.002] CREATE NEW RECENT SNAPINFO DIRECTORY : RateBooks - [#7]

[08:57:05.002] SnapInfo file Name:

[08:57:05.002] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\EI-SQL-QA__recent\SnapInfo__01-24-2012_08.56.38.sml

[08:57:05.002] 

[08:57:05.002] CREATE NEW RECENT SNAPINFO DIRECTORY : rates2003 - [#8]

[08:57:05.002] SnapInfo file Name:

[08:57:05.002] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\EI-SQL-QA__recent\SnapInfo__01-24-2012_08.56.38.sml

[08:57:05.018] 

[08:57:05.018] CREATE NEW RECENT SNAPINFO DIRECTORY : RevRpt - [#9]

[08:57:05.018] SnapInfo file Name:

[08:57:05.018] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\EI-SQL-QA__recent\SnapInfo__01-24-2012_08.56.38.sml

[08:57:05.018] 

[08:57:05.018] CREATE NEW RECENT SNAPINFO DIRECTORY : security - [#10]

[08:57:05.018] SnapInfo file Name:

[08:57:05.018] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\EI-SQL-QA__recent\SnapInfo__01-24-2012_08.56.38.sml

[08:57:05.018] 

[08:57:05.018] CREATE NEW RECENT SNAPINFO DIRECTORY : unix_reports - [#11]

[08:57:05.018] SnapInfo file Name:

[08:57:05.018] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\EI-SQL-QA__recent\SnapInfo__01-24-2012_08.56.38.sml

[08:57:05.018] 

[08:57:05.034] CREATE NEW RECENT SNAPINFO DIRECTORY : webreports - [#12]

[08:57:05.034] SnapInfo file Name:

[08:57:05.034] S:\SMSQL_SnapInfo\VDISK__E&F\FG__\EI-SQL-QA__recent\SnapInfo__01-24-2012_08.56.38.sml

[08:57:05.034] 

[08:57:05.034] Updating SnapInfo file for databases sharing same drive letter - [#1]

[08:57:05.034] Updating SnapInfo file for database - #1 : acct_rpt

[08:57:05.034] Updating SnapInfo file for database - #2 : APCO

[08:57:05.034] Updating SnapInfo file for database - #3 : apco_conv

[08:57:05.034] Updating SnapInfo file for database - #4 : asrating

[08:57:05.049] Updating SnapInfo file for database - #5 : CopyOfrates2003

[08:57:05.049] Updating SnapInfo file for database - #6 : DOL_PUSH

[08:57:05.049] Updating SnapInfo file for database - #7 : RateBooks

[08:57:05.049] Updating SnapInfo file for database - #8 : rates2003

[08:57:05.049] Updating SnapInfo file for database - #9 : RevRpt

[08:57:05.049] Updating SnapInfo file for database - #10 : security

[08:57:05.065] Updating SnapInfo file for database - #11 : unix_reports

[08:57:05.065] Updating SnapInfo file for database - #12 : webreports

[08:57:05.065] Performing VDI backup

[08:57:05.065] *** STARTING SQL SERVER ONLINE BACKUP PROCESS

[08:57:05.065] 

[08:57:05.065] Starting VDI backup thread for database #1: [EI-SQL-QA : acct_rpt]...

[08:57:05.065] Starting VDI backup thread for database #2: [EI-SQL-QA : APCO]...

[08:57:05.065] Starting VDI backup thread for database #3: [EI-SQL-QA : apco_conv]...

[08:57:05.065] Starting VDI backup thread for database #4: [EI-SQL-QA : asrating]...

[08:57:05.065] Starting VDI backup thread for database #5: [EI-SQL-QA : CopyOfrates2003]...

[08:57:05.081] Starting VDI backup thread for database #6: [EI-SQL-QA : DOL_PUSH]...

[08:57:05.081] Starting VDI backup thread for database #7: [EI-SQL-QA : RateBooks]...

[08:57:05.081] Starting VDI backup thread for database #8: [EI-SQL-QA : rates2003]...

[08:57:05.081] Starting VDI backup thread for database #9: [EI-SQL-QA : RevRpt]...

[08:57:05.081] Starting VDI backup thread for database #10: [EI-SQL-QA : security]...

[08:57:05.081] Starting VDI backup thread for database #11: [EI-SQL-QA : unix_reports]...

[08:57:05.081] Starting VDI backup thread for database #12: [EI-SQL-QA : webreports]...

[08:57:05.081] Sending SQL command to instance EI-SQL-QA for database acct_rpt : device NTAPDEV__EI-SQL-QA_acct_rpt...

[08:57:05.081] Receiving by server [EI-SQL-QA]...

[08:57:05.096] BACKUP DATABASE [acct_rpt] TO VIRTUAL_DEVICE='NTAPDEV__EI-SQL-QA_acct_rpt' WITH SNAPSHOT

[08:57:05.096] Waiting for SQLServer to respond...

[08:57:05.096] Sending SQL command to instance EI-SQL-QA for database APCO : device NTAPDEV__EI-SQL-QA_APCO...

[08:57:05.096] Receiving by server [EI-SQL-QA]...

[08:57:05.096] BACKUP DATABASE [APCO] TO VIRTUAL_DEVICE='NTAPDEV__EI-SQL-QA_APCO' WITH SNAPSHOT

[08:57:05.096] Waiting for SQLServer to respond...

[08:57:05.096] Sending SQL command to instance EI-SQL-QA for database apco_conv : device NTAPDEV__EI-SQL-QA_apco_conv...

[08:57:05.096] Receiving by server [EI-SQL-QA]...

[08:57:05.096] BACKUP DATABASE [apco_conv] TO VIRTUAL_DEVICE='NTAPDEV__EI-SQL-QA_apco_conv' WITH SNAPSHOT

[08:57:05.096] Waiting for SQLServer to respond...

[08:57:05.112] Sending SQL command to instance EI-SQL-QA for database asrating : device NTAPDEV__EI-SQL-QA_asrating...

[08:57:05.112] Receiving by server [EI-SQL-QA]...

[08:57:05.112] BACKUP DATABASE [asrating] TO VIRTUAL_DEVICE='NTAPDEV__EI-SQL-QA_asrating' WITH SNAPSHOT

[08:57:05.112] Waiting for SQLServer to respond...

[08:57:05.112] Sending SQL command to instance EI-SQL-QA for database CopyOfrates2003 : device NTAPDEV__EI-SQL-QA_CopyOfrates2003...

[08:57:05.112] Receiving by server [EI-SQL-QA]...

[08:57:05.112] BACKUP DATABASE [CopyOfrates2003] TO VIRTUAL_DEVICE='NTAPDEV__EI-SQL-QA_CopyOfrates2003' WITH SNAPSHOT

[08:57:05.112] Waiting for SQLServer to respond...

[08:57:05.112] Sending SQL command to instance EI-SQL-QA for database DOL_PUSH : device NTAPDEV__EI-SQL-QA_DOL_PUSH...

[08:57:05.127] Receiving by server [EI-SQL-QA]...

[08:57:05.127] BACKUP DATABASE [DOL_PUSH] TO VIRTUAL_DEVICE='NTAPDEV__EI-SQL-QA_DOL_PUSH' WITH SNAPSHOT

[08:57:05.127] Waiting for SQLServer to respond...

[08:57:05.127] Sending SQL command to instance EI-SQL-QA for database RateBooks : device NTAPDEV__EI-SQL-QA_RateBooks...

[08:57:05.127] Receiving by server [EI-SQL-QA]...

[08:57:05.127] BACKUP DATABASE [RateBooks] TO VIRTUAL_DEVICE='NTAPDEV__EI-SQL-QA_RateBooks' WITH SNAPSHOT

[08:57:05.127] Waiting for SQLServer to respond...

[08:57:05.127] Sending SQL command to instance EI-SQL-QA for database rates2003 : device NTAPDEV__EI-SQL-QA_rates2003...

[08:57:05.127] Receiving by server [EI-SQL-QA]...

[08:57:05.143] BACKUP DATABASE [rates2003] TO VIRTUAL_DEVICE='NTAPDEV__EI-SQL-QA_rates2003' WITH SNAPSHOT

[08:57:05.143] Waiting for SQLServer to respond...

[08:57:05.143] Sending SQL command to instance EI-SQL-QA for database RevRpt : device NTAPDEV__EI-SQL-QA_RevRpt...

[08:57:05.143] Receiving by server [EI-SQL-QA]...

[08:57:05.143] BACKUP DATABASE [RevRpt] TO VIRTUAL_DEVICE='NTAPDEV__EI-SQL-QA_RevRpt' WITH SNAPSHOT

[08:57:05.143] Waiting for SQLServer to respond...

[08:57:05.143] Sending SQL command to instance EI-SQL-QA for database security : device NTAPDEV__EI-SQL-QA_security...

[08:57:05.143] Receiving by server [EI-SQL-QA]...

[08:57:05.143] BACKUP DATABASE [security] TO VIRTUAL_DEVICE='NTAPDEV__EI-SQL-QA_security' WITH SNAPSHOT

[08:57:05.143] Waiting for SQLServer to respond...

[08:57:05.159] Sending SQL command to instance EI-SQL-QA for database unix_reports : device NTAPDEV__EI-SQL-QA_unix_reports...

[08:57:05.159] Receiving by server [EI-SQL-QA]...

[08:57:05.159] BACKUP DATABASE [unix_reports] TO VIRTUAL_DEVICE='NTAPDEV__EI-SQL-QA_unix_reports' WITH SNAPSHOT

[08:57:05.159] Waiting for SQLServer to respond...

[08:57:05.159] Sending SQL command to instance EI-SQL-QA for database webreports : device NTAPDEV__EI-SQL-QA_webreports...

[08:57:05.159] Receiving by server [EI-SQL-QA]...

[08:57:05.159] BACKUP DATABASE [webreports] TO VIRTUAL_DEVICE='NTAPDEV__EI-SQL-QA_webreports' WITH SNAPSHOT

[08:57:05.159] Waiting for SQLServer to respond...

[08:57:05.174] Performing data transfer of [EI-SQL-QA : acct_rpt]...

[08:57:05.252] Performing data transfer of [EI-SQL-QA : APCO]...

[08:57:05.252] Performing data transfer of [EI-SQL-QA : apco_conv]...

[08:57:05.252] Performing data transfer of [EI-SQL-QA : asrating]...

[08:57:05.252] Performing data transfer of [EI-SQL-QA : CopyOfrates2003]...

[08:57:05.268] Performing data transfer of [EI-SQL-QA : DOL_PUSH]...

[08:57:05.268] Performing data transfer of [EI-SQL-QA : RateBooks]...

[08:57:05.268] Performing data transfer of [EI-SQL-QA : rates2003]...

[08:57:05.268] Performing data transfer of [EI-SQL-QA : RevRpt]...

[08:57:05.299] Performing data transfer of [EI-SQL-QA : security]...

[08:57:05.315] Performing data transfer of [EI-SQL-QA : unix_reports]...

[08:57:05.315] Performing data transfer of [EI-SQL-QA : webreports]...

[08:57:05.596] SQL Server is prepared to freeze the database now [EI-SQL-QA : acct_rpt]...

[08:57:05.596] SQL Server is prepared to freeze the database now [EI-SQL-QA : RevRpt]...

[08:57:05.596] SQL Server is prepared to freeze the database now [EI-SQL-QA : RateBooks]...

[08:57:05.612] SQL Server is prepared to freeze the database now [EI-SQL-QA : asrating]...

[08:57:05.737] SQL Server is prepared to freeze the database now [EI-SQL-QA : DOL_PUSH]...

[08:57:05.737] SQL Server is prepared to freeze the database now [EI-SQL-QA : rates2003]...

[08:57:05.737] SQL Server is prepared to freeze the database now [EI-SQL-QA : CopyOfrates2003]...

[08:57:05.752] SQL Server is prepared to freeze the database now [EI-SQL-QA : apco_conv]...

[08:57:05.752] SQL Server is prepared to freeze the database now [EI-SQL-QA : security]...

[08:57:05.752] SQL Server is prepared to freeze the database now [EI-SQL-QA : webreports]...

[08:57:05.752] SQL Server is prepared to freeze the database now [EI-SQL-QA : unix_reports]...

[08:57:05.799] SQL Server is prepared to freeze the database now [EI-SQL-QA : APCO]...

[08:57:05.815] Ready to prepare to create snapshot...

[08:57:05.831] 

[08:57:05.831] SNAPSHOT DATABASE

[08:57:05.831] Preparing Snapshot to Drive:

[08:57:05.831] LUN [E], LUN [F]

[08:57:05.831] Snapshot Name: sqlsnap__ei-sql-qa__recent

[08:57:05.831] Begin to create snapshot...

[08:57:09.627] SnapDrive is ready to create snapshot.

[08:57:09.643] Create Snapshot Now [EI-SQL-QA : APCO]...

[08:57:09.659] Create Snapshot Now [EI-SQL-QA : CopyOfrates2003]...

[08:57:09.659] Create Snapshot Now [EI-SQL-QA : rates2003]...

[08:57:09.659] Create Snapshot Now [EI-SQL-QA : unix_reports]...

[08:57:09.659] Create Snapshot Now [EI-SQL-QA : acct_rpt]...

[08:57:09.659] Create Snapshot Now [EI-SQL-QA : RevRpt]...

[08:57:09.659] Create Snapshot Now [EI-SQL-QA : RateBooks]...

[08:57:09.674] Create Snapshot Now [EI-SQL-QA : asrating]...

[08:57:09.674] Create Snapshot Now [EI-SQL-QA : DOL_PUSH]...

[08:57:09.674] Create Snapshot Now [EI-SQL-QA : apco_conv]...

[08:57:09.674] Create Snapshot Now [EI-SQL-QA : security]...

[08:57:09.674] Create Snapshot Now [EI-SQL-QA : webreports]...

[08:57:09.674] All VDI backup threads completed snapshot preparation and databases IO are frozen for snapshot.

[08:57:09.674] SnapManager are ready to create snapshot...

[08:57:17.206] Snapshot virtual disk [E, F] for database [acct_rpt] successfully completed.

[08:57:17.206] Snapshot virtual disk [E, F] for database [APCO] successfully completed.

[08:57:17.221] Snapshot virtual disk [E, F] for database [apco_conv] successfully completed.

[08:57:17.221] Snapshot virtual disk [E, F] for database [asrating] successfully completed.

[08:57:17.221] Snapshot virtual disk [E, F] for database [CopyOfrates2003] successfully completed.

[08:57:17.221] Snapshot virtual disk [E, F] for database [DOL_PUSH] successfully completed.

[08:57:17.221] Snapshot virtual disk [E, F] for database [RateBooks] successfully completed.

[08:57:17.221] Snapshot virtual disk [E, F] for database [rates2003] successfully completed.

[08:57:17.221] Snapshot virtual disk [E, F] for database [RevRpt] successfully completed.

[08:57:17.237] Snapshot virtual disk [E, F] for database [security] successfully completed.

[08:57:17.237] Snapshot virtual disk [E, F] for database [unix_reports] successfully completed.

[08:57:17.237] Snapshot virtual disk [E, F] for database [webreports] successfully completed.

[08:57:17.237] [EI-SQL-QA : webreports] SQL Server is aware that the snapshot is successful.

[08:57:17.237] [EI-SQL-QA : security] SQL Server is aware that the snapshot is successful.

[08:57:17.237] [EI-SQL-QA : RateBooks] SQL Server is aware that the snapshot is successful.

[08:57:17.237] [EI-SQL-QA : RevRpt] SQL Server is aware that the snapshot is successful.

[08:57:17.253] [EI-SQL-QA : rates2003] SQL Server is aware that the snapshot is successful.

[08:57:17.253] [EI-SQL-QA : DOL_PUSH] SQL Server is aware that the snapshot is successful.

[08:57:17.253] [EI-SQL-QA : apco_conv] SQL Server is aware that the snapshot is successful.

[08:57:17.253] [EI-SQL-QA : CopyOfrates2003] SQL Server is aware that the snapshot is successful.

[08:57:17.253] [EI-SQL-QA : asrating] SQL Server is aware that the snapshot is successful.

[08:57:17.253] [EI-SQL-QA : APCO] SQL Server is aware that the snapshot is successful.

[08:57:17.253] [EI-SQL-QA : acct_rpt] SQL Server is aware that the snapshot is successful.

[08:57:17.253] [EI-SQL-QA : unix_reports] SQL Server is aware that the snapshot is successful.

[08:57:17.456] Msg 4035, SevLevel 0, State 1, SQLState 01000

[08:57:17.456] Msg 4035, SevLevel 0, State 1, SQLState 01000

[08:57:17.456] Msg 4035, SevLevel 0, State 1, SQLState 01000

[08:57:17.456] Msg 4035, SevLevel 0, State 1, SQLState 01000

[08:57:17.471] [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 0 pages for database 'RateBooks', file 'RateBooks' on file 1.

[08:57:17.471] [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 0 pages for database 'security', file 'security_Data' on file 1.

[08:57:17.471] [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 0 pages for database 'RevRpt', file 'RevRpt_Data' on file 1.

[08:57:17.471] [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 0 pages for database 'DOL_PUSH', file 'DOL_PUSH' on file 1.

[08:57:17.471] Msg 3014, SevLevel 0, State 1, SQLState 01000

[08:57:17.471] Msg 3014, SevLevel 0, State 1, SQLState 01000

[08:57:17.471] Msg 3014, SevLevel 0, State 1, SQLState 01000

[08:57:17.471] Msg 3014, SevLevel 0, State 1, SQLState 01000

[08:57:17.471] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE successfully processed 0 pages in 11.650 seconds (0.000 MB/sec).

[08:57:17.487] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE successfully processed 0 pages in 11.586 seconds (0.000 MB/sec).

[08:57:17.487] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE successfully processed 0 pages in 11.650 seconds (0.000 MB/sec).

[08:57:17.487] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE successfully processed 0 pages in 11.633 seconds (0.000 MB/sec).

[08:57:17.487] Msg 4035, SevLevel 0, State 1, SQLState 01000

[08:57:17.487] [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 0 pages for database 'acct_rpt', file 'ACCT_RPT' on file 1.

[08:57:17.503] Msg 3014, SevLevel 0, State 1, SQLState 01000

[08:57:17.503] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE successfully processed 0 pages in 11.653 seconds (0.000 MB/sec).

[08:57:17.503] The SQL command executed.

[08:57:17.503] The SQL command executed.

[08:57:17.503] The SQL command executed.

[08:57:17.503] The SQL command executed.

[08:57:17.518] The SQL command executed.

[08:57:17.534] Msg 4035, SevLevel 0, State 1, SQLState 01000

[08:57:17.534] [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 0 pages for database 'apco_conv', file 'apco_conv' on file 1.

[08:57:17.550] Msg 3014, SevLevel 0, State 1, SQLState 01000

[08:57:17.550] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE successfully processed 0 pages in 11.587 seconds (0.000 MB/sec).

[08:57:17.550] Msg 4035, SevLevel 0, State 1, SQLState 01000

[08:57:17.550] [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 0 pages for database 'asrating', file 'asrating_Data' on file 1.

[08:57:17.565] Msg 4035, SevLevel 0, State 1, SQLState 01000

[08:57:17.565] Msg 3014, SevLevel 0, State 1, SQLState 01000

[08:57:17.565] [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 0 pages for database 'APCO', file 'apco_Data' on file 1.

[08:57:17.565] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE successfully processed 0 pages in 11.633 seconds (0.000 MB/sec).

[08:57:17.565] Msg 3014, SevLevel 0, State 1, SQLState 01000

[08:57:17.565] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE successfully processed 0 pages in 11.456 seconds (0.000 MB/sec).

[08:57:17.565] The SQL command executed.

[08:57:17.581] Msg 4035, SevLevel 0, State 1, SQLState 01000

[08:57:17.581] [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 0 pages for database 'rates2003', file 'rates2003_Data' on file 1.

[08:57:17.581] Msg 3014, SevLevel 0, State 1, SQLState 01000

[08:57:17.581] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE successfully processed 0 pages in 11.633 seconds (0.000 MB/sec).

[08:57:17.581] The SQL command executed.

[08:57:17.596] The SQL command executed.

[08:57:17.596] The SQL command executed.

[08:57:17.612] Msg 4035, SevLevel 0, State 1, SQLState 01000

[08:57:17.612] [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 0 pages for database 'unix_reports', file 'unix_reports_Data' on file 1.

[08:57:17.612] Msg 3014, SevLevel 0, State 1, SQLState 01000

[08:57:17.628] Msg 4035, SevLevel 0, State 1, SQLState 01000

[08:57:17.628] Msg 4035, SevLevel 0, State 1, SQLState 01000

[08:57:17.628] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE successfully processed 0 pages in 11.581 seconds (0.000 MB/sec).

[08:57:17.628] [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 0 pages for database 'CopyOfrates2003', file 'rates2003_Data' on file 1.

[08:57:17.628] [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 0 pages for database 'webreports', file 'webreports_Data' on file 1.

[08:57:17.628] Msg 3014, SevLevel 0, State 1, SQLState 01000

[08:57:17.628] Msg 3014, SevLevel 0, State 1, SQLState 01000

[08:57:17.643] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE successfully processed 0 pages in 11.617 seconds (0.000 MB/sec).

[08:57:17.643] [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE successfully processed 0 pages in 11.585 seconds (0.000 MB/sec).

[08:57:17.643] The SQL command executed.

[08:57:17.643] The SQL command executed.

[08:57:17.643] The SQL command executed.

[08:57:17.643] *** TRANSACTION LOG BACKUP AFTER FULL DATABASE BACKUP

[08:57:17.659] Transaction log backup for database [APCO] skipped (Simple Recovery Model).

[08:57:17.659] Transaction log backup for database [apco_conv] skipped (Simple Recovery Model).

[08:57:17.659] Transaction log backup for database [asrating] skipped (Simple Recovery Model).

[08:57:17.659] Transaction log backup for database [DOL_PUSH] skipped (Simple Recovery Model).

[08:57:17.659] TRANSACTION LOG BACKUP AFTER FULL BACKUP [#1]

[08:57:17.659] Transaction log backup location for database [acct_rpt]:

[08:57:17.659] S:\SMSQL_SnapInfo\VDISK__E&F\LogBackup\LOGINST__EI-SQL-QA\LOGDB__acct_rpt\01-24-2012_08.56.38__acct_rpt.TRB

[08:57:17.659] Connecting to SQL server EI-SQL-QA...

[08:57:17.675] Checking recovery model...

[08:57:17.706] Database [acct_rpt] recovery model is Full.

[08:57:17.706] Transaction log backup for database [acct_rpt] will truncate logs...

[08:57:17.706] Starting to backup transaction log for database [acct_rpt]...

[08:57:17.815] Database [EI-SQL-QA:acct_rpt] Percent: 100 percent processed.100

[08:57:17.831] Database [EI-SQL-QA:acct_rpt] BACKUP LOG successfully processed 2 pages in 0.057 seconds (0.206 MB/sec).

[08:57:17.831] Transaction log backup of database [acct_rpt] completed.

[08:57:17.831] Verifying transaction log backup...

[08:57:17.925] Transaction log backup verification of database [acct_rpt] successfully completed.

[08:57:17.940] TRANSACTION LOG BACKUP AFTER FULL BACKUP [#2]

[08:57:17.940] Transaction log backup location for database [CopyOfrates2003]:

[08:57:17.940] S:\SMSQL_SnapInfo\VDISK__E&F\LogBackup\LOGINST__EI-SQL-QA\LOGDB__CopyOfrates2003\01-24-2012_08.56.38__CopyOfrates2003.TRB

[08:57:17.940] Checking recovery model...

[08:57:17.940] Database [CopyOfrates2003] recovery model is Full.

[08:57:17.940] Transaction log backup for database [CopyOfrates2003] will truncate logs...

[08:57:17.940] Starting to backup transaction log for database [CopyOfrates2003]...

[08:57:18.112] Database [EI-SQL-QA:CopyOfrates2003] Percent: 100 percent processed.100

[08:57:18.143] Database [EI-SQL-QA:CopyOfrates2003] BACKUP LOG successfully processed 2 pages in 0.154 seconds (0.079 MB/sec).

[08:57:18.143] Transaction log backup of database [CopyOfrates2003] completed.

[08:57:18.143] Verifying transaction log backup...

[08:57:18.253] Transaction log backup verification of database [CopyOfrates2003] successfully completed.

[08:57:18.253] TRANSACTION LOG BACKUP AFTER FULL BACKUP [#3]

[08:57:18.253] Transaction log backup location for database [RateBooks]:

[08:57:18.253] S:\SMSQL_SnapInfo\VDISK__E&F\LogBackup\LOGINST__EI-SQL-QA\LOGDB__RateBooks\01-24-2012_08.56.38__RateBooks.TRB

[08:57:18.253] Checking recovery model...

[08:57:18.268] Database [RateBooks] recovery model is Full.

[08:57:18.268] Transaction log backup for database [RateBooks] will truncate logs...

[08:57:18.268] Starting to backup transaction log for database [RateBooks]...

[08:57:18.378] Database [EI-SQL-QA:RateBooks] Percent: 100 percent processed.100

[08:57:18.378] Database [EI-SQL-QA:RateBooks] BACKUP LOG successfully processed 2 pages in 0.024 seconds (0.490 MB/sec).

[08:57:18.378] Transaction log backup of database [RateBooks] completed.

[08:57:18.378] Verifying transaction log backup...

[08:57:18.487] Transaction log backup verification of database [RateBooks] successfully completed.

[08:57:18.487] TRANSACTION LOG BACKUP AFTER FULL BACKUP [#4]

[08:57:18.487] Transaction log backup location for database [rates2003]:

[08:57:18.487] S:\SMSQL_SnapInfo\VDISK__E&F\LogBackup\LOGINST__EI-SQL-QA\LOGDB__rates2003\01-24-2012_08.56.38__rates2003.TRB

[08:57:18.487] Checking recovery model...

[08:57:18.503] Database [rates2003] recovery model is Full.

[08:57:18.503] Transaction log backup for database [rates2003] will truncate logs...

[08:57:18.503] Starting to backup transaction log for database [rates2003]...

[08:57:18.628] Database [EI-SQL-QA:rates2003] Percent: 100 percent processed.100

[08:57:18.675] Database [EI-SQL-QA:rates2003] BACKUP LOG successfully processed 2 pages in 0.131 seconds (0.093 MB/sec).

[08:57:18.675] Transaction log backup of database [rates2003] completed.

[08:57:18.675] Verifying transaction log backup...

[08:57:18.784] Transaction log backup verification of database [rates2003] successfully completed.

[08:57:18.784] TRANSACTION LOG BACKUP AFTER FULL BACKUP [#5]

[08:57:18.784] Transaction log backup location for database [RevRpt]:

[08:57:18.784] S:\SMSQL_SnapInfo\VDISK__E&F\LogBackup\LOGINST__EI-SQL-QA\LOGDB__RevRpt\01-24-2012_08.56.38__RevRpt.TRB

[08:57:18.784] Checking recovery model...

[08:57:18.800] Database [RevRpt] recovery model is Full.

[08:57:18.800] Transaction log backup for database [RevRpt] will truncate logs...

[08:57:18.800] Starting to backup transaction log for database [RevRpt]...

[08:57:18.909] Database [EI-SQL-QA:RevRpt] Percent: 100 percent processed.100

[08:57:18.909] Database [EI-SQL-QA:RevRpt] BACKUP LOG successfully processed 2 pages in 0.016 seconds (0.736 MB/sec).

[08:57:18.909] Transaction log backup of database [RevRpt] completed.

[08:57:18.909] Verifying transaction log backup...

[08:57:19.018] Transaction log backup verification of database [RevRpt] successfully completed.

[08:57:19.018] TRANSACTION LOG BACKUP AFTER FULL BACKUP [#6]

[08:57:19.018] Transaction log backup location for database [security]:

[08:57:19.018] S:\SMSQL_SnapInfo\VDISK__E&F\LogBackup\LOGINST__EI-SQL-QA\LOGDB__security\01-24-2012_08.56.38__security.TRB

[08:57:19.018] Checking recovery model...

[08:57:19.018] Database [security] recovery model is Full.

[08:57:19.018] Transaction log backup for database [security] will truncate logs...

[08:57:19.034] Starting to backup transaction log for database [security]...

[08:57:19.128] Database [EI-SQL-QA:security] Percent: 100 percent processed.100

[08:57:19.128] Database [EI-SQL-QA:security] BACKUP LOG successfully processed 2 pages in 0.061 seconds (0.201 MB/sec).

[08:57:19.128] Transaction log backup of database [security] completed.

[08:57:19.128] Verifying transaction log backup...

[08:57:19.237] Transaction log backup verification of database [security] successfully completed.

[08:57:19.237] TRANSACTION LOG BACKUP AFTER FULL BACKUP [#7]

[08:57:19.237] Transaction log backup location for database [unix_reports]:

[08:57:19.253] S:\SMSQL_SnapInfo\VDISK__E&F\LogBackup\LOGINST__EI-SQL-QA\LOGDB__unix_reports\01-24-2012_08.56.38__unix_reports.TRB

[08:57:19.253] Checking recovery model...

[08:57:19.253] Database [unix_reports] recovery model is Full.

[08:57:19.253] Transaction log backup for database [unix_reports] will truncate logs...

[08:57:19.253] Starting to backup transaction log for database [unix_reports]...

[08:57:19.362] Database [EI-SQL-QA:unix_reports] Percent: 100 percent processed.100

[08:57:19.362] Database [EI-SQL-QA:unix_reports] BACKUP LOG successfully processed 2 pages in 0.013 seconds (0.905 MB/sec).

[08:57:19.362] Transaction log backup of database [unix_reports] completed.

[08:57:19.362] Verifying transaction log backup...

[08:57:19.471] Transaction log backup verification of database [unix_reports] successfully completed.

[08:57:19.471] TRANSACTION LOG BACKUP AFTER FULL BACKUP [#8]

[08:57:19.471] Transaction log backup location for database [webreports]:

[08:57:19.471] S:\SMSQL_SnapInfo\VDISK__E&F\LogBackup\LOGINST__EI-SQL-QA\LOGDB__webreports\01-24-2012_08.56.38__webreports.TRB

[08:57:19.487] Checking recovery model...

[08:57:19.487] Database [webreports] recovery model is Full.

[08:57:19.487] Transaction log backup for database [webreports] will truncate logs...

[08:57:19.487] Starting to backup transaction log for database [webreports]...

[08:57:19.784] Database [EI-SQL-QA:webreports] Percent: 100 percent processed.100

[08:57:19.815] Database [EI-SQL-QA:webreports] BACKUP LOG successfully processed 2 pages in 0.300 seconds (0.039 MB/sec).

[08:57:19.815] Transaction log backup of database [webreports] completed.

[08:57:19.831] Verifying transaction log backup...

[08:57:20.034] Transaction log backup verification of database [webreports] successfully completed.

[08:57:20.034] 

[08:57:20.034] *** SNAPSHOT SNAPINFO DISK

[08:57:20.050] 

[08:57:20.050] UPDATE MOST RECENT SNAPINFO DRIVE SNAPSHOT NAME

[08:57:25.831] SNAPSHOT SNAPINFO DRIVE

[08:57:25.831] Creating Snapshot of LUN(s):

[08:57:25.831] LUN [S]

[08:57:25.831] Snapshot name: sqlinfo__ei-sql-qa__recent

[08:57:32.144] [SnapDrive Error]: Creation of backup (sqlinfo__ei-sql-qa__recent) failed. Reason: (The backup or job name sqlinfo__ei-sql-qa__recent already exists. Names must be unique.).

(SnapDrive Error Code: 0xc0041074)

[08:57:32.144] Failed to create snapshot of LUN S.

[08:57:32.144] Not to update SnapMirror after operation. Skip SMVI metadata transform also.

[08:57:32.144] *** VERIFY DATABASE AFTER BACKUP

[08:57:32.159] Collecting verification information...

[08:57:32.159] Getting database backup information from SnapInfo file...

[08:57:32.159] Initializing SnapManager server on remote machine [ECO_SQL_QA1]...

[08:57:32.175] Remote server is connected...

[08:57:33.034] Mounting Snapshot [sqlsnap__ei-sql-qa__recent] for LUN [E] of Computer [EI-SQL-QA]

[08:57:33.050] SnapManager will use directory [C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint] to mount snapshot [sqlsnap__ei-sql-qa__recent]

[08:57:33.050] Mount point directory [C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint]

[08:57:33.050] Snapshot will be mounted on subdirectory [MPDisk001]

[08:59:45.709] This Snapshot is mounted as the drive [C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001].

[08:59:46.037] Mount Snapshot succeeded.

[08:59:46.052] Mounting Snapshot [sqlsnap__ei-sql-qa__recent] for LUN [F] of Computer [EI-SQL-QA]

[08:59:46.052] SnapManager will use directory [C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint] to mount snapshot [sqlsnap__ei-sql-qa__recent]

[08:59:46.052] Mount point directory [C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint]

[08:59:46.959] Snapshot will be mounted on subdirectory [MPDisk002]

[09:00:06.365] This Snapshot is mounted as the drive [C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002].

[09:00:06.600] Mount Snapshot succeeded.

[09:00:06.756] Using existing connection to server [ECO_SQL_QA1]...

[09:00:07.193] Attaching database [acct_rpt__Clone]...

[09:00:07.209] CREATE DATABASE [acct_rpt__Clone] ON PRIMARY (NAME = 'ACCT_RPT', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001\Data\acct_rpt.mdf') LOG ON (NAME = 'ACCT_RPT_log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002\Log\acct_rpt_log.ldf') FOR ATTACH

[09:00:07.256] CREATE DATABASE permission denied in database 'master'.

[09:00:07.287] DBCC CHECKDB (N'acct_rpt__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY

[09:00:07.365] Could not find database 'acct_rpt__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.

[09:00:07.381] WARNING: SQLServer DBCC CHECKDB failed.

[09:00:07.381] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409d8

[09:00:07.412] Detaching database [acct_rpt__Clone].

[09:00:07.522] ALTER DATABASE acct_rpt__Clone SET OFFLINE

[09:00:07.553] User does not have permission to alter database 'acct_rpt__Clone', the database does not exist, or the database is not in a state that allows access checks.

ALTER DATABASE statement failed.

[09:00:07.553] Failed to Detach Database.

[09:00:07.553] Attaching database [APCO__Clone]...

[09:00:07.568] CREATE DATABASE [APCO__Clone] ON PRIMARY (NAME = 'apco_Data', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001\Data\APCO.mdf') LOG ON (NAME = 'apco_Log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002\Log\APCO_log.ldf'), (NAME = 'apco_2_log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002\Log\apco_2_log.ldf') FOR ATTACH

[09:00:07.568] CREATE DATABASE permission denied in database 'master'.

[09:00:07.584] DBCC CHECKDB (N'APCO__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY

[09:00:07.584] Could not find database 'APCO__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.

[09:00:07.600] WARNING: SQLServer DBCC CHECKDB failed.

[09:00:07.600] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409d8

[09:00:07.600] Detaching database [APCO__Clone].

[09:00:07.709] ALTER DATABASE APCO__Clone SET OFFLINE

[09:00:07.709] User does not have permission to alter database 'APCO__Clone', the database does not exist, or the database is not in a state that allows access checks.

ALTER DATABASE statement failed.

[09:00:07.725] Failed to Detach Database.

[09:00:07.725] Attaching database [apco_conv__Clone]...

[09:00:07.725] CREATE DATABASE [apco_conv__Clone] ON PRIMARY (NAME = 'apco_conv', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001\Data\apco_conv.mdf') LOG ON (NAME = 'apco_conv_log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002\Log\APCO_conv_log.ldf') FOR ATTACH

[09:00:07.740] CREATE DATABASE permission denied in database 'master'.

[09:00:07.740] DBCC CHECKDB (N'apco_conv__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY

[09:00:07.756] Could not find database 'apco_conv__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.

[09:00:07.756] WARNING: SQLServer DBCC CHECKDB failed.

[09:00:07.756] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409d8

[09:00:07.772] Detaching database [apco_conv__Clone].

[09:00:07.865] ALTER DATABASE apco_conv__Clone SET OFFLINE

[09:00:07.881] User does not have permission to alter database 'apco_conv__Clone', the database does not exist, or the database is not in a state that allows access checks.

ALTER DATABASE statement failed.

[09:00:07.897] Failed to Detach Database.

[09:00:07.897] Attaching database [asrating__Clone]...

[09:00:07.897] CREATE DATABASE [asrating__Clone] ON PRIMARY (NAME = 'asrating_Data', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001\Data\asrating_Data.MDF') LOG ON (NAME = 'asrating_Log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002\Log\asrating.LDF') FOR ATTACH

[09:00:07.912] CREATE DATABASE permission denied in database 'master'.

[09:00:07.912] DBCC CHECKDB (N'asrating__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY

[09:00:07.928] Could not find database 'asrating__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.

[09:00:07.928] WARNING: SQLServer DBCC CHECKDB failed.

[09:00:07.928] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409d8

[09:00:07.943] Detaching database [asrating__Clone].

[09:00:08.037] ALTER DATABASE asrating__Clone SET OFFLINE

[09:00:08.053] User does not have permission to alter database 'asrating__Clone', the database does not exist, or the database is not in a state that allows access checks.

ALTER DATABASE statement failed.

[09:00:08.053] Failed to Detach Database.

[09:00:08.053] Attaching database [CopyOfrates2003__Clone]...

[09:00:08.068] CREATE DATABASE [CopyOfrates2003__Clone] ON PRIMARY (NAME = 'rates2003_Data', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001\Data\CopyOfrates2003_rates2003_26136.MDF') LOG ON (NAME = 'rates2003_Log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002\Log\CopyOfrates2003_rates2003_Log_26136.LDF') FOR ATTACH

[09:00:08.068] CREATE DATABASE permission denied in database 'master'.

[09:00:08.084] DBCC CHECKDB (N'CopyOfrates2003__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY

[09:00:08.100] Could not find database 'CopyOfrates2003__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.

[09:00:08.100] WARNING: SQLServer DBCC CHECKDB failed.

[09:00:08.100] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409d8

[09:00:08.115] Detaching database [CopyOfrates2003__Clone].

[09:00:08.209] ALTER DATABASE CopyOfrates2003__Clone SET OFFLINE

[09:00:08.225] User does not have permission to alter database 'CopyOfrates2003__Clone', the database does not exist, or the database is not in a state that allows access checks.

ALTER DATABASE statement failed.

[09:00:08.225] Failed to Detach Database.

[09:00:08.240] Attaching database [DOL_PUSH__Clone]...

[09:00:08.240] CREATE DATABASE [DOL_PUSH__Clone] ON PRIMARY (NAME = 'DOL_PUSH', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001\Data\DOL_PUSH.MDF') LOG ON (NAME = 'DOL_PUSH_log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002\Log\DOL_PUSH_log.ldf') FOR ATTACH

[09:00:08.256] CREATE DATABASE permission denied in database 'master'.

[09:00:08.272] DBCC CHECKDB (N'DOL_PUSH__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY

[09:00:08.287] Could not find database 'DOL_PUSH__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.

[09:00:08.287] WARNING: SQLServer DBCC CHECKDB failed.

[09:00:08.287] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409d8

[09:00:08.303] Detaching database [DOL_PUSH__Clone].

[09:00:08.412] ALTER DATABASE DOL_PUSH__Clone SET OFFLINE

[09:00:08.412] User does not have permission to alter database 'DOL_PUSH__Clone', the database does not exist, or the database is not in a state that allows access checks.

ALTER DATABASE statement failed.

[09:00:08.412] Failed to Detach Database.

[09:00:08.428] Attaching database [RateBooks__Clone]...

[09:00:08.428] CREATE DATABASE [RateBooks__Clone] ON PRIMARY (NAME = 'RateBooks', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001\Data\RateBooks.MDF') LOG ON (NAME = 'RateBooks_log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002\Log\RateBooks_Log.LDF') FOR ATTACH

[09:00:08.443] CREATE DATABASE permission denied in database 'master'.

[09:00:08.443] DBCC CHECKDB (N'RateBooks__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY

[09:00:08.459] Could not find database 'RateBooks__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.

[09:00:08.475] WARNING: SQLServer DBCC CHECKDB failed.

[09:00:08.475] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409d8

[09:00:08.475] Detaching database [RateBooks__Clone].

[09:00:08.584] ALTER DATABASE RateBooks__Clone SET OFFLINE

[09:00:08.600] User does not have permission to alter database 'RateBooks__Clone', the database does not exist, or the database is not in a state that allows access checks.

ALTER DATABASE statement failed.

[09:00:08.600] Failed to Detach Database.

[09:00:08.615] Attaching database [rates2003__Clone]...

[09:00:08.615] CREATE DATABASE [rates2003__Clone] ON PRIMARY (NAME = 'rates2003_Data', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001\Data\rates2003_rates2003_20134.MDF') LOG ON (NAME = 'rates2003_Log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002\Log\rates2003_rates2003_Log_20134.LDF') FOR ATTACH

[09:00:08.631] CREATE DATABASE permission denied in database 'master'.

[09:00:08.631] DBCC CHECKDB (N'rates2003__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY

[09:00:08.647] Could not find database 'rates2003__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.

[09:00:08.662] WARNING: SQLServer DBCC CHECKDB failed.

[09:00:08.709] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409d8

[09:00:08.709] Detaching database [rates2003__Clone].

[09:00:08.818] ALTER DATABASE rates2003__Clone SET OFFLINE

[09:00:08.834] User does not have permission to alter database 'rates2003__Clone', the database does not exist, or the database is not in a state that allows access checks.

ALTER DATABASE statement failed.

[09:00:08.834] Failed to Detach Database.

[09:00:08.834] Attaching database [RevRpt__Clone]...

[09:00:08.850] CREATE DATABASE [RevRpt__Clone] ON PRIMARY (NAME = 'RevRpt_Data', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001\Data\RevRpt.MDF') LOG ON (NAME = 'RevRpt_Log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002\Log\RevRpt_log.ldf') FOR ATTACH

[09:00:08.850] CREATE DATABASE permission denied in database 'master'.

[09:00:08.850] DBCC CHECKDB (N'RevRpt__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY

[09:00:08.865] Could not find database 'RevRpt__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.

[09:00:08.865] WARNING: SQLServer DBCC CHECKDB failed.

[09:00:08.881] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409d8

[09:00:08.881] Detaching database [RevRpt__Clone].

[09:00:08.990] ALTER DATABASE RevRpt__Clone SET OFFLINE

[09:00:09.006] User does not have permission to alter database 'RevRpt__Clone', the database does not exist, or the database is not in a state that allows access checks.

ALTER DATABASE statement failed.

[09:00:09.022] Failed to Detach Database.

[09:00:09.022] Attaching database [security__Clone]...

[09:00:09.022] CREATE DATABASE [security__Clone] ON PRIMARY (NAME = 'security_Data', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001\Data\security_data.mdf') LOG ON (NAME = 'security_Log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002\Log\security_Log.LDF') FOR ATTACH

[09:00:09.037] CREATE DATABASE permission denied in database 'master'.

[09:00:09.037] DBCC CHECKDB (N'security__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY

[09:00:09.053] Could not find database 'security__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.

[09:00:09.068] WARNING: SQLServer DBCC CHECKDB failed.

[09:00:09.068] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409d8

[09:00:09.068] Detaching database [security__Clone].

[09:00:09.178] ALTER DATABASE security__Clone SET OFFLINE

[09:00:09.193] User does not have permission to alter database 'security__Clone', the database does not exist, or the database is not in a state that allows access checks.

ALTER DATABASE statement failed.

[09:00:09.193] Failed to Detach Database.

[09:00:09.225] Attaching database [unix_reports__Clone]...

[09:00:09.225] CREATE DATABASE [unix_reports__Clone] ON PRIMARY (NAME = 'unix_reports_Data', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001\Data\unix_reports_Data.MDF') LOG ON (NAME = 'unix_reports_Log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002\Log\unix_reports_Log.LDF') FOR ATTACH

[09:00:09.240] CREATE DATABASE permission denied in database 'master'.

[09:00:09.240] DBCC CHECKDB (N'unix_reports__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY

[09:00:09.256] Could not find database 'unix_reports__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.

[09:00:09.272] WARNING: SQLServer DBCC CHECKDB failed.

[09:00:09.272] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409d8

[09:00:09.272] Detaching database [unix_reports__Clone].

[09:00:09.381] ALTER DATABASE unix_reports__Clone SET OFFLINE

[09:00:09.397] User does not have permission to alter database 'unix_reports__Clone', the database does not exist, or the database is not in a state that allows access checks.

ALTER DATABASE statement failed.

[09:00:09.397] Failed to Detach Database.

[09:00:09.428] Attaching database [webreports__Clone]...

[09:00:09.428] CREATE DATABASE [webreports__Clone] ON PRIMARY (NAME = 'webreports_Data', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001\Data\webreports_Data.MDF') LOG ON (NAME = 'webreports_Log', FILENAME = 'C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002\Log\webreports_log.LDF') FOR ATTACH

[09:00:09.428] CREATE DATABASE permission denied in database 'master'.

[09:00:09.443] DBCC CHECKDB (N'webreports__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY

[09:00:09.443] Could not find database 'webreports__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.

[09:00:09.459] WARNING: SQLServer DBCC CHECKDB failed.

[09:00:09.459] SQLServer DBCC CHECKDB Failed, Error Code: 0x800409d8

[09:00:09.459] Detaching database [webreports__Clone].

[09:00:09.568] ALTER DATABASE webreports__Clone SET OFFLINE

[09:00:09.568] User does not have permission to alter database 'webreports__Clone', the database does not exist, or the database is not in a state that allows access checks.

ALTER DATABASE statement failed.

[09:00:09.600] Failed to Detach Database.

[09:00:09.615] Dismounting LUN C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk001 of SnapShot [sqlsnap__ei-sql-qa__recent]...

[09:00:24.522] Dismount Snapshot succeeded.

[09:00:24.537] Dismounting LUN C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint\MPDisk002 of SnapShot [sqlsnap__ei-sql-qa__recent]...

[09:01:26.851] Dismount Snapshot succeeded.

[09:01:27.492] Remote verification failed with FaultException<SmException>: Error code: 0x800409d8.

[09:01:27.492] Unknown Error, Error Code: 0x800409d8

[09:01:27.492] Database verification information was not updated.

[09:01:27.507] There is an error during database verification.

[09:01:27.507] 

[09:01:27.507] **** FULL DATABASE BACKUP RESULT SUMMARY #1 ****

[09:01:27.507] Backup Time: 01-24-2012_08.56.38

[09:01:27.945] Backup Group [#1]:

[09:01:27.945] #1 : [EI-SQL-QA - acct_rpt] : Failed with error code 0xc0040814.

[09:01:27.945] #1 : [EI-SQL-QA - acct_rpt] Error : Backup OK, but DBCC Skipped.

[09:01:27.945] #2 : [EI-SQL-QA - APCO] : Failed with error code 0xc0040814.

[09:01:27.945] #2 : [EI-SQL-QA - APCO] Error : Backup OK, but DBCC Skipped.

[09:01:27.945] #3 : [EI-SQL-QA - apco_conv] : Failed with error code 0xc0040814.

[09:01:27.945] #3 : [EI-SQL-QA - apco_conv] Error : Backup OK, but DBCC Skipped.

[09:01:27.945] #4 : [EI-SQL-QA - asrating] : Failed with error code 0xc0040814.

[09:01:27.945] #4 : [EI-SQL-QA - asrating] Error : Backup OK, but DBCC Skipped.

[09:01:27.945] #5 : [EI-SQL-QA - CopyOfrates2003] : Failed with error code 0xc0040814.

[09:01:27.945] #5 : [EI-SQL-QA - CopyOfrates2003] Error : Backup OK, but DBCC Skipped.

[09:01:27.945] #6 : [EI-SQL-QA - DOL_PUSH] : Failed with error code 0xc0040814.

[09:01:27.945] #6 : [EI-SQL-QA - DOL_PUSH] Error : Backup OK, but DBCC Skipped.

[09:01:27.945] #7 : [EI-SQL-QA - RateBooks] : Failed with error code 0xc0040814.

[09:01:27.945] #7 : [EI-SQL-QA - RateBooks] Error : Backup OK, but DBCC Skipped.

[09:01:27.945] #8 : [EI-SQL-QA - rates2003] : Failed with error code 0xc0040814.

[09:01:27.945] #8 : [EI-SQL-QA - rates2003] Error : Backup OK, but DBCC Skipped.

[09:01:27.945] #9 : [EI-SQL-QA - RevRpt] : Failed with error code 0xc0040814.

[09:01:27.945] #9 : [EI-SQL-QA - RevRpt] Error : Backup OK, but DBCC Skipped.

[09:01:27.945] #10 : [EI-SQL-QA - security] : Failed with error code 0xc0040814.

[09:01:27.945] #10 : [EI-SQL-QA - security] Error : Backup OK, but DBCC Skipped.

[09:01:27.945] #11 : [EI-SQL-QA - unix_reports] : Failed with error code 0xc0040814.

[09:01:27.945] #11 : [EI-SQL-QA - unix_reports] Error : Backup OK, but DBCC Skipped.

[09:01:27.945] #12 : [EI-SQL-QA - webreports] : Failed with error code 0xc0040814.

[09:01:27.961] #12 : [EI-SQL-QA - webreports] Error : Backup OK, but DBCC Skipped.

[09:01:28.148] 

[09:01:28.148] **** FULL DATABASE BACKUP RESULT SUMMARY ****

[09:01:28.148] Backup Time: 01-24-2012_08.56.38

[09:01:28.148] Backup Group [#1]:

[09:01:28.148] #1 : [EI-SQL-QA - master] : Failed with error code 0xc0040827.

[09:01:28.148] #2 : [EI-SQL-QA - model] : Failed with error code 0xc0040827.

[09:01:28.148] #3 : [EI-SQL-QA - msdb] : Failed with error code 0xc0040827.

[09:01:28.148] 

[09:01:28.148] *** SNAPMANAGER BACKUP JOB ENDED AT: [01-24-2012 09.01.28]

[09:01:28.148] The backup of one or more databases failed.

Thanks in advance

Derrick

1 REPLY 1

radek_kubka

Hi and welcome to the Community!

This is where things start to fail:

[08:56:48.846] Failed to create SnapInfo Directory.

[08:56:48.846] Failed to Get SnapInfo Directory from Registry

Can you try running Configuration Wizard again & if it doesn't help, reinstall SMSQL?

Regards,
Radek

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public