This one was easy.. I got it right......:-)

good question to test the basics 🙂

Yes, you can connect to SQL Server 2008 R2 instance from SQL Server 2008 SP1 client.

Make sure you have opened firewall for settings fro SQL Server to be connected from...

tricky question 🙂

Today nly i was reading the below linked articles. I hope it will help you .

http://www.mssqltips.com/tip.asp?tip=2454

http://www.mssqltips.com/tip.asp?tip=1917

Is it a simple select query or do it contain joins?

how much data is there in the table from which you are trying to retrive 1000 rows?

Is "where" or "order...

Do you want to get notified when SQL Server agent goes down?

or

You want to know the steps/action to perform in order to restart this service?

There is no way, one data file will be shared by multiple databases.

You can alternately run 'sp_helpdb dbname' to check the current logical and physical file name/[ath of the...

Can you please share the error message?

To restore a database successfully, there should not be any other connection to that DB.

Now to answer your questions:-

Any options for the sql scripts that can force to restore and...

may be some one have revoked your access. please check with your administrator to check if your id still have access or not. 🙂

Since no backup is taken after changing the recovery model / after inserting records.. so no way you can recovery any data in this DB....

I believe something is missing in...

I also beileve, beetr take a fresh snaphot

If I am correct, your issue is as why this test database got backed up. Since you haven't cretaed any backup job/updated MP for this database.

To answer, just check all...

Hi, you...