Category Archives: databases_files

Understanding the Different States of SQL Database

Posted on August 27, 2016 by Andrew Jackson

Overview There are multiple numbers states of a SQL Database. These states determine the current status or mode of database in SQL server. At once, the database is only in one state, which may be any one of the following: … Continue reading →

Posted in Backup and Restore, databases_files, SQL | Leave a comment

Use FILEPROPERTY to find free space in all the database

Posted on August 26, 2015 by Prashanth Jayaram

The use of SpaceUsed property of the FILEPROPERTY function gives how much space is used also we can derive lot of other attributes of it such as free space and percentage of free space. For other versions of SQL you … Continue reading →