To remove clustered SQL instance, you can launch the SQL installation Wizard, Select Maintance and then "Remove node from a SQL Server failover cluster." Start on the passive...

Which version of SQL and which patch?

This sounds similar to my issue (which is posted in this section but has had no responses yet) where we added...

Reinstalling can be tricky. Try deleting the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server,

then delete the C:\Program Files\Microsoft SQL Server and C:\Program Files(x86)\Microsoft SQL Server(if you're 64-bit) folders, then reboot again.

Here is a summary of what is on this exam: http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-432&locale=en-us#tab2

You will need working knowledge of each area described here. If you have not worked in each of these...

Thanks Sean! select * from sys.master_files is a better way to get a list of all active data & log files.

For each Database in SSMS run

sp_helpdb <database name>

or

USE <database name>

SELECT * FROM sys.database_files

This will help you build a list of all data & log files that ARE attached.

If...

Yes it would. Just make sure to do the Clustered installation of SQL. If you do a non-clustered installation - even on a clustered OS - you'll...

In this case all applications will support the same edition/version/patch level. No conflicting instance-level settings are needed and Transparent Data Encryption will not be used. I'm...

Network issues can make clusters inaccessible, prevent failover, or trigger failovers than shouldn't happen, but they shouln't cuase the cluster instance or SQL server to completely shut down.

Separate databases can have different database options set. Recoverability is a BIG advantage partularly in development. If one developer hoses what he's doing and wants to revert...

Lesson learned: If you are doing massive changes to a large database that you'll want to reverse, use a full backup, not a snapshot.

http://support.microsoft.com/kb/2002606

Dan

I'm curious why a search query would have so many criteria. Usually a search query will be by a primary key or other unique identifier, or by 1-3 columns...

deleted - misread context of question.

When I came onto this job and looked at the SSMS Security node for the instances & DBs I was now reposonsible for, I saw long lists of logins I...

I've also thought of creating one proc that takes the database name as the parameter. Asking them to type something like

exec sp_manualbackup 'databasename'

would not be so bad...