Microsoft KB Archive/69876

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

= 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 ”, where 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.