![checking disk archive checking disk archive](https://www.eightforums.com/data/attachments/24/24771-9e020f0f148f33161a45aa35242bd7ca.jpg)
Write one of the archive copies to disk volumes and write the otherĪrchive copies to removable media volumes. If you are making multiple archive copies, you can The archiver treats files archived to disk volumes in the same way asįiles archived to volumes in a library. Host, that host must have at least one QFS or SAM-QFS file system However, if disk archive copies are written to a different The file system to which the archive files are written can be any System where the archive copies are written is the server. System where the source files reside is the client and the host
![checking disk archive checking disk archive](https://kinsta.com/wp-content/uploads/2017/07/drop-tables-phpmyadmin-768x318.jpg)
Host systems, the systems act as a client and a server. When disk archiving is configured for two With disk archiving, the archive medium is online disks in a fileĭisk archiving can be implemented so that the files from one file systemĪre archived to another file system on the same host or to anotherįile system on a different host. Stay tuned.Archiving is the process of copying a file from online disk to archive
![checking disk archive checking disk archive](https://i.ytimg.com/vi/0klRDJIqq68/maxresdefault.jpg)
I hope it is useful and practical for you. As you can see in the definition of the stored procedure, the default value for is NULL which means, according to the logic of it, that general information will be displayed, that is the report in the graphic, otherwise, giving the letter of a partition will allow you to get detail information for every database file located in that disk partition. The report could receive the letter of the partition disk as a parameter, and also it can be omitted. Group by vs.volume_mount_point,vs.total_bytes, vs.logical_volume_name, vs.total_bytes ,vs.file_system_type, vs.available_bytes desc end else begin SELECT vs.volume_mount_point,Ĭast( SUM( f. WHERE f.database_id < 32767 and + ':\' order by f. *WITH ENCRYPTION*/ AS begin if is not null )ĭB_NAME(f.database_id) database_name, f.type_desc,
#Checking disk archive code
Now it is high time to show the code to get that report containing that information:ĬREATE PROC. Furthermore, disk space capacity and disk space available in gigabytes and percentage can also seen (disk_capacity_gb, disk_space_available_gb, disk_space_available_pct). Thus, we will be able to know whether or not the disk space is being using properly. In the report we can appreciate that all partition disks are displayed, each of them has information related to the space used in total (db_file_size_on_disk_db) by all database files (data & log) and it also includes the equivalent in percentage (db_file_size_on_disk_pct). For example, we may have the need to check how much disk space is occupied by database files exclusively so that a wise decision can be made to ensure we are using disk space properly of a database server. We may need to see a report something like this. When it comes to monitoring and managing disk space we may have some graphic tools to help us complete these tasks rapidly, nevertheless, not everybody can afford to pay the tools, and most of them do not give some details we may need on the spur of the moment.