High level..

I pasted into SSMS and hit F5, it worked. Now let me look at the code and see if I can apply it to what I am doing. ...

Just keeping you helpful folks in the loop.

I was just thinking. I could use Dynamic SQL that creates a stored procedure that contains the backup command as a static...

Still plugging away at this. I know it is close but still can't get it to work.

If anyone has any other ideas I am all ears.. well all ears...

Little closer maybe but still the following error:

\\clients.advance.local\Data\WIP\test80.bak

EXEC (BACKUP DATABASE AuditTest2 TO DISK = '\\clients.advance.local\Data\WIP\test80.bak') AT adasdb

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'BACKUP'.

Msg 102,...

Well Close my no cigar. I am trying to parameter the destination server name and I can not get that to execute.

Here is what I am playing with:

DECLARE @BackupStatement...

🙂 Thank you so much.... My acid test worked so now I just need to modify my actual code. Here is what I did for testing, just manually typed it...

I have not tried this. Trying now 🙂

The job idea might work. Running the proc from the server with the DB to be backed up wont.

Thanks for the idea.

200+ columns? Look if you have a developer, in particular a lead; that does not know that this is an issue I am not sure there is much the community...

LOL I saw your post just now. So I figured it out on my own. Wish I had seen this, I did not goto page two until now. These 100...

This is what happens when you get tired. I was calling sp_ExecuteSQL

This is a file system function:

Changed to

adasdb.master..Xp_cmdshell

All is right in the universe.

Alas I tried that as well already, did not like that at all! LOL.. Again the really courious thing is it was working and now it is not. AND...

Quotes did not work. Bouncing the service did not work. Bouncing the server did not work.

I am on the 4th floor... I wonder if a bounce out the window will...

Right 🙂 It is a dev server so I bounced it; well opened a ticket to bounce let you guys know if that helped.

No, it worked before... but you know what!! I may as well try that. If it works I am throwing my work station across the room 😉