I shoot but never kills. What am I ??

Question

I've many holes but I will never leak
Not comfortable? Just give me a tweak

Though often together most of the day
Come bedtime we'll go our separate ways

Life without me might be kind of a drag
'Cause when I'm not around things tend to sag

Doing my job, your reliable mate
This is a "hold-up" you'll appreciate

What am I?

Answer 1

It's a Camera or a water gun or an air gun etc.,.

Answer 2

camera can shoot but never kills