Shiv_Sankar
16 years agoLevel 4
Snapshot Error 156 - Win2K3 Server(SQL DB Server)
Friends,
One of our Win2K3 server is failing with snapshot error 156 frequently. SQL database is running on the server.
When backing up all local drives(C,D,E and F) , I am gettting this error(Particularly .bak files are getting backed up).
No VSS or VSP is enabled for windows open file backup.
Free space for C is 7 gb, D is 9 gb, E is 10 mb and F is 6.8 gb in the server. Could you pls suggest me to resolve the issue...?
BPBKAR Log:
6:00:05.570 AM: [5404.4576] <4> tar_base::V_vTarMsgW: INF - tar message received from dos_backup::tfs_readdata
6:00:05.570 AM: [5404.4576] <2> tar_base::V_vTarMsgW: ERR - failure reading file: D:\MSSBKUP\SQLSHNMOM3P\Database\old_DB_0726.BAK (WIN32 5: Access is denied. )
6:00:05.570 AM: [5404.4576] <4> dos_backup::tfs_readdata: INF - will skip file when clearing archive bits: 'D:\MSSBKUP\SQLSHNMOM3P\Database\old_DB_0726.BAK'
6:00:05.570 AM: [5404.4576] <4> V_VSP_CheckForError: INF - Error Checking for Volume{da148788-6812-450f-96d1-b7676e014d85}
6:00:05.570 AM: [5404.4576] <4> V_VSP_CheckForError: INF - Error Status (Volume{da148788-6812-450f-96d1-b7676e014d85}): 112
6:00:05.570 AM: [5404.4576] <4> tar_base::V_vTarMsgW: INF - tar message received from dos_backup::tfs_readdata
6:00:05.570 AM: [5404.4576] <2> tar_base::V_vTarMsgW: ERR - Snapshot Error while reading file: Volume{da148788-6812-450f-96d1-b7676e014d85}\MSSBKUP\SQLSHNMOM3P\Database\old_DB_0726.BAK
6:00:05.570 AM: [5404.4576] <4> dos_backup::tfs_readdata: INF - will skip file when clearing archive bits: 'MSSBKUP\SQLSHNMOM3P\Database\old_DB_0726.BAK
6:00:05.570 AM: [5404.4576] <4> tar_base::V_vTarMsgW: INF - tar message received from tar_backup::nextfile_state_switch
6:00:05.570 AM: [5404.4576] <2> tar_base::V_vTarMsgW: FTL - Backup operation aborted!
6:00:05.570 AM: [5404.4576] <2> tar_base::V_vTarMsgW: INF - Client completed sending data for backup
6:00:05.570 AM: [5404.4576] <4> tar_base::V_StopKeepaliveThread: INF - Waiting for Keepalive Thread to EXIT
6:00:05.570 AM: [5404.5768] <4> tar_base::V_KeepaliveThread: INF - Keepalive Thread Terminating. Mutex:WAIT_OBJECT_0
6:00:05.570 AM: [5404.4576] <4> tar_base::V_StopKeepaliveThread: INF - The Keepalive Thread has Exited. Wait Reason:WAIT_OBJECT_0
6:00:05.570 AM: [5404.4576] <2> tar_base::V_vTarMsgW: INF - EXIT STATUS 156: snapshot error encountered
One of our Win2K3 server is failing with snapshot error 156 frequently. SQL database is running on the server.
When backing up all local drives(C,D,E and F) , I am gettting this error(Particularly .bak files are getting backed up).
No VSS or VSP is enabled for windows open file backup.
Free space for C is 7 gb, D is 9 gb, E is 10 mb and F is 6.8 gb in the server. Could you pls suggest me to resolve the issue...?
BPBKAR Log:
6:00:05.570 AM: [5404.4576] <4> tar_base::V_vTarMsgW: INF - tar message received from dos_backup::tfs_readdata
6:00:05.570 AM: [5404.4576] <2> tar_base::V_vTarMsgW: ERR - failure reading file: D:\MSSBKUP\SQLSHNMOM3P\Database\old_DB_0726.BAK (WIN32 5: Access is denied. )
6:00:05.570 AM: [5404.4576] <4> dos_backup::tfs_readdata: INF - will skip file when clearing archive bits: 'D:\MSSBKUP\SQLSHNMOM3P\Database\old_DB_0726.BAK'
6:00:05.570 AM: [5404.4576] <4> V_VSP_CheckForError: INF - Error Checking for Volume{da148788-6812-450f-96d1-b7676e014d85}
6:00:05.570 AM: [5404.4576] <4> V_VSP_CheckForError: INF - Error Status (Volume{da148788-6812-450f-96d1-b7676e014d85}): 112
6:00:05.570 AM: [5404.4576] <4> tar_base::V_vTarMsgW: INF - tar message received from dos_backup::tfs_readdata
6:00:05.570 AM: [5404.4576] <2> tar_base::V_vTarMsgW: ERR - Snapshot Error while reading file: Volume{da148788-6812-450f-96d1-b7676e014d85}\MSSBKUP\SQLSHNMOM3P\Database\old_DB_0726.BAK
6:00:05.570 AM: [5404.4576] <4> dos_backup::tfs_readdata: INF - will skip file when clearing archive bits: 'MSSBKUP\SQLSHNMOM3P\Database\old_DB_0726.BAK
6:00:05.570 AM: [5404.4576] <4> tar_base::V_vTarMsgW: INF - tar message received from tar_backup::nextfile_state_switch
6:00:05.570 AM: [5404.4576] <2> tar_base::V_vTarMsgW: FTL - Backup operation aborted!
6:00:05.570 AM: [5404.4576] <2> tar_base::V_vTarMsgW: INF - Client completed sending data for backup
6:00:05.570 AM: [5404.4576] <4> tar_base::V_StopKeepaliveThread: INF - Waiting for Keepalive Thread to EXIT
6:00:05.570 AM: [5404.5768] <4> tar_base::V_KeepaliveThread: INF - Keepalive Thread Terminating. Mutex:WAIT_OBJECT_0
6:00:05.570 AM: [5404.4576] <4> tar_base::V_StopKeepaliveThread: INF - The Keepalive Thread has Exited. Wait Reason:WAIT_OBJECT_0
6:00:05.570 AM: [5404.4576] <2> tar_base::V_vTarMsgW: INF - EXIT STATUS 156: snapshot error encountered
- Please check
host properties ->master server ->client attributes -> select the client which is giving this server and uncheck the option enable windows open file backups for this client if it is enable.
Regards,
Suman