Make a full backup every hour. Is it crazy? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Make a full backup every hour. Is it crazy?

Make a full backup every hour. Is it crazy?# Database - 数据库

S*k2008-11-12 08:11

1 楼

Someone of my company scheduled a full backup each hour and diff backup
every 5 minutes using a sql 2005 third party VDI backup software, and
claimed it’s a recommended backup topology.
The backup files are on the same physical disk with the database data files
and grow 17 GB each day.
Any idea who may recommend such topology?

w*r2008-11-12 08:11

2 楼

that must be storage vendor , EMC recommend such idiocy ?

files

【在 S***k 的大作中提到】

: Someone of my company scheduled a full backup each hour and diff backup
: every 5 minutes using a sql 2005 third party VDI backup software, and
: claimed it’s a recommended backup topology.
: The backup files are on the same physical disk with the database data files
: and grow 17 GB each day.
: Any idea who may recommend such topology?

S*k2008-11-12 08:11

3 楼

oh, yeah.
It is EMC. I just got the response from the person who set up the backup
plan.
I have asked to stop the stupid backups immediately.

w*r2008-11-12 08:11

4 楼

ha.. I guess they are really desperate these days with storage technology is
leaping forward while it is among those few ones without any filesystem
technology sitting on top of their storage racks. Other plays like Sun and
HP
all have the edge of selling products with persuasive file system based
technologies.

【在 S***k 的大作中提到】

: oh, yeah.
: It is EMC. I just got the response from the person who set up the backup
: plan.
: I have asked to stop the stupid backups immediately.

S*k2008-11-12 08:11

5 楼

TMMD.
That guy stopped 5 minutes diff backup and keep the full backup each hour.
The backup files grow 6G in last 5 hours.

c*d2008-11-12 08:11

6 楼

haha

【在 S***k 的大作中提到】

: TMMD.
: That guy stopped 5 minutes diff backup and keep the full backup each hour.
: The backup files grow 6G in last 5 hours.

w*r2008-11-12 08:11

7 楼

the fact that the file locates on the same disk as the data file just made a
hell of day for me!!

files

【在 S***k 的大作中提到】

S*k2008-11-12 08:11

8 楼

That guy said: “The backup being on the same disk should cause no problems.
All the virtual drives in this server are part of a RAID 50, 6 disk raid
array.”
What is RAID 50?

w*r2008-11-12 08:11

9 楼

Raid 5 + Raid 0

problems.

【在 S***k 的大作中提到】

: That guy said: “The backup being on the same disk should cause no problems.
: All the virtual drives in this server are part of a RAID 50, 6 disk raid
: array.”
: What is RAID 50?

w*r2008-11-12 08:11

10 楼

since it is virtual disk resides on the big disk array, I guess there is
merit
to have the bkup lives on the same virtual drive. Still what a waste to have
hourly backup. Hourly incremental+daily maybe more appropriate , maybe dual
active(duplication) is better for your database if transaction volume is
high
24/7

problems.

【在 S***k 的大作中提到】

: That guy said: “The backup being on the same disk should cause no problems.
: All the virtual drives in this server are part of a RAID 50, 6 disk raid
: array.”
: What is RAID 50?

j*n2008-11-12 08:11

11 楼

For this kind of situation, why not consider Mirroring / Snapshot ?

S*k2008-11-12 08:11

12 楼

The database is running on sql 2005 standard version.
Snapshot is not supported on the standard edition.
Mirroring has limited operating mode on the standard edition and it more
like an additional witness server.

a*t2008-11-12 08:11

13 楼

just backup the log files every 5 mins if recovery is critical
and do nightly full backup, or twice a day at most.
and other than performance point of view, safty rules would against storing
the backup at the same location of the production data.

S*k2008-11-12 08:11

14 楼

Stupid people are doing in the stupid ways.I said what I can say. And I did
what I can do. They just don't want the correct way.
The backup is still running. The folder to hold the backup files almost 35G
and grows 1.2G per hour, the available disk space is 60G.

w*r2008-11-12 08:11

15 楼

disable the logon for the backup account, only open during night time for a
couple hours. . AS a DBa, it is either DBA's way or high way.. hahah...

did
35G

【在 S***k 的大作中提到】

: Stupid people are doing in the stupid ways.I said what I can say. And I did
: what I can do. They just don't want the correct way.
: The backup is still running. The folder to hold the backup files almost 35G
: and grows 1.2G per hour, the available disk space is 60G.

w*r2008-11-12 08:11

16 楼

also, create a data file covers 90% of the disk space and tell the backup
folks to find somewhere else to store their data, backup living on the same
disk array / partition/virtual disk as data file is definitely NO.

did
35G

【在 S***k 的大作中提到】

j*n2008-11-12 08:11

17 楼

damn, that's really sucks. have you guys experienced it takes too much time
for creating/rebuilding indexes?

【在 S***k 的大作中提到】

: The database is running on sql 2005 standard version.
: Snapshot is not supported on the standard edition.
: Mirroring has limited operating mode on the standard edition and it more
: like an additional witness server.

S*k2008-11-12 08:11

18 楼

rebuild index 非常慢。