I got it,it was easy for me.

Learned something here,the difference between a compressed database and a compressed back-up thank you.Just to add something,from my experience back-up compression depends on the database structure and contents.

george sibbald (2/18/2014)

---

paul.knibbs (2/18/2014)

---

Hold on a second here. As far as I'm aware, the model database is used to create tempdb--so if model is actually read-only, wouldn't that then make...

Nice information,but how do you define "newly created"?

Enjoyed the question of the day very fun indeed.

Please sorry I have wrongly worded issue,i need script that restart a service on remote computer.

A good question ,learned something.

Nice and easy one for me ,thank you.

Plus one,thanx.

The problem is the database is an recovery state(and it is inaccessible).

I need to be corrected here,I have databases that will be recovering but as soon as I restart they regain online state after spending after hours in recovering.I have been...

Thank you for the quetsion easy one for me.

Good one,by elimination method worked as well.

I got it,a little tricky though.

Nice and easy for me thank you.