Data Backup and Recovery

Problem with Verification

DKJMM2012
4,541 Views

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
4,541 Views

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

Public