z***y 发帖数: 7151 | 1 这是一个判断DBA有没有一个好的习惯,是基本素质测试:
Your network team called for DBA's help. The network engineer maintains
their own SQL Server 2005 standard edition server. There are a few
databases running on that server. They used maintenance wizard to create a
couple of backup jobs. One is daily full backup job for all users' database
and one is log backup job running every 1 hour for all users' database. They
found that the log backup job has been failed since two days ago.
You review the job history and found t |
j*****n 发帖数: 1781 | 2 really good question!
1. Ask who did that and why. The first thing jump into my mind is that the
device where stores the log file might lack of space. if so, try to increase
space or consider moving the log file to another device with enough space
if possible.
2. check to see if any bulk operation is running, DO NOT switch recovery
model while bulk operation is running.
3. after 1 and 2 are clear, start switch.
4. do a full/diff back up immediately right after switch. |
w*******e 发帖数: 1622 | 3 第一步从error message里可以看出, 不是space的问题....
要是我就直接从你的第二步开始....
increase
【在 j*****n 的大作中提到】 : really good question! : 1. Ask who did that and why. The first thing jump into my mind is that the : device where stores the log file might lack of space. if so, try to increase : space or consider moving the log file to another device with enough space : if possible. : 2. check to see if any bulk operation is running, DO NOT switch recovery : model while bulk operation is running. : 3. after 1 and 2 are clear, start switch. : 4. do a full/diff back up immediately right after switch.
|
j*****n 发帖数: 1781 | 4 No sir, the error message would not tell you the space issue since the
current
recovery model is simple. As a DBA, at least I would like to know who any
why
the guy did the change. If this SQL Server does a lot of bulk operation such
as
bulk data load, the log file is very easily expand to a big size within one
hour.
【在 w*******e 的大作中提到】 : 第一步从error message里可以看出, 不是space的问题.... : 要是我就直接从你的第二步开始.... : : increase
|
z***y 发帖数: 7151 | 5 如果是磁盘空间不够,会有9002报错。
第二点很好。
最后一点是关键。 否则Log backup job 会一直失败直到下一次full backup。
increase
【在 j*****n 的大作中提到】 : really good question! : 1. Ask who did that and why. The first thing jump into my mind is that the : device where stores the log file might lack of space. if so, try to increase : space or consider moving the log file to another device with enough space : if possible. : 2. check to see if any bulk operation is running, DO NOT switch recovery : model while bulk operation is running. : 3. after 1 and 2 are clear, start switch. : 4. do a full/diff back up immediately right after switch.
|