Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jaybee from his castle
Yak Posting Veteran
64 Posts |
 Posted - 2006-05-02 : 05:49:46
|
| Hi all, and before I start many thanks to the previous suppliers of practical help in the first thread! Love ya all!Now, I've done the Backup/Security auditing, in the throes of perf auditing today, any of you guys know of a good script that I can run to give me a snapshot of their (well, now MY) databases/server config settings, listing trans log sizing/ usage, sizing of tempdb, whether the data and translog files are on separate disks, etc?Cheers,Jaybee. |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-05-02 : 10:44:41
|
| Give this a shot in terms of finding all of the database size/file locations:exec master.dbo.sp_MSforeachdb 'use ? select db_name(), * from sysfiles'Hope it helps,DaltonBlessings aren't so much a matter of "if they come" but "are you noticing them." |
 |
|
|
|
|
|
My Healthcheck, Part II