Hi,

Today while working on query analyzer found very interesting thing about security.

My sql server A is running with service account which is same as service account of server B and having all access.and I am login with my credential to server A, I am not having any access to server B.When I open a query analyzer with my credential.and run a restore command like this.

Restore database B_DB_on_A from disk =’\\B_servername\Drive$\backupfilelocation\backupfile.bkp’

Here the backup file is at located on  B server. where I don't have access but as sql server A running with service account this command works and it will restore the database.

This works well if you want to restore things production to development.

HTH.

Vinay