Is there a way to have this scheduled , maybe automatically schedule these data copies on a daily or weekly basis ?
@BezKomentare2 жыл бұрын
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
@BezKomentare2 жыл бұрын
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;
Пікірлер: 4
Is there a way to have this scheduled , maybe automatically schedule these data copies on a daily or weekly basis ?
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
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;
will this copy all data in the database?