Rebuilding SSRS: DEV from PROD

I want to rebuild my DEV SSRS (2005), and load reports, models, etc. from
PROD. But, I want to then apply the security I had in original DEV against
the restored folders.
Does anyone know how to SCRIPT SECURITY, and then reapply over existing
folders/objects?On Jan 8, 12:23 pm, mdgraves <mdgra...@.discussions.microsoft.com>
wrote:
> I want to rebuild my DEV SSRS (2005), and load reports, models, etc. from
> PROD. But, I want to then apply the security I had in original DEV against
> the restored folders.
> Does anyone know how to SCRIPT SECURITY, and then reapply over existing
> folders/objects?
This article might be helpful; however, note the disclaimer.
http://msdn2.microsoft.com/en-us/library/ms160854.aspx
Regards,
Enrique Martinez
Sr. Software Consultant

rebuild master question

Using SQL 2K
Say i have SQL 2K with SP3a and the latest security patch installed and now
my master goes corrupt but I have a recent master db backup someplace.
If i rebuild master using the rebuildm utility, do i have to install the
SP3a and the security patch again before i try to restore the master db or
should i just restore master next ? Just a lil confused as the restore
master article mentions to ensure that the SQL installation is at the same
version as the master backup before restoring..
btw, what does the rebuilm internally do ? Thanks
Fatima,
We would strongly advise that you reapply sp3a as well as the hotfixes.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

rebuild master question

Using SQL 2K
Say i have SQL 2K with SP3a and the latest security patch installed and now
my master goes corrupt but I have a recent master db backup someplace.
If i rebuild master using the rebuildm utility, do i have to install the
SP3a and the security patch again before i try to restore the master db or
should i just restore master next ? Just a lil confused as the restore
master article mentions to ensure that the SQL installation is at the same
version as the master backup before restoring..
btw, what does the rebuilm internally do ? ThanksFatima,
We would strongly advise that you reapply sp3a as well as the hotfixes.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

rebuild master question

Using SQL 2K
Say i have SQL 2K with SP3a and the latest security patch installed and now
my master goes corrupt but I have a recent master db backup someplace.
If i rebuild master using the rebuildm utility, do i have to install the
SP3a and the security patch again before i try to restore the master db or
should i just restore master next ? Just a lil confused as the restore
master article mentions to ensure that the SQL installation is at the same
version as the master backup before restoring..
btw, what does the rebuilm internally do ? ThanksFatima,
We would strongly advise that you reapply sp3a as well as the hotfixes.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.