一些查询 [英] Some queries
问题描述
我对Azure SQL数据库很陌生.而且我有一些疑问
I am very new to Azure SQL database and I have some query
1.在Azure DB中运行sp_who2时有所不同.来自不同服务器的一些后台进程:
1. it's something different when running sp_who2 in Azure DB. There are some background process from different server :
DmvCollector b&b ; nbsp; b ; nbsp; b ; nbsp; b ;
BackupService b nbsp; bsp nbsp; bsp nbsp; bsp
NodeAgent b b b nbsp; bsp nbsp; bsp nbsp; bsp
指标下载器 bsp nbsp; bsp nbsp; bsp nbsp; bsp
指标下载器 bsp nbsp; bsp nbsp; bsp nbsp; bsp
VaService b nbsp; bsp nbsp; bsp nbsp; bsp
TdService
它们是什么?
DmvCollector
BackupService
NodeAgent
MetricsDownloader
MetricsDownloader
VaService
TdService
what are they ?
2.可以选择特定的完整数据库备份进行还原吗?还是只是时间点恢复?
2. Can choose specific full database backup to restore ? or just point-in-time recovery ?
3.时间点恢复可以恢复到相同的数据库名称吗?
3. Can point-in-time recovery to the same db name ?
4.如果删除数据库,恢复过程如何?
4. what's the procedure to restore if the DB is deleted ?
5.如何为主动式地理复制收取许可证?什么是RPO?我知道它在异步模式的后端始终处于打开状态.
5. how to charge license for Active Geo-replication ? and what's the RPO? I know it's always-on in backend with async mode.
6.如何检测地理还原和
6. How to detect failover for geo-restore and Active Geo-replication?
7.我可以更改Azure数据库的时区吗?当我输入select getdate()时,它是不同的时区.我想知道何时将db从前提迁移到azure db.时间会错了!!!
7. Can I change the timezone for the azure database ? when I type select getdate() it's different timezone. I am wondering when migrate the db from premise to azure db. the time will get all wrong!!!
推荐答案
Hello,
Azure SQL运行一些内部流程以提供自动调整,自动备份等功能.
数据库还原始终会创建一个新数据库,但结果是,您可以在Azure SQL数据库上进行时间点还原.
https://azure.microsoft.com/en-us/blog/azure-sql-database-point-in-time-restore/
Database restores always create a new database as result but yes you have available point-in-time restores on Azure SQL Database.
https://azure.microsoft.com/en-us/blog/azure-sql-database-point-in-time-restore/
长期备份 .
Automated backups made by Azure services create full, differential and transaction
log backups. Those automated backups are retained for up to 35 days. If you want backups retained for more than 35 days, then you can configure
long term backups.
以下是还原已删除数据库的过程.
Below is the procedure to restore a deleted database.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-recovery-using-backups#deleted-database-restore
有关RPO的信息可以在以下文章中找到:
Information about RPO can be found on the following article:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-business-continuity#sql-database-features-that-you-can-use-to-provide-business-continuity
您需要检查活动日志以跟踪故障转移.
You need to examine Activity Log to keep track of failovers.
所有的Azure服务都使用UTC时区,但是下面的文章向您展示了如何处理该时间:
All azure services use UTC time zone, but below article shows you how to deal with that:
https://blogs.msdn.microsoft.com/azuresqldbsupport/2016/07/27/lesson-learned-4-modifying-the-default-time-zone-for-your-local-time-zone/
希望这会有所帮助.
Hope this helps.
问候
Regards,
Alberto Morillo
SQLCoffee.com
Alberto Morillo
SQLCoffee.com
这篇关于一些查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!