March 18, 2011 at 3:42 am
Hi,
I need to find out or collect information. Is there any setup and configuration check list for SQL RC ?
1) How many user per SQL Server 2008 level and there password ?
2) How many user per SQL Instance 2008 and there password ?
3) SQL 2008 Database size, who is owner, data backup time and location, Size of disk ?
After i collect those information i want to create a report
4) How can i create a report of SQL Server 2008 setup and configuration ?
Thnx in adv.
Kahn
New DB
March 18, 2011 at 4:04 am
Do you want to know the Maximum Capacity Specifications for SQL Server or do you want to check it on your server ? If its Maximum Capacity Specifications for SQL Server you can find it here http://msdn.microsoft.com/en-us/library/ms143432.aspx
If you want to collect information for your server, you will have to query the system tables.
Users select name from sys.syslogins
Password -- It is not possible to retrieve the passwords.
Dbsize sp_helpdb
Diskspace exec master.dbo.xp_fixeddrives
Last Backup Date of Databases
SELECT B.name as Database_Name, ISNULL(STR(ABS(DATEDIFF(day, GetDate(),
MAX(Backup_finish_date)))), 'NEVER') as DaysSinceLastBackup,
ISNULL(Convert(char(10), MAX(backup_finish_date), 101), 'NEVER') as LastBackupDate
FROM master.dbo.sysdatabases B LEFT OUTER JOIN msdb.dbo.backupset A
ON A.database_name = B.name AND A.type = 'D' GROUP BY B.Name ORDER BY B.name
March 18, 2011 at 5:04 am
Hello,
thnx for your repaly, which is pretty usefull.
Can i retriev password also ? for all user in database level and server ?
thnx
March 18, 2011 at 5:26 am
Passwords are encrypted in SQL Server.
March 21, 2011 at 2:06 pm
But you will be still able to transfer passwords along with logins to different server though.
March 21, 2011 at 3:39 pm
google "sp_help_revlogin" - the 2005 version is compatible with 2008.
It will script out the logins and passwords (hashed) where they can be run on another server.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply