June 17, 2008 at 3:10 pm
Hi All,
I have created new xyz database in one of our sql server 2005. Now I want to restore the YTR database from sql server 2000 server and I also wanted my SQL server 2000 logins/users and thier permissions remain same on YTR database.
Urgent help would be appreciable.
Regards,
Austin
June 17, 2008 at 7:29 pm
1) You will need to transfer logins between SQL 2000 and SQL 2005 (http://support.microsoft.com/kb/246133/). If the same logins already exist on SQL 2005 go to next step
2) Backup YTR database on SQL 2000 to the disk, move file to the disk on SQL 2005 and restore the database as you would usually restore a database from the file's backup
3) Run DBCC Checkdb and update statistics on the restored database
4) If the same logins already exist on SQL 2005 run stored procedure to map logins to the database users using sp_change_users_login stored procedure
All permissions should work.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply