INF: How to Find Available Space on a SQL Server Device
PSS ID Number: Q69876 Article last modified on 04-27-1995
4.20
OS/2
| The information in this article applies to: |
| - Microsoft SQL Server version 4.2 for OS/2 |
SUMMARY
In the Software/Data Library, there is a file named FREEDEV that contains the SQL script, FREEDEV.SQL. This script creates a stored procedure called sp_freedevice. When executed, this procedure will determine the sizes of all of the devices on the SQL Server, along with how much space is available on each device.
Download FREEDEV.EXE, a self-extracting file, from the Microsoft Software Library (MSL) on the following services:
- CompuServe GO MSL Search for FREEDEV.EXE Display results and download
- Microsoft Download Service (MSDL) Dial (206) 936-6735 to connect to MSDL Download FREEDEV.EXE
- Internet (anonymous FTP) ftp ftp.microsoft.com Change to the SOFTLIBdirectory Get FREEDEV.EXE
MORE INFORMATION
Once you have run the script to create the stored procedure, there are two ways you can use the procedure to find available storage. Executing the command “exec sp_freedevice” will list ALL of your SQL Server devices, their sizes, the amount of space used by each one, and the amount of available space on each one. If you would like this storage information for a specific device only, you can execute the command “exec sp_freedevice <device name>”, where <device name> is the name of the device you want the information for.
Additional reference words: 4.20 triggers rules stored procedures softlib KBCategory: kbother kbtshoot kbfile KBSubcategory: SSrvAdmin SSrvServer
=================================================================
Copyright Microsoft Corporation 1995.
