Post reply

SQL Server 2000 to 2005 restore/securities problem

  • July 2, 2007 at 7:53 am

    #372677

    Hello all,

    I am having security problems restoring backups across environments. When I restore a backup from environment A(sqlserver-2000) to B(sqlserver-2005) the securities change. I have to delete schemas and users, then re-add users and assign them schemas. The users in both environments are same, but after restore to the target database (sqlserver-2005), schemas of the users within the target are thereby changed to a schema of the same name as the user. Is there a way to restore a SQL Server 2k database into SQL Server 2005 and control the formation of the users? I apologize for the naïve nature of this question.

    Thanks,

    David

  • July 2, 2007 at 12:56 pm

    #716640

    David,

    See my reply in this thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=359&messageid=372463#bm377484

    It includes a script for changing default schema to dbo.  This is the only way I've found to deal with the automatic naming of schema in a database.

    Greg

    Greg

  • July 2, 2007 at 2:07 pm

    #716650

    Thanks Greg that worked!

    Thanks for the reply.

    David

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply