由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - sql server 面试题 (8)
相关主题
sql server: database backup 请教Any SSIS high hand here?
sql server 面试题 (7)什么也不懂,要考个SQL Server 的证
SQL SERVER 2K5 schema vs. Oracle schema招db developer, dba (austin tx)
有考SQL 2008 70-433认证得吗请问Junior Oracle DBA Salary
求科普database方向MS SQL Server copy database wizard
问一下SQL SERVER 2012考证.扯扯Senior SQL Server DBA咋整 (2)
how to register SQL Server in intranetRe: 想问问dba的收入 (转载)
怎么准备第一份DBA工作很多人認為 DBA = Database Backup Admin
相关话题的讨论汇总
话题: server话题: backup话题: sql话题: dba话题: log
进入Database版参与讨论
1 (共1页)
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.

1 (共1页)
进入Database版参与讨论
相关主题
很多人認為 DBA = Database Backup Admin求科普database方向
DBA vs Database Developer问一下SQL SERVER 2012考证.
Quick way to learn database?how to register SQL Server in intranet
新手求助: 学那个DATABASE软件好呢?怎么准备第一份DBA工作
sql server: database backup 请教Any SSIS high hand here?
sql server 面试题 (7)什么也不懂,要考个SQL Server 的证
SQL SERVER 2K5 schema vs. Oracle schema招db developer, dba (austin tx)
有考SQL 2008 70-433认证得吗请问Junior Oracle DBA Salary
相关话题的讨论汇总
话题: server话题: backup话题: sql话题: dba话题: log