I have used CLR to import XML data that comes back from a web post

I am wondering now if there is a better alternative way to do this in sql...

Hi

I tried doing it in SSIS but I had some issues

Firstly its not a proper web service so the web service task would fail as there is no WSDL

I thought...

Thanks

worked

To a network share using redgate sql backup

Over 2 terabytes

You can backup the log to a file while a full backup is running but you cant run a truncate or shrink.

Backing up the log to a file doesnt shrink...

Hi

I just tried to run Backup Log DBNAME with truncate_only and DBCC shrinkfile on a test database in FULL recovery mode while a full backup is running but it wouldnt...

Half resolved

This works except that I cant get it to work using extended stored procedure of sqlbackup.

EXEC master.dbo.xp_cmdshell 'net use N: \\LON-NAS01\Backups\SQLFullBackups /USER:username password'

master..sqlbackup N'-SQL "RESTORE FILELISTONLY FROM DISK =...

Im connecting to a server using a sql server account. Can this account be given access to a folder on another domain?

Thanks I figured that out eventually.

Lots to learn....Lots to learn

cheers

HI

Yea Ive got it working this morning and couldnt replicate what was going wrong last night

A nights sleep seemed to helped as its all working fine now

go figure

cheers

Chris

Hi Crispin

You are absolutely right! My apologies. I wrote this last night very fatigued and stressed getting home from work. I knew as soon as I posted it what a...

Thanks guys this advice is all great!

How do you work out the ratio of reads per row returned?

Perfect

Thanks

no probs

grasshopper learning to jump