What is the best method for moving databases from one
server onto a clustered setup? Obviously you can use
backup/restore or detach/reattach. What I really need to
know is what steps you have to do after this. There must
be security problems with the new database. ie how do you
ensure security etc is carried over to cluster servers
from original server esp with login info living in master
database of original server.

Moving data to SQL Cluster or a Stand Alone SQL server, is the same process.
Data Transformation Services will also work. A SQL Cluster is still a SQL
box.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Bill" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks - I know that.
But I have been told that there are a number of security
issues that you have to deal with after you have moved the
databases over. Are you aware of these.

Depending on how your move a database, you may or may not get the SQL logins
to come across. The Books online are excellent in regards to moving/copying
a database.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Bill" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Look at the stored procedure sp_change_users_login on BOL. That is the
procedure to fix mismatched User-Login combinations.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Bill" <anonymous (AT) discussions (DOT) microsoft.com> wrote