<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
All Db's infromation of instance
All Db's infromation of instance
Rate Topic
Display Mode
Topic Options
Author
Message
Tara-1044200
Tara-1044200
Posted Tuesday, November 13, 2012 9:47 AM
SSC Eights!
Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:37 PM
Points: 983,
Visits: 2,924
Does any one know a simple query that would give following information about all databases on an insance?
1. Database Name
2. Created Date
3. Modified date (if any changes made to any table in a particular db)
4. Size of the DB Name.
5. Database last read (
NOTE: i do weekly backups so wanted to make sure i am not pulling backup date instead of read date
)
Post #1384171
Asa_M
Asa_M
Posted Wednesday, November 14, 2012 12:45 AM
Forum Newbie
Group: General Forum Members
Last Login: Yesterday @ 12:37 PM
Points: 5,
Visits: 62
Hi, try the following query, hope it helps.
SELECT * FROM sys.databases
Regards,
Asa_M
Post #1384425
hs24
hs24
Posted Wednesday, November 14, 2012 5:11 AM
Right there with Babe
Group: General Forum Members
Last Login: Yesterday @ 7:29 AM
Points: 765,
Visits: 328
For a starter in relation to DB_Name, Create date and size the following will work. This looks only at the 1st data file and ignores the log files but can be amended if you have multiple data files by adding the additional file to the in statements
SELECT sd.name, sd.create_date, (sm.size*8)/1024 AS SizeMB from sys.databases sd JOIN
sys.master_files sm on sd.database_id = sm.database_id where sm.file_id IN (1)
Post #1384550
Asa_M
Asa_M
Posted Wednesday, November 14, 2012 7:37 AM
Forum Newbie
Group: General Forum Members
Last Login: Yesterday @ 12:37 PM
Points: 5,
Visits: 62
hs24, the SizeMB is the size for what exatly? the whole database?
Post #1384626
hs24
hs24
Posted Wednesday, November 14, 2012 8:48 AM
Right there with Babe
Group: General Forum Members
Last Login: Yesterday @ 7:29 AM
Points: 765,
Visits: 328
The sizeMB is for the size of the data file
Post #1384691
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
