November 20, 2008 at 7:20 am
Hi! I have been reading articles of sqlservercentral.com for months.
Now it's time to come with my first question in the forums.
My problem is the following.
In my work environment we have a production database and a test database as well.
Often we use to restore the production database on the test database so we can go on testing applications without interfering with the production environment. The problem is that after the restore has completed, we find that the tables have lost their correct schema, resulting in DBO instead.
Can you help me?
I cannot understand if the solution is in the options we use while making the backup or in the options we use while doing the restore instead.
Meybe you need more infos about configured schema and users?
Thanks in advance.
AC
November 20, 2008 at 1:45 pm
Could you describe how you had backup of your database?
November 21, 2008 at 1:40 am
Thank you for your answer.
Unfortunately I don't know how they exactly do the backup&restore, it's an activity in charge of the system administrator and it's not that easy to talk with him/them.
I see your question but, so far, I just wanted to find out in advance a list of possible suggestions, or maybe a checklist of possible reasons.
I have checked that in the production db - which we make backup&restore on the test db - we have a "notdbo" schema and a "notdbo" user which is owner of the "notdbo" schema, so far similar to the standard configuration of the "dbo" schema. I still cannot find out how they're going to lose the schema information of the tables during the backup&restore.
Thank you for helping.
AC
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply