asked
Migration of Databases from one server to another!!!
HI experts, 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????
You don't need to mark your questions as community wiki. They're not. Also, when you get an answer that is helpful, please click on the thumbs up to vote for it. When you get an answer that answers your question, please click on the check box next to that question. You've asked a ton of questions here but you're not marking the answers at all.
Not sure what you mean. You have enough reputation to be able to vote up & down. I'm not talking about this question. I'm talking about the other 52 questions you've posted. Of the 52, only one has a marked answer. All but one of your questions has at least one answer (many have more than one). If those answers solved your problem, you should mark them as the answer by clicking once on the check box next to that answer.
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.][1] [1]:
http://msdn.microsoft.com/en-us/library/ms175475(v=sql.110).aspx
12 People are following this question.
