I am facing the same issue. DBCC checkdb is eating all the tempdb space, so tried to capture what exactly it is writing. No luck at all.

You need a service account. If its just a test and no one is using the server, change the SQL service account to your domain id and give it a...

Check whether your mail profile is enabled for SQL Agent.

Right click SQL Server Agent > Properties > Alert System - check enable mail profile - Mail System (Database Mail) -...

We do it during weekends and it usually takes 20 hrs. No additional storage for restore.

But the point is for 1TB database it is taking 20GB tempdb and DBCC is...

CASE

WHEN DESCRLONG LIKE '%The incident occurred time%' THEN substring(DESCRLONG,PATINDEX('%The incident occurred time:%',DESCRLONG)+28,8)

ELSE

CAST(DESCRLONG AS VARCHAR(1000))

END AS '<<Casedescription>>'

Thanks, make sure the account (windows authentication) that is running SQL service is valid.

For the error check this: http://www.sqlservercentral.com/Forums/Topic123137-110-1.aspx

What error message are you getting when you start the service?

May be there are trailing spaces in the end of database name. Worth checking !! "DBA" is not same as "DBA " ..

It doesn't give mount point information. May be you could use this: http://www.sqlservercentral.com/scripts/90392/

We have both OLAP and OLTP systems. Config looks around same for us too except double the memory and double the logical processes.

We set it to 1 in general...

SCOM Admin deploys the management pack. We sit with them, go through the rules and monitors and agree whether they need to disabled or not. By default, most of the...

In a cluster you do a normal SQL install on one node and do a "Add node" on all the other respective nodes. So, you have 2 nodes, 2 SQL...