由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - sql server 面试题 (2)
相关主题
differential backup里面的数据能提取吗?[紧急]求助。关于MSSQL Rollback问题
Any Suggestions on a SQL Server database maintenance planHigh Performance MySQL: Optimization, Backups ...
各位各位,江湖救急 -- 数据被删how to hot back mysql?
五月份免费SQL培训时间 (转载)Database Backup Question
oracle问题请教sql server DB 大侠
HELP: How to restore SQL server 7 backup file to SQL server 2000?sql server 2005 问题
Re: HELP: How to restore SQL server 7 backup file to SQL server 2000?翻译问题,急救啊!
MySQL database backupMySQL Server is Open Source, even Backup extensions(ZZ)
相关话题的讨论汇总
话题: backup话题: log话题: diff话题: full1话题: failure
进入Database版参与讨论
1 (共1页)
z***y
发帖数: 7151
1
Now I have a VLDB about 2.5 Tera bytes. Now I need to do full backup right
away, but also find that the log backup job is running. So in that case can
I go ahead doing full backup while the log backup is running?
这个是为一家软件公司的Principle Field Engineer面试的。 属于那种比较不常见的
问题。
还有一道关于备份的。
You as DBA need to do full backup for your production database, but you were
told the backup plan for this database is FULL==》DIFF==>DIFF==>FULL==>DIFF
==>DIFF==>DIFF from Sunday to Saturday. You were also told to keep t
j*****n
发帖数: 1781
2
1.
didn't try concurrent backups before... however, based on BooksOnline,
backup is an online operation except DDL. I believe that you can do it
without problem.
2.
Yes, this chain is doable.
Use SSIS for maintenance plan.
z***y
发帖数: 7151
3
第一个解释的很好。
第二个:应该用backup database COPY_ONLY option.
j*****n
发帖数: 1781
4
哦,再仔细看了一遍你的问题,才发现自己理解错误, 呵呵
COPY_ONLY
Specifies that the backup is a copy-only backup, which does not affect the
normal sequence of backups. A copy-only backup is created independently of
your regularly scheduled, conventional backups. A copy-only backup does not
affect your overall backup and restore procedures for the database.
Copy-only backups were introduced in SQL Server 2005 for use in situations
in which a backup is taken for a special purpose, such as backing up the log
before an online

【在 z***y 的大作中提到】
: 第一个解释的很好。
: 第二个:应该用backup database COPY_ONLY option.

c*****d
发帖数: 6045
5
1. 我认为没问题
不过我觉得jackrun的解释有问题
文档里有这么一句话
"The transaction log cannot be backed up during a full database backup or a
differential database backup."
如果按照jackrun的解释,在database backup和diff backup过程中也应该可以log back
up

【在 z***y 的大作中提到】
: 第一个解释的很好。
: 第二个:应该用backup database COPY_ONLY option.

c*****d
发帖数: 6045
6
2. 没看懂这道题问什么呢
Sun ==> Mon ==>Tue ==>Wed ==>Thur ==>Fri ==>Sat
FULL0==>DIFF1==>DIFF2==>FULL1==>DIFF3==>DIFF4==>DIFF5
恢复策略是,
failure before Mon backup, FULL0 + log
failure before Tue backup, FULL0 + DIFF1 + log
failure before Wed backup, FULL0 + DIFF2 + log
failure before Thur backup, FULL1 + log
failure before Fri backup, FULL1 + DIFF3 + log
failure before Sat backup, FULL1 + DIFF4 + log
failure before Sun backup, FULL1 + DIFF5 + log
Sun ==> Mon ==>Tue ==>Wed ==>Thur ==>Fri
c*****d
发帖数: 6045
7
2. 没看懂这道题问什么呢
Sun ==> Mon ==>Tue ==>Wed ==>Thur ==>Fri ==>Sat
FULL0==>DIFF1==>DIFF2==>FULL1==>DIFF3==>DIFF4==>DIFF5
恢复策略是,
failure before Mon backup, FULL0 + log
failure before Tue backup, FULL0 + DIFF1 + log
failure before Wed backup, FULL0 + DIFF2 + log
failure before Thur backup, FULL1 + log
failure before Fri backup, FULL1 + DIFF3 + log
failure before Sat backup, FULL1 + DIFF4 + log
failure before Sun backup, FULL1 + DIFF5 + log
Sun ==> Mon ==>Tue ==>Wed ==>Thur ==>Fri
w*******e
发帖数: 1622
8
是没问题.
不过, zenny出的这题有问题.
在backup database时再进行log backup, 就破坏了该log chain...因为这时进行的log
backup是以它之前的full backup为基础的. 说笼统点是, 这时的log backup基本没用.
Worst scenario是: 这时的log backup有点乱, 可能某transaction是之前full backup
的, 某transaction 是之后这个full backup的. ---- (not sure about this. zenny
说说?)

a
back

【在 c*****d 的大作中提到】
: 1. 我认为没问题
: 不过我觉得jackrun的解释有问题
: 文档里有这么一句话
: "The transaction log cannot be backed up during a full database backup or a
: differential database backup."
: 如果按照jackrun的解释,在database backup和diff backup过程中也应该可以log back
: up

w*******e
发帖数: 1622
9
酷比是oracle的, 估计不太懂SQL Server.
在SQL 2000里, 这个要求是不可能实现的, 所以LZ特意强调了SQL2005.

【在 c*****d 的大作中提到】
: 2. 没看懂这道题问什么呢
: Sun ==> Mon ==>Tue ==>Wed ==>Thur ==>Fri ==>Sat
: FULL0==>DIFF1==>DIFF2==>FULL1==>DIFF3==>DIFF4==>DIFF5
: 恢复策略是,
: failure before Mon backup, FULL0 + log
: failure before Tue backup, FULL0 + DIFF1 + log
: failure before Wed backup, FULL0 + DIFF2 + log
: failure before Thur backup, FULL1 + log
: failure before Fri backup, FULL1 + DIFF3 + log
: failure before Sat backup, FULL1 + DIFF4 + log

c*****d
发帖数: 6045
10
黑马,能详细解释一下吗?
这道题里什么要求在2000里不能实现?
是不是因为wed进行full backup后以前的diff备份都没用了
这个叫做破坏了backup chain?

【在 w*******e 的大作中提到】
: 酷比是oracle的, 估计不太懂SQL Server.
: 在SQL 2000里, 这个要求是不可能实现的, 所以LZ特意强调了SQL2005.

c*****d
发帖数: 6045
11
呵呵,一下就被黑马给看出来了
我是做Oracle的
对SQL Server的东西都是把Oracle的类似知识套过来用
不过,下一个可能的offer是做SQL Server的
希望以后能oracle/ms双修

【在 w*******e 的大作中提到】
: 酷比是oracle的, 估计不太懂SQL Server.
: 在SQL 2000里, 这个要求是不可能实现的, 所以LZ特意强调了SQL2005.

c*****d
发帖数: 6045
12
探讨一下

log
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~这时不能log backup
用.
~~~~~~~~~~~~~~~~~~~~~~~~~~~这个理解不对吧,应该是上一次log
backup
backup
zenny

【在 w*******e 的大作中提到】
: 是没问题.
: 不过, zenny出的这题有问题.
: 在backup database时再进行log backup, 就破坏了该log chain...因为这时进行的log
: backup是以它之前的full backup为基础的. 说笼统点是, 这时的log backup基本没用.
: Worst scenario是: 这时的log backup有点乱, 可能某transaction是之前full backup
: 的, 某transaction 是之后这个full backup的. ---- (not sure about this. zenny
: 说说?)
:
: a
: back

z***y
发帖数: 7151
13
呵呵, 我们以后可以多做一些oracle 和 sql server 的比较。 但是不要讨论哪一种
好,这样经常会起争端。
1 (共1页)
进入Database版参与讨论
相关主题
MySQL Server is Open Source, even Backup extensions(ZZ)oracle问题
backup database sql server 2005HELP: How to restore SQL server 7 backup file to SQL server 2000?
coolbid, 问个问题Re: HELP: How to restore SQL server 7 backup file to SQL server 2000?
sql server 面试题 (8)MySQL database backup
differential backup里面的数据能提取吗?[紧急]求助。关于MSSQL Rollback问题
Any Suggestions on a SQL Server database maintenance planHigh Performance MySQL: Optimization, Backups ...
各位各位,江湖救急 -- 数据被删how to hot back mysql?
五月份免费SQL培训时间 (转载)Database Backup Question
相关话题的讨论汇总
话题: backup话题: log话题: diff话题: full1话题: failure