Hello,
we are taking three kind of backup for our production database .
Production:
Full backups : once a week
Incremental backups: once a week
Archive log backups : hourly basis
Now I want use the production full backup and refresh/restore in my lower (Test Database) environment .My understanding is if we use full backup to restore lower environment. Lower environment database will be dropped first then it will restored with production backup meaning all the schema, data will be replaced with production copy. Please confirm if my understanding is correct.
Here is the problem There are few schema which are there in lower environment but not in production So if restore happens I will loose these schema and data from lower environment. Please correct me if I am wrong.
question:
is there a way I can restore only single schema from my production database to lower environment?
How do I check if my lower environment has required space to restore the backup from production?
I have few business users who has access to test schema will they loose access to schema if restore happens?
***Moderator action (Timo): moved from to ***