Correct and you'll need to use it if you don't have automatic failover :).

However you should not need to break the mirror when you do that if you can recover...

DECLARE @T1 AS TABLE (Col1 INT, Col2 INT, Col3 VARCHAR(5))

DECLARE @T2 AS TABLE (Col1 INT, Col2 INT, Col3 VARCHAR(5))

INSERT INTO @T1

SELECT 1,2,'Test1' UNION ALL

SELECT 2,3,'Test2' UNION ALL

SELECT 3,4,'Test3' UNION ALL

SELECT...

htt (3/24/2009)

---

Question: in case of a failover occurs, can I force the failover on mirror server, break the mirror, make sure principal is offline then rename and change IP of...

Urg yaa I found out by chance; I was helping a developer performace tune an application.

I was like I can execute the query in sub-second speeds. But the Access...

Hi,

Your transaction log is 1GB doesn't mean that you are throughput is 1GB on transactions. So I don't think you have to worry about it that...

Excellent article; I was thinking of doing something similar.

As I been tasked with automating releases; so once developer submit it it gets executed in proper server/database automatically and sends...

Training users and limiting their access to pre-designed views that give them required information I take is out of the question?

Another option you might want to consider it get them...

I would implement a trace on your server that tracks all blocking relating issues; this can help you narrow down which queries are causing the issue. You can do...

Thanks I'll remember that ... 🙂 I know nothing, that is why I spend my time on forms so I can learn .. yaa take care :D.

Mohit.

History Clean up Task is used to clean up history from MSDB. Each time you take a backup a record record can be made to the MSDB history tables...

Sorry ...

But if you can connect to it using SSMS and you database is not very big maybe exporting a copy for your safety might be an option..

Mohit.

aa nuts :P. Aaa well thought I should mention it, I have fixed lots of developers over the past year for this small mistake. :hehe:

A side comment from what these fine gentlemen have said .. do you need NVARCHAR? I find some developers don't know the difference between VARCHAR and NVARCHAR and just...

I am sorry you are still having this issue. I found another artilce where they resolved the issue using the DNS settings as mentioned in the KB article I...

Another thing to note is if you are running in "High safety mode" then the information gets written to the T-Log on Mirrored, confirmed, then committed on principal. So...