I create a copy of a production database (for reporting purposes) by using the backup and restore commands. The copy is on a seperate server. (replication wont work in my case)
The reporting server allows more read-only access then the production server.
I do a full backup and restore, and of course all permissions/security settings come with all the data.
How can I do a backup and restore of only data without altering permissions on the reporting server?
As more of my users want to run reports, I give them access on the reporting server but not the production server, and of course it gets wiped out every night when the backup-restore runs.
Using SQL Server 8.0 and 9.0.
View Complete Post