TSQL for result DB name, Size and Recovery model

Question

Post reply

TSQL for result DB name, Size and Recovery model

anzz

SSCertifiable

Points: 5503
More actions
July 11, 2012 at 10:17 am

#258821

T sql for which display result DB name, Size and Recovery model

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Here's a starting point for you

Select *

From sys.databases

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

You keep asking the same question. There are two system views that will help you: sys.databases and sys.master_files. Look up these views in Books Online and figure out how to query them to get the info you require.

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 3

This type of code has already been posted on many sites using various methods, even this one. Try the search feature on this site and a search engine. If you don't get results, let us know what search terms you're using and we'll see if we can't tweak your search.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Lynn Pettis (7/11/2012)
You keep asking the same question. There are two system views that will help you: sys.databases and sys.master_files. Look up these views in Books Online and figure out how to query them to get the info you require.

Haha - this time it is a bit different.

@Danzz

Combine the results from this query with last nights and you will have a fair head start on what you seek

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

SQLRNNR (7/11/2012)
Lynn Pettis (7/11/2012)
You keep asking the same question. There are two system views that will help you: sys.databases and sys.master_files. Look up these views in Books Online and figure out how to query them to get the info you require.
Haha - this time it is a bit different.
@Danzz
Combine the results from this query with last nights and you will have a fair head start on what you seek

Not by much, still need the same tables from what I can see.