Help gathering SQL info from all servers - noobie alert :)

I'm a domain admin, not a SQL guy. Unfortunately I have been tasked with
finding all SQL servers in the company and coming up with a migration plan
to a single SQL cluster.
The issue at hand is that I'm hoping not to try to reinvent the wheel... is
there any script (vb, js, osql, something), that will query a list of known
SQL servers and output the database names and sizes to a text/csv file?
If it could go one step further and give me other info like usernames and
such that would be great too!
Thanks for any help you can give!
Aaron
Do a scan for anything listening on port 1433 and you should find all of
your SQL Servers. You will have to factor out anything that is nothing more
than local MSDE due to some application install.
Once you have the server names, you can connect to them with a trusted
connection (proxies your domain admin authority). The list of databases can
be found by using "select * from master.dbo.sysdatabases". The list of
users can be found by using "select * from master.dbo.sysxlogins".
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"livin" <livin@.@.cox.net> wrote in message
news:rDxuf.676$B93.22@.fed1read07...
> I'm a domain admin, not a SQL guy. Unfortunately I have been tasked with
> finding all SQL servers in the company and coming up with a migration plan
> to a single SQL cluster.
> The issue at hand is that I'm hoping not to try to reinvent the wheel...
> is there any script (vb, js, osql, something), that will query a list of
> known SQL servers and output the database names and sizes to a text/csv
> file?
> If it could go one step further and give me other info like usernames and
> such that would be great too!
> Thanks for any help you can give!
> Aaron
>
>
|||Hi
Look at SQLRecon on http://www.sqlsecurity.com/DesktopDe...aspx?tabid=26,
you will need the rights to access these servers to audit the database
details you may want to look at
http://www.sqlservercentral.com/scri...?scriptid=1589
John
"livin" <livin@.@.cox.net> wrote in message
news:rDxuf.676$B93.22@.fed1read07...
> I'm a domain admin, not a SQL guy. Unfortunately I have been tasked with
> finding all SQL servers in the company and coming up with a migration plan
> to a single SQL cluster.
> The issue at hand is that I'm hoping not to try to reinvent the wheel...
> is there any script (vb, js, osql, something), that will query a list of
> known SQL servers and output the database names and sizes to a text/csv
> file?
> If it could go one step further and give me other info like usernames and
> such that would be great too!
> Thanks for any help you can give!
> Aaron
>
>
|||Hi living,
just for fun I wrote a Application for you to gather this information
for all servers / all databases which put this information into an XML
file which can be easily used in Excel or some other program. If you
(or any other guy) is Interested in just drop me a mail, i=B4ll send it
to you, later on after finishing the building of my new portal
www.sqlserver2005.de I will put it up there. It uses the new SQL.SMO
and the .net 2.0 to collect this information.
HTH, Jens Suessmeyer.
|||You guys rock!
Thanks for helping out a noobie... I DL'd all the stuff and will have fun
with it this week!
Jens... sending you an email now.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1136325248.839414.309600@.g49g2000cwa.googlegr oups.com...
Hi living,
just for fun I wrote a Application for you to gather this information
for all servers / all databases which put this information into an XML
file which can be easily used in Excel or some other program. If you
(or any other guy) is Interested in just drop me a mail, ill send it
to you, later on after finishing the building of my new portal
www.sqlserver2005.de I will put it up there. It uses the new SQL.SMO
and the .net 2.0 to collect this information.
HTH, Jens Suessmeyer.

HELP With THIS MESSAGE

This is what we are getting on the server but I cannot seem to find anything anywhere and i am not real strong in SQL...I am a server guy that is tasked with finding the issue!

Scott H
Weasel101

Event Type: Error
Event Source: MSSQLServer
Event Category: Server
Event ID: 17052
Date: 3/12/2002
Time: 2:45:06 PM
User: ********** (Changed for privacy...sorry)
Computer: MYCOMPUTER (Changed for privacy...sorry)
Description:
Error: 823, Severity: 24, State: 1
I/O error (bad page ID) detected during read of BUF pointer = 0x1431e6c0, page ptr = 0x498f6000, pageid = (0x1:0x403), dbid = 4, status = 0x801, file = f:\MSSQL7\DATA\msdbdata.mdf.
Data:
0000: 37 03 00 00 18 00 00 00 7......
0008: 08 00 00 00 4e 00 54 00 ...N.T.
0010: 30 00 30 00 33 00 32 00 0.0.3.2.
0018: 4b 00 00 00 05 00 00 00 K......
0020: 6d 00 73 00 64 00 62 00 m.s.d.b.
0028: 00 00 ..Do you know if this happened during a restore ?|||There looks to be a Technet article on this problem:

BUG: Error Message 823 or Retail Assert Encountered During Restore of SQL Server Log Backup (Q281809) (http://support.microsoft.com/default.aspx?scid=kb;EN-US;q281809)|||CAUSE
SQL Server may allow the log to be backed up when non-logged operations have taken place.

WORKAROUND
To workaround this problem either:

Avoid the use of non-logged operations.

-or-

Ensure that any process performing non-logged operations complete and secure a complete database backup