Use this tool (VBS script) to generate the list:
http://exchangepedia.com/2005/09/how-to-export-all-email-addresses-from-a-domain.html
To get a list of users that have forwarding configured perform this Custom AD search
(&(mailNickname=*)(altRecipient=*))
If SQL Server thinks there is something wrong with a database - it will mark it as suspect to prevent any further damage, and refuse to mount it.
There are a couple of things we can to get things up and running again.
1. Instruct the server to mount the DB. This is done using the Query Analyser and feeding instructions to the server.
2. Check the database for corruption.
3. Put the system into production once we are sure the DB is 100%.
Refer to this for step 1: http://www.sqlservercentral.com/articles/Administration/unmarksuspect/137/
The reset command is:
sp_resetstatus @dbname = "db_name")
* replace db_name with the database name.
For the DBCC checks: http://msdn.microsoft.com/en-us/library/aa258278%28v=sql.80%29.aspx
The check command is:
DBCC CHECKDB('db_name')
* replace db_name with the database name.
Windows 7 has very strict permissions on who can modify or delete files in the System32 and other critical folders. Do the following on particular files you need to replace to allow access:
Take ownership and grant permissions on the file
cd C:\Windows\System32\
TAKEOWN /F spoolsv.exe
ICACLS spoolsv.exe /grant administrators:F
You can now rename and replace the files as required.
