Vegard Hagen (11/19/2012)
I agree with SpaghettigDBA regarding disk config for tempdb: While it is nice to have a dedicated tempdb drive on large production servers, you don't need to split that up into separate drives for log and data.
Fair point but I've created 3 folders on the new D drive, SQLData, SQLLogs and SQlBAckups. TempDB is going on the same drive as the everything else. What else can I do?!
As for your "I didn't build this server" comment... well, this is a known problem: people building servers without proper consideration of their actual config and purpose. Contrary to what a lot of people seem to think, 600 GB of disk is not just 600 GB of disk.
You should see how the other servers are configured... lol not to mention the number of people who know the Domain Admin account password! ROFL.....
Well, if your server is not in a domain, you will probably need an equivalent local group on this server.
Can you please expand on this a little more? I don't funny understand the need for the group. Why not just user the local Administrator user account for the SQL Server SA?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn