|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
db sizehow can i find out the allocated, file and transaction log size of a
databases without going to the properties page? thanx Hi,
You can do sp_helpdb <DB> to get the same information that is presented in the properties page. You can also do sp_spaceused in a database to find the data/index space allocated in the entire database and free size remaining. Shahryar rve***@rogers.com wrote: >how can i find out the allocated, file and transaction log size of a >databases without going to the properties page? >thanx > > > > -- Shahryar G. Hashemi | Sr. DBA Consultant InfoSpace, Inc. 601 108th Ave NE | Suite 1200 | Bellevue, WA 98004 USA Mobile +1 206.459.6203 | Office +1 425.201.8853 | Fax +1 425.201.6150 shas***@infospace.com | www.infospaceinc.com This e-mail and any attachments may contain confidential information that is legally privileged. The information is solely for the use of the intended recipient(s); any disclosure, copying, distribution, or other use of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender by return e-mail and delete this message. Thank you. Thanx Shahryar,
One more question. I have a lot of DBs on this server and i need to list the domain and the allocated file size. How can i do this? sorry for the stupid question, im not a db admin, just need to create a report. Thanx Show quote "Shahryar G. Hashemi" <shahryar.hash***@infospace.com> wrote in message news:u5rsdSd%23FHA.912@TK2MSFTNGP11.phx.gbl... > Hi, > > You can do sp_helpdb <DB> to get the same information that is presented in > the properties page. You can also do sp_spaceused in a database to find > the data/index space allocated in the entire database and free size > remaining. > > Shahryar > > rve***@rogers.com wrote: > >>how can i find out the allocated, file and transaction log size of a >>databases without going to the properties page? >>thanx >> >> > > > -- > Shahryar G. Hashemi | Sr. DBA Consultant InfoSpace, Inc. 601 108th Ave NE > | Suite 1200 | Bellevue, WA 98004 USA Mobile +1 206.459.6203 | Office > +1 425.201.8853 | Fax +1 425.201.6150 shas***@infospace.com | > www.infospaceinc.com > This e-mail and any attachments may contain confidential information that > is legally privileged. The information is solely for the use of the > intended recipient(s); any disclosure, copying, distribution, or other use > of this information is strictly prohibited. If you have received this > e-mail in error, please notify the sender by return e-mail and delete this > message. Thank you.  |
|||||||||||||||||||||||
Other interesting topics