Yes error 1420 and 1421 are known error messages.

Did you look at this:

http://support.microsoft.com/kb/329133

cheers

Doesn't have to be. Basically, the trick is to show queries different paths.

MichaelJasson (7/2/2009)

---

Thanks for your response SSCrazy and Gail.

The reason I want to do that is that my application is running very slow. I want to allocate more memory to sql...

check this out:http://support.microsoft.com/kb/918992

OR you...

Yes, ".mdf" is the data file and ".ldf" is the log file. Both are as important...

I really dint get this question or am...

rambilla4 (7/1/2009)

---

Hello-

We have configured Log shiiping in sql server 2005. Now, I want to change the roles between Primary and secondary. For this purpose:

1. I have to MUST failover to...

Glad, you found the solution.

But you never answered the questions that...

MarkusB (6/11/2009)

---

FreeHansje (6/11/2009)

---

'The only way to do this in SQL 2005 is by running a trace. '

I'm not sure, but I recall having read somewhere, that Profiler does not catch...

steveb (6/10/2009)

---

Krishna Potlakayala (6/8/2009)

---

Vani (6/5/2009)

---

There was a discussion in my company with one group holding the view that Database Mirroring could not be deployed in production in SQL Server 2005....

Wouldn't be a good idea. Is this...

Chinna (6/10/2009)

---

I am taking weekly full backup on Sunday, every day differential backup and every one Hour transactional backup, if sql server crashes on Friday 8:15 pm? Explain...

.ldf has never any data...

jayanth (6/9/2009)

---

The autogrow is turned off for this database. The index maintenance ran sucessfully today. But still not sure why it didn't complete yesterday.It filled the log yesterday and never...

jayanth (6/9/2009)

---

Hi,Thanks for the reply. The insert/update operations at that time was no different than any other day. The recovery model was not changed ,its always in full recovery model....