May 5, 2010 at 7:45 am
I am an application developer/Tester for this new application that requires multiple iteration of data conversion testing from an old version to a new. Every time the data is converted to a new version data structure, I would need to restore the database to the baseline. Though I am a DBO, I do not have a permission to restore, so I would have to work with DBA. My issue is since it is development environment and takes 1-3 days to get the resorted database. I would like to do it myself the data restore. I asked permission to do that, DBA said this would be Server level permission, so he cannot give me. I understand his concern, at the same time it is productivity issue in my side. I would want to do it in a matter of minutes. The process it takes about 10 minutes.
I have DBO access and I do have the baseline database in my workstation where I wanted to restore to – what would be other option I have to restore the database? Probably using scripts?
May 5, 2010 at 8:24 am
You have a permission issue to over come before you can do anything. DBO is simply a schema and does not grant you the permission to restore a database. If this is a productivity issue I would escalate up the chain. I would think your managers would be concered about it taking three days to get a restore. That still may not result in the DBA releasing the permission but it may result in the DBA reponding to the restore request sooner. Either way with out the permission you wil not be able to restore.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply