Replace SQl 2005 Ent edition with 2005 Standard edition

Last Post 12 Aug 2009 06:31 AM by timcronin. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
timcronin
New Member
New Member

--
11 Aug 2009 12:57 PM
I have a sql 2005 Enterprise Edition which has to be converted to Standard edition on a production boc. I was looking for the best approach.

1st Idea- Script out all logins and SQl Server Jobs
De-attach all db's
Uninstall sql 2005 ent edition
Install SQL 2005 std edition
Attach all db's
Script in logins and jobs

2nd idea Script out all logins and SQl Server Jobs
De-attach all db's
Uninstall sql 2005 ent edition
Install SQL 2005 std edition
Restore master and msdb (if possible)

There is one SSIS package/job which runs on this server.

Any pro's/cons with these ideas?
Thanks
timcronin
New Member
New Member

--
12 Aug 2009 06:31 AM
I am guessing I should attach the db's and then add the logins?
You are not authorized to post a reply.

Acceptable Use Policy