After setting up a second network adapter in the process of adding some SSL'd sites to ISS, my instance of SQL Server 2005 is no longer accessible - including through SQL Server Management Studio. ...
I have 2 boxes. One is dell (4x146GB 15k 3.5'' SAS in raid 10). this is primary sql server (runs only mssql). dell has 8gb ram and mssql is running fine. Dell has windows 2008 R2 x64 second is hp ...
So I'm really not a DBA, I'm an app dev. I had to install my asp.net mvc3 app on my client's(a large company) IIS6 + Win2k3 machine, with absolutely no help from their sysadmins. The final problem ...
I'm using Win 2K3 R2 + SP2 with SQL 2K8 R2 installed. I'm trying to set SQL Agent History to keep 1 week of logs. So here's what I do: After I connect, I right click SQL Server Agent and select ...