Hi Ramesh,

First off, thanks very much for investigating! And you are exactly right, specifying

SET TEXTSIZE { number }

within the Step of the Agent Job solves the problem....

The simple answer to your questions is to run:

RESTORE DATABASE db_name WITH RECOVERY

However, it is likely that you have other problems occurring here (if the mirroring worked correctly, then the...

Wikipedia seems to agree with this summary too:

http://en.wikipedia.org/wiki/Oracle_database

So far I have installed SP3 on 2 (non-critical) instances, each running on different Windows 2003 servers. One was Standard Edition, the other Enterprise Edition. Both were previously at SP2...

Well, ladies never suffer flatulence, at least in public.... OK, point taken.

And a nice bit of management-speak too. Obviously everyone modifies their behaviour depending on circumstance, surroundings, situation, etc....

I am surprised at several posts here which admit that they "dress-up" when they, or their boss, deem the situation requires it. This to me is disingenuous. Your presentation, including...

Interesting, thanks for the info.

For the moment, I think I will carry on using the datatype sysname. This does mean I cannot use the GUI of SSMS, but I rarely...

Then I suggest you do not use tempdb to start...

I would hazard a guess that the transactions have been committed on the Mirror, but not yet committed on the Principal. When the Principal database is brought back online, I...

blandry (12/19/2008)

---

(First - a correction for AndyD... Holly is NOT the female computer in Red Dwarf - that is Hilly. Holly is the actor Norman Lovett, a male...

HOLLY from Red Dwarf (TV series). A computer so stupid, but with a human face, that you just had to love it/her.

Not sure if this would work, but could you define a temporary table with the text columns having datatype varchar, as opposed to nvarchar??? Or CAST/CONVERT the column on...

I agree that the transaction log cannot be backed-up unless a full database backup already exists. At least, this is the case for 2005. Is it different in 2008 (this...

NTLM authentication will work fine, as long as neither server is configured to disallow this "lower" level of authentication (lower when compared to kerberos).

If you are in a AD domain,...

Thanks for the editorial Tony, it's not everyday that I get to read phrases such as "surreptitiously hide irrational dogma" :hehe:

Andy