CU4 for SP3 is out now.

What makes this CU very interesting is that "lock pages in memory" is now available in Standard Edition (X64)!

.

http://support.microsoft.com/kb/970279/en-us

its build number: 9.00.4226

Mani (6/23/2009)

---

Thank you..

one more question..Do you take the Tape backups of Differential and log backup files too? Is that necessary.

Because currently we are taking the Tape Backups after the full...

a3b2c1r46 (6/23/2009)

---

Its probably worth noting that I first noticed this problem shortly after I moved this DB to a new server. I shrunk the TL before I moved it and...

- The "inserted" and "deleted" (table) objects are only available in the trigger itself.

- The A in the code is the table alias for table F_articlewhere, meaning in that query...

Indeed, perform full db maintenance

start with:

DBCC CHECKDB (0) WITH ALL_ERRORMSGS, DATA_PURITY;

go

print '' ;

print '*********************************'

print '**'

print '** If DBCC CheckDB returned DATA_PURITY errors, you must view http://support.microsoft.com/kb/923247 !!! and repair...

did you update your statistics ?

- sp_updatestats

- dbcc updateusage (0) with count_rows

Just a little alternative to the above replies.

Maybe you can just create the backups on a local drive, in the last step of your local backup job, robocopy the .bak...

can you post the results of:

(sqlserver version info)

Select @@version

In the SSC article Mani Singh posted in the first the scripts are very visible to me.

There are two things with this/

1) the trigger supposes it will be fired after completen an update for single @cbmarq. If you update a table out of that "regular" oltp...

doing that with any clr proc will be at least 95% overhead !!

e.g.

create trigger trIU_mytable

as

begin

insert into myaudit_table

select 'I' as operation, *

from inserted

union all

select 'U' as operation

, *

from deleted

end

Doing...

Great article Gail.

I'll add it to my forum signature :w00t:

mick miller (6/19/2009)

---

Johan wrote:

: What happens if you execute that statement separately ?

: (is the error persistent ?)

When I run the query directly on the server, then I don't...

First of all thank you for posting these mishaps and the work around.

We didn't encounter these problems when upgrading from sp2 cu2 to SP3 on our 2-node sql-cluster (multiple instances)....

I haven't encountered that kind of errormessage yet.

BOL nor KB contain an exact ref.

What happens if you execute that statement separately ?

(is the error persistent ?)

Sorry for the alte response, I lost track of this thread :blush:

- In what way does your SRVDW(dom\sadb) differ from your other servers ?

- Are these databases in a lower...