Server Configuration

mirror error message - failover
I have event errors set up to trigger e-mails. 1408 was supposed to designate a failover of a database mirror. It was working previously. Now I am on sp3 and it does not seem to work. All other mail is working correctly. Does anyone have any information on this ? ... 28 Jun 2010 16:11

Copy permissions security groups
Hi, Our sql server 2005 data permissions are set to windows security groups which exist in active directory. Now it’s time to move to new servers (windows 2008 and sql server 2008). I can restore the data but what about the groups. With another active directory do I have to set all the permissions to these... 28 Jun 2010 10:37

Losing connection
I do a lot of work in Management Studio connected to a SQL 2008 server from my workstation. Sometimes I lose connection after accessing fine all day. I am using Windows 7 and have the latest SQL Server service pack. The message I get is "A network-related or instance-specific error occurred while establish... 28 Jun 2010 18:24

Policies
Hello, We are testing the use of Policy management framework and thus my manager has entrusted me to collect some sample policy ideas which can be implemented across the SQLServer enterprise. This is apart from the default policies that MS has shipped. The idea is that each team memver develops a policy and ... 28 Jun 2010 18:24

Instalation error SQL 2000
installation error(SQL SERVER 2000) sent back to sqlstp sqlstp: 20:16:13 Begin Setup 20:16:13 8.00.194 20:16:13 Mode = Normal 20:16:13 ModeType = NORMAL 20:16:13 GetDefinitionEx returned: 0, Extended: 0x0 20:16:13 ValueFTS returned: 1 20:16:13 ValuePID returned: 0 20:16:13 ValueLic returned: 0 20:16:13 System... 27 Jun 2010 18:19

2008 R2 Reporting Services would not start
after i upgraded from SQL 2008 to R2, the reporting service no longer start and with error "Default appdomain failed to initialize". I tried to remove the reporting service and reinstalled and it didn't help. I even tried to remove entire R2 and reinstall that way, didn't work either. now, i'm clueless... pleas... 26 Jun 2010 15:14

database mirroring question
for database mirroring, can one mirror server to two principle servers? That means two mirrored servers mirror to one same mirroring server. Is that ok? Thanks. ... 25 Jun 2010 19:47

Replace no init backup with init backup?
I have created some databases no init from SQL Server 2005 maintenance plan. I want to do Init backups and override the backups I made in the past with no init. If I do through SQL Agent code, will this take care of the problem or some other way? ... 25 Jun 2010 18:41

Speed, subselect vs group by
I want to get a list of employees who were all paid on the last payDate in employeeLog before my query date(20100101). I've thought of 2 ways to do it, but I'm not sure which would be faster. I would think the one without the subselect would be faster, but the other way would give me a lot of group by's. selec... 27 Jun 2010 12:49

New Instance Installation Failure
I have a multiple instance SQL Serer 2005 server on Windows 2003 that is failing on the attempt of adding a new instance. It starts out by failing with OWC then fails MSXML6, SQL Server Database Services and finally Reporting Services. When reviewing the logs the owc log is below. Is there a way I can someho... 29 Jun 2010 08:33