Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 бекап вызывается из JOB  [new]
Yuriy Zaytsev
Member

Откуда:
Сообщений: 17
во время ночного бекапа сервер отрабатывает во с такими проблемами
дико тормозит и виснет


привожу кусок лога



2011-09-09 04:00:00.62 backup BACKUP failed to complete the command BACKUP LOG DSFT WITH TRUNCATE_ONLY
DBCC SHRINKFILE(DSFT_log, 2)
DBCC SHRINKFILE(DSFT1_log, 2)
2011-09-09 04:58:52.99 backup Database backed up: Database: DSFT, creation date(time): 2011/08/22(15:43:06), pages dumped: 32228163, first LSN: 38366:25512:1, last LSN: 38366:26107:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\DIAS\BackupDSFT\HP585DSFTA.BSQL'}).
2011-09-09 07:44:33.89 backup Database backed up: Database: DSFT, creation date(time): 2011/08/22(15:43:06), pages dumped: 32228131, first LSN: 38366:26111:1, last LSN: 38366:26113:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\BackStor\DUMPS\HP585DSFTeveryDay.BSQL'}).
2011-09-10 03:43:35.11 spid59 WARNING: EC 73789518, 0 waited 300 sec. on latch 21734e90. Not a BUF latch.
2011-09-10 03:43:35.11 spid59 Waiting for type 0x3, current count 0xa, current owning EC 0x55CC7598.
2011-09-10 04:00:00.48 backup BACKUP failed to complete the command BACKUP LOG DSFT WITH TRUNCATE_ONLY
DBCC SHRINKFILE(DSFT_log, 2)
DBCC SHRINKFILE(DSFT1_log, 2)
2011-09-10 17:26:31.51 backup Database backed up: Database: DSFT, creation date(time): 2011/08/22(15:43:06), pages dumped: 36538674, first LSN: 38429:3669:73, last LSN: 39463:69074:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\DIAS\BackupDSFT\HP585DSFTA.BSQL'}).
2011-09-10 17:45:01.18 spid57 BackupMedium::ReportIoError: write failure on backup device '\\BackStor\DUMPS\HP585DSFTeveryDay.BSQL'. Operating system error 1130(error not found).
2011-09-10 17:45:01.20 spid57 Internal I/O request 0x382D7CB0: Op: Write, pBuffer: 0x0EB20000, Size: 983040, Position: 26373986816, UMS: Internal: 0x0, InternalHigh: 0xF0000, Offset: 0x24031A00, OffsetHigh: 0x6, m_buf: 0x0EB20000, m_len: 983040, m_actualBytes: 0, m_errcode: 1130, BackupFile: \\BackStor\DUMPS\HP585DSFTeveryDay.BSQL
2011-09-10 17:45:01.20 backup BACKUP failed to complete the command BACKUP DATABASE [DSFT] TO disk= '\\BackStor\DUMPS\HP585DSFTeveryDay.BSQL' WITH INIT, NOUNLOAD, NAME = N'DSFT', SKIP , STATS = 50, FORMAT
2011-09-10 17:45:01.40 spid57 BackupDiskFile::RequestDurableMedia: failure on backup device '\\BackStor\DUMPS\HP585DSFTeveryDay.BSQL'. Operating system error 1130(error not found).
2011-09-11 02:51:00.58 spid58 BPool::Map: no remappable address found.
2011-09-11 02:51:00.60 spid57 BPool::Map: no remappable address found.
2011-09-11 02:51:00.66 spid57 Buffer Distribution: Stolen=2049 Free=656 Procedures=270
Inram=0 Dirty=208836 Kept=0
I/O=192, Latched=30, Other=1360831
2011-09-11 02:51:00.66 spid57 Buffer Counts: Commited=1572864 Target=1572864 Hashed=1569889
InternalReservation=142 ExternalReservation=0 Min Free=512
2011-09-11 02:51:00.66 spid57 Procedure Cache: TotalProcs=99 TotalPages=270 InUsePages=118
2011-09-11 02:51:00.66 spid57 Dynamic Memory Manager: Stolen=2319 OS Reserved=1544
OS Committed=1522
OS In Use=1514
Query Plan=275 Optimizer=0
General=1739
Utilities=12 Connection=80
2011-09-11 02:51:00.66 spid57 Global Memory Objects: Resource=1571 Locks=1177
SQLCache=78 Replication=2
LockBytes=2 ServerGlobal=58
Xact=12
2011-09-11 02:51:00.66 spid57 Query Memory Manager: Grants=0 Waiting=0 Maximum=143080 Available=143080
2011-09-11 02:51:00.66 spid58 Buffer Distribution: Stolen=2050 Free=655 Procedures=270
Inram=0 Dirty=208836 Kept=0
I/O=192, Latched=30, Other=1360831
2011-09-11 02:51:00.66 spid58 Buffer Counts: Commited=1572864 Target=1572864 Hashed=1569889
InternalReservation=142 ExternalReservation=0 Min Free=512
2011-09-11 02:51:00.66 spid58 Procedure Cache: TotalProcs=99 TotalPages=270 InUsePages=118
2011-09-11 02:51:00.66 spid58 Dynamic Memory Manager: Stolen=2319 OS Reserved=1544
OS Committed=1522
OS In Use=1514
Query Plan=275 Optimizer=0
General=1739
Utilities=12 Connection=80
2011-09-11 02:51:00.66 spid58 Global Memory Objects: Resource=1571 Locks=1177
SQLCache=78 Replication=2
LockBytes=2 ServerGlobal=58
Xact=12
2011-09-11 02:51:00.66 spid58 Query Memory Manager: Grants=0 Waiting=0 Maximum=143080 Available=143080
2011-09-11 02:51:00.69 spid57 BPool::Map: no remappable address found.
2011-09-11 02:51:00.71 spid58 BPool::Map: no remappable address found.
2011-09-11 02:51:00.75 spid57 Buffer Distribution: Stolen=2051 Free=654 Procedures=270
Inram=0 Dirty=208836 Kept=0
I/O=192, Latched=30, Other=1360831
2011-09-11 02:51:00.75 spid57 Buffer Counts: Commited=1572864 Target=1572864 Hashed=1569889
InternalReservation=142 ExternalReservation=0 Min Free=512
2011-09-11 02:51:00.75 spid57 Procedure Cache: TotalProcs=99 TotalPages=270 InUsePages=118
2011-09-11 02:51:00.75 spid57 Dynamic Memory Manager: Stolen=2319 OS Reserved=1544
OS Committed=1522
OS In Use=1514
Query Plan=275 Optimizer=0
General=1739
Utilities=12 Connection=80
13 сен 11, 07:49    [11266926]     Ответить | Цитировать Сообщить модератору
 Re: бекап вызывается из JOB  [new]
uncle_max
Member

Откуда:
Сообщений: 70
Возможно Вам помогут здесь http://blogs.msdn.com/b/john_daskalakis/archive/2010/02/01/9956268.aspx
13 сен 11, 08:17    [11266976]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить