October 13, 2009 at 9:32 am
I have to downgrade a sql server 2005 cluster from Enterprise to Standard Edition. My plan was to script out logins, detach the db's, remove sql server. Install sql server and build sql server cluster. Then the ?, should I add the logins back first or attach the db's first. All the logins are windows based, but one of them owns 2 of the database I will be attaching.
October 13, 2009 at 11:21 am
You can attach the database first and run the script for the logins to recreate them.
Thanks,
\\K
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
October 13, 2009 at 11:33 am
To second the advice given:
Reattach the database first and then add the logins. I have encountered less problems that way.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply