Jonathon Williams (4/18/2012)

---

Server has 16 GB of RAM of which 6.64 is used...

It's a 64-bit Windows Server 2008 R2 Enterprise with Intel Xeon CPU X6550 @ 2.00 GHZ (4...

how many rows are expected?

how you performed an execution plan?

where are you running this?

can you supply the actaul query?

deleted due to embarrisment.

Just my 2c worth but i wouldnt go to HP mode. You are mirroring 'pressumably' for...

you couldnt backup to ftp site (i dont think) but you could couple it with something like xcopy, roboxopy or filezilla.

When you say ftp, is that remote? If the...

in that case make it out to:

Mickey Mouse

@

The Fair'n'Appriciative Co LTD.

Ok the commented and slightly modded backup script is below:

SET NOCOUNT ON

-- declaration of temp table

DECLARE @databases_table TABLE(server VARCHAR(50),dbname VARCHAR(50))

-- populate a temp table with db's to be backed up

INSERT...

What I meant by 'SP' is 'stored procedure'. I asked you if you could build one.

From the very limited info you have given the SP creation code would be:

USE...

Do you know how to build the SP? if not, upload the code.

As far as scheduling is concerned, you can use windows scheduler and sqlcmd.

If your not sure, upload the...

Did you have any luck with this?

I tried the following:

DECLARE @xmlFile XML

SET @xmlFile = (SELECT * FROM OPENROWSET(BULK 'c:\myxml.xml', SINGLE_CLOB) AS xmldata)

SELECT ref.value('currentdb[1]', 'INT') AS DatabaseID

FROM @xmlFile.nodes('EVENT_INSTANCE/TextData/deadlock-list/deadlock victim/process list/*')...

If the source db is 2k then very likely bids 2k8 might have issues. Did you try 2k5?

The other thing to consider is user data types (if thos existed in...

Natalie,

Have you tried deleting your tasks and cm's and just trying something simple like a copy to csv?

I have had issues in the past where cm's for flat file destinations...

Aidan,

John has given good advice. Reading the thread, it strikes me that this might be a new role or task for you. Can you tell us what you need...

I posted two scripts. The second to sp_GetFullFiles. So you need to have deployed that to your target servers (if you intend to run it as is).

As far as using...

We use this to shrink large databases accross many environments via LS's. Donnt have time to customise it to your scenario, but with a bit of tweaking it does what...