z***y
发帖数: 7151 | 1 今天4点多被pager叫起来， 一个做reporting 的数据库， snapshot database was
not available.
There's job to create snapshot every 6 hours. However, the last two jobs are
all failed. The fail message are different:
1. The database is not online and cannot do snapshot
2. The database exists and cannot be dropped,
大家猜想一下， 这都可能是什么问题引起的？
The job first to check if there's database called *_snapshot, if there was,
then dropped it.
then it will create new snapshot database. | s**********o
发帖数: 14359 | 2 为什么要DROP DATABASE?是不是有一个SNAPSHOT DATABASE？
原则上TABLE都应该在REPORTDB里 |
|
