Размер видео: 1280 X 720853 X 480640 X 360
Показать панель управления
Автовоспроизведение
Автоповтор
If you need to find out what is the pricing tier of the source database you can use the TSQL statement:SELECT d.name, slo.* FROM sys.databases d JOIN sys.database_service_objectives slo ON d.database_id = slo.database_id;
To find out the source database size:SELECT (SUM(reserved_page_count) * 8192) / 1024 / 1024 / 1024.0 AS DbSizeInGBFROM sys.dm_db_partition_stats
Is there a way to have this scheduled , maybe automatically schedule these data copies on a daily or weekly basis ?
will this copy all data in the database?
If you need to find out what is the pricing tier of the source database you can use the TSQL statement:
SELECT d.name,
slo.*
FROM sys.databases d
JOIN sys.database_service_objectives slo
ON d.database_id = slo.database_id;
To find out the source database size:
SELECT (SUM(reserved_page_count) * 8192) / 1024 / 1024 / 1024.0 AS DbSizeInGB
FROM sys.dm_db_partition_stats
Is there a way to have this scheduled , maybe automatically schedule these data copies on a daily or weekly basis ?
will this copy all data in the database?