thanks guys

the fix was to pass in Updatedt=Updatedt

the trigger itself was provided as required by the DBA

wacky but that's the way they do things so I wans't going to go...

thanks

instead, I added one more variable @procid and used @rowcount and @err which were already @DECLAREd

then SET @ERR=@ERROR,@ROWCOUNT=@@ROWCOUNT,@PROCID=@@PROCID

and used the variables instead

forgot to request updates

a user would only lose at most a day of updates
the restore plan would be - take down the web site (there is a HubSpot piece which would stay...

a real DBA took over - and she / he moved the backups to some cloud space

it's a fantasy football web application - the vast majority of the hundreds of active users are free
there are  no more than a score of paid members

update - my client worked with a DBA (the real deal) at Liquid Web, the hosting company
- bought 50 G's on a cloud - and backed up the...

thanks
how does backing up a log file free up space?  doesn't it simply use up more?
please, I'm new at this
concrete steps
sample SQl
do DIFF backups still...

they ran! I just needed to start the Job Agent service
as I said, s DBA but not by choice

thanks folks

the job history says there are not scheduled - but the Schedules within each job says they are

the server is fairly new - and it looked like the...

the job history shows - nothing
the T-SQL runs fine in a Query window
the job is  Enabled - but doesn't run

log on to the server using an account Machine Name \Administrator
open Management Studio
go to Job Agents at the bottom
Add New Job
add Step with T-SQL to do...

I don't get any error message (unless I don't know where to look) - I just see every morning that no backup has run

SET @Filename ='C:\bak\PowerHouse_' + CONVERT(VARCHAR(8),GetDate(),112) + '.bak'