can you post the DML you use for this delete ?

If it is a single delete statement that just performs like a table scan to do its stuff, that may...

So you see you would be better off using dbmail !

(better in sql2005 and nomore need for oa-stuff !!)

Quit simple:

Just add a default data file location and off you go !

You will need to restart your sqlinstance after you activate C2 !

USE [master]

GO

Declare @DataPath NVarchar(2000)

Declare @LogPath NVarchar(2000)

Declare @DataPathOLD...

imo the device activation error you see in the errorlog file, aren't related to your backup job.

What has happend to your G-drive ?? :crazy:

(G:\SQL2KData\...)

IMO having a higher checkpoint frequency will minimize its impact to the system.

It takes a checkpoint because it has a high update load (worktables, ... ??)

maybe (re) moving the...

Run the same script again in one month.

If that results in '%_obsolete_obsolete' tables, that would mean it hasn't been used for a month, so maybe good candidate for cleanup.

use enterprise manager, double click the job, (i.e. rightclick job, properties)

Alter the jobowner.

For backup jobs, we prefer using sa as jobowner to avoid all issues with windows accounts. (a...

Keep in mind :

(from BOL)

The recovery interval option does not affect the time it takes to undo long-running transactions. For example, if a long-running transaction takes two hours to perform...

Maybe you can use this:

dbcc checkdb (yourdb) WITH ALL_ERRORMSGS, DATA_PURITY

BOL says

DATA_PURITY

Causes DBCC CHECKDB to check the database for column values that are not valid or out-of-range. For example, DBCC...

You restruct queries on using over a certain governer cost.

But that setting goes for _all_ queries !

EXEC sys.sp_configure N'query governor cost limit', N'300'

RECONFIGURE WITH OVERRIDE

or you can shut down parallelism...

And then there is SOx :blink: ...

Nowadays we implement a service account per service. The corresponding passwords are guid-like strings, so only usable for install using an INI file.

We...

And probably you would be better off by first renaming your tobe obsolete tables, and removing them only a couple of months later

EXEC ('if 0 = (SELECT count(*) as rowCnt...

... san vendor install technician knowledge ...

Altough most SAN vendors nowadays have their own white papers for hosting databases on their san system, many technicians just don't have a clue...

- be carefull with sysindexes, because it may have an estimate count.

- adapt your script:

e.g. like this

EXEC ('if 0 = (SELECT count(*) as rowCnt from ['+@schema+'].['+@tableName +']) drop table...

Brad M. McGehee (6/26/2008)

---

When I am in a "work" environment, I call myself a DBA. If I am in a "non-work" environment, I call myself a "computer geek." When I...