I am new to migration of database from one server to another.
1)So Any one tell me the articles/Guidance to do much better way of migration of database? and what are steps to be keep on eye/solve orphan user problem?
2)what is TRUSTWORTHY Database Property?
ALTER DATABASE AdventureWorks SET TRUSTWORTHY ON means????
The TRUSTWORTHY setting is mainly for use with CLR which enables a more access to lower level, and therefore less safe, functionality. Unless you know you need it, I'd leave this set to OFF on all databases.
As far as moving a database from one server to another, as long as we're talking about moving between the same versions and editions of SQL Server, orphaned users are really the only issue. If you're moving between versions, you only move up a version, not down when using attach or restore. If you're moving between editions, just be sure that nothing in the database is using Enterprise only functionality if it's a Standard server you're moving to.
For orphaned users, as for so much else in SQL Server, look to the Books Online. They've got a good article on it right here.
answered Feb 07, 2013 at 01:42 PM
Grant Fritchey ♦♦