Set the tempdb data and log files to the size they need to be.  That'll be the size they've grown to, so don't shrink them.  Don't create extra log files...

I agree with RandomEvent.  Do you have any control over the query?  The two things I would consider are as follows:
(1) Don't stage in #CathodicProtection unless doing so provides...

Looks like the execution policy at the remote computer is too restrictive for your script to be run.  Did you follow the link given in the error message?

John

Yes, fair enough.  But nobody's going to do your homework for you, especially if you don't provide any evidence that you've at least put some effort in.

You've posted...

Copied and pasted straight from your coursework assignment!  Show us what you've tried so far, and we'll guide you further.

John

As Gail said, there's no easy way of doing that.  I would recommend that you restore your backup alongside the existing destination database and then do some ETL to get...

I'm not sure what you actually mean, although I suspect that the answer is going to be no.  Please will you describe your exact scenario, and we'll see whether we...

Use Ola Hallengren's solution.  Thousands already do, so it's very robust.

John

I'm pleased that works for you - but you're right, it's much better to know how to use it properly.  It's less typing, for a start!  I think the issue...

Have you tried specifying a parameter size for Parameter 1?  Also, what system variable are you passing to that parameter?

John

Run sp_spaceused on A, then run it on B.  Use SSIS, linked servers or similar if you want to have it run centrally from a single point.

John

sp_spaceused should get you what you're looking for.

John

Exactly the same way you would on any other server.  What "size" are you looking for - physical size of the log or data file(s), amount of data in those...