Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

data device question

Status
Not open for further replies.
nyck

nyck

Technical User
Mar 10, 2004
447
GB
Hello,

is there a way under isql to find out how much space is left on a data device?

if i run sp_helpdevice it will tell me how large but it would be nice to know how much space is left available!

cheers

nick
 
Sort by date Sort by votes
try this:

sp_freedevice

it lists device, size, used and free

-DNG
 
Upvote 0 Downvote
I tried restoring to a database that i created FOR LOAD but i get an error like device is not a legal virtual block number. can anyone help me sort this problem out?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PBLMP
  • Locked
  • Question
Powerbuilder 11.2 - TreeView Datawindow
Replies
0
Views
116
PBLMP
PBLMP
mark1110
  • Locked
  • Question
Update Question
Replies
1
Views
52
PDreyer
PDreyer
kingz2000
  • Locked
  • Question
Data in TableA not in TableB
Replies
1
Views
77
PDreyer
PDreyer
sux2b
  • Locked
  • Question
How to find the version of the database
Replies
1
Views
89
mrdenny
mrdenny
iyethelen
  • Locked
  • Question
Help, i can't restore database ( suspect ), and get this message below
Replies
0
Views
62
iyethelen
iyethelen

Part and Inventory Search

Sponsor

Back
Top