Thank you learnt something.

If you know SQL Server and have experience go for the certs,how much time do have to prepare anywhere?

I have faced this problem before.I had application using sytem dsn and changed connection to a file dsn and the error no longer appeared.In some cases restarting could temporarily...

Nice question on basics.Thank you.

Thank you,just wanted to hear from your experience to be a bit confident.

Nice one,thank you for the point.

Restarting your DNS will resolve the issue.

Depending on the work schedule doing every day idea(if it is possible) is not a bad idea,I would recommend weekly test restores.

Ok,thank you.

I have rephrased the post.

A simple one for me thank you very much.

Interesting question really learnt something,thank you.

True,appreciate your comments was not aware of the tempdb fact.Thank you so much.

Thank you all guys.

Very easy question,thank you for the point.