use backup media.

backup the db using that media (so you always backup to the same physical directory)

in the last step of your backup-job, you can move the backupfiles to the...

you could use a script that launches them all using xp_cmdshell with isql.

e.g. exec xp_cmdshell 'isqlw -E -S myserver -d msdb -i "c:\sqlserver$\scripts\onlyonce_1.sql" -o "c:\sqlserver$\scripts\OutPut_onlyonce_1.sql" '

If you are only moving to new hardware.

Install SQLServer exactly as your original server (drives, directorylocations, ..), bring it to the same servicepack as original.

Now comes the rocket-science: 

can you post the query ? and the ddl of the used object(s) in sqlserver.

noeld is probably right.

If you have a sql2k sp3a and a multiprocessor-box, you need a hotfix for the count(*). That could also be a reason.

replace the distinct by a group by and you'll gain more !

SELECT  Prcs_dte

INTO #A_Dates

FROM tbl_Tracking group by Prcs_dte

SELECT  Prcs_dte

INTO #B_Dates

FROM Acct_Stats group by Prcs_dte

Still I'd suggest you'd profile it and...

sorry for visio

You can reverse-engineer it from within visio.

New DatabaseModelDiagram

database\reverse engineer

(you may have to create and odbc-dsn to get connected)

use " NOT EXISTS " ... that's the way to do it !

speed it up by adding an index on table/view Acct_Stats column prcs_dte.

just m 2ct:

select  book, count(distinct page) as pagecount

from tl10_land

group by book

this can be don without unavailability :

check dbcc shrinkfile / shrinkdb in BOL

take special notice at Shrinking the Transaction Log.

You know SQLmail and clustering is not supported.

That's why I use smtp-mail on my clustered sqlservers.

SQLmail works, but only for a while, then it...

If it stays in rollback-state to long according to your expectation, you may need to stop and start your sqlserver-instance.

(I've had to do this frequently because some of my users...

Maybe you can get on the road with this :

(its a script I use to gather backup-job-info)

-- alzdba dd 08/01/2004

-- request Backup-job info

set nocount on

-- check BOL

select substring(case server...

I was thinking it should be something like that.

Did I overlook that documentation ?

Where/how did you...

I'm using alerts to perform these kind of task.

- Cmdshell stays closed.

- dba has control on jobs running on db-servers

- alertno-ranges support portability (DRP)

Test this...