Knowing the size of a SQL Server database is one of the many DBA responsibilities that you can accomplish easily with the stored procedure sp_SDS. Not only will sp_SDS determine "SQL Database Space," but it can also be used to monitor database growth, alert a DBA on data or log file growth, execute a transaction log backup and even provide a detailed breakdown at the file level so a DBA can then shrink files with the most empty space.
This is cache of http://feeds.feedburner.com/~r/WhatisEnterpriseItTipsAndExpertAdvice/~3/289543019/0,289483,sid87_gci1313431,00.html. Cache is the snapshot of article that we took when we index feed.
To see original page click here.
We are not affiliated with the authors of this article and not responsible for its content.
To see original page click here.
We are not affiliated with the authors of this article and not responsible for its content.
Check SQL Server database and log file size with this stored procedure
 |  |
 |  |
 |  |
 |
BROWSE CATEGORIES
TOP SEARCH
RECENT SEARCH
RELATED VIDEO
