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.