Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Network backup Access via Query Analyzer

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

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.