Hi okbangas, thanks for reply..

Total 6 Table to be create with as below format, so each table have 500 columns.

Column1 - Timestamps ( for storing date value)

column2 - Meter_Id1 (...

Dear All,

I have question about Mirroring performance between principal and mirror database.

OS - windows 2008 R2 Enterprise edition.

SQL - SQL SERVER 2008 R2 Standard Edition.

Initial stage database size 20 GB...

That's the generic mirror error. Usually its communications based. I would suggest and check the below

1.Firewall

2. port being used already

3. named pipes not enabled

4. remote connections not...

Hi Mr. Perry,

I have tested with automatic failover with witness server.

Application currently connected to principal server,

For the testing purpose, I stop the SQL services in principal server, then automatically mirror...

Thanks for all reply..

Mr. Perry said - Only if you use the FailOverPartner option within the connection string.

One last question, For the automatic failover option if I am using witness...

Thanks Perry Whittle for reply

It is working fine manual failover after run this command as below,

In principal server

ALTER DATABASE MyDB SET PARTNER FAILOVER. after that mirror server become a...

Thanks for reply...

I have doubt in this case, alreday application connect to Principal server IP, after change mirror server to principal server by using

Alter database <databasename> set partner off

Restore database...

I have successfully configure database mirroring setup without witness server and manual fail-over, high-protection mode.

Check for mirroring endpoints with the following query:

select name,type_desc,state_desc,port,is_dynamic_port,

ip_address from sys.tcp_endpoints

nametype_descstate_descportis_dynamic_portip_address

Dedicated Admin ConnectionTSQLSTARTED01NULL

TSQL Default TCPTSQLSTARTED01NULL

MirroringDATABASE_MIRRORINGSTARTED50220NULL

Please...

What is the OS of the desktops trying to access Report Manager?

Desktop PC operating system having windos XP and windows 7.

But there is exsiting Application server and multiple ASP...

Thanks for reply....

This is SSRS 2008.

SQLRNNR (10/18/2011)

---

SSRS 2008 or SSRS 2005?

Are you accessing the report server from the reportserver itself or from the database server when you get that runtime error?

What is the OS of...

Hi,

Thanks to all for reply..

At the moment I can suggest following:

• Crosscheck Public & Private network.

• Crosscheck ports availability

• Crosscheck the firewall

Resolved issues, due to domain firewall is not disbaled...

after that I have...

Please tell me & suggestion, what could be issue when move to node 1 to node 2 then automatically disconnect SQL SERVER connection in client side but server itself SQL...

Perry Whittle (10/14/2011)

---

not sure what you mean by this?

In first Node 1 - Install New SQL SERVER...