OK, I'm sure it has been asked before, but I can't find the answer.
Our developers do not have the ability to restore disk backups to the development server. This is intended behaviour, and a form of data security (the data has to be "depersonalised" before they can work on it).
And I know that this is "bending" reporting services a bit, but I want to give our developers the ability to restore their own databases from the live backups.
The way I intend to do this is to give them a RS report, from which they can select their database, see who is "in" it, and get an "OK" to do the restore - no problems there. I even have a "status" button so that they can see if it is being restored or is off line before they start.
Great
Now I fall over
I have a stored proc that will read the restore locations from a table providing the DB name is passed in and then do a lite speed restore, change DB to simple, de-orphan the DB and loads of other good stuff.
Works great to
How can I create a button on the report for the developer to "click" to call this SP? Other than navigating to another report that will just show the status of their restore, I can't really think of a way.
Anyone?
Our developers do not have the ability to restore disk backups to the development server. This is intended behaviour, and a form of data security (the data has to be "depersonalised" before they can work on it).
And I know that this is "bending" reporting services a bit, but I want to give our developers the ability to restore their own databases from the live backups.
The way I intend to do this is to give them a RS report, from which they can select their database, see who is "in" it, and get an "OK" to do the restore - no problems there. I even have a "status" button so that they can see if it is being restored or is off line before they start.
Great
Now I fall over
I have a stored proc that will read the restore locations from a table providing the DB name is passed in and then do a lite speed restore, change DB to simple, de-orphan the DB and loads of other good stuff.
Works great to
How can I create a button on the report for the developer to "click" to call this SP? Other than navigating to another report that will just show the status of their restore, I can't really think of a way.
Anyone?