April 9, 2011 at 7:51 am
Hello All,
I have to upgrade my clients SQL server 2000 and SQL server 2005 to SQL server 2008 R2
please tell me, should i do this with upgrade wizard or i must uninstall SQL server 2000 and SQL server 2005 and then install SQL server 2008 ?
I want to retrieve all my login and SQL jobs ? how is this possible
April 9, 2011 at 8:01 am
You could use the upgrade assistant. I would look into doing a side by side upgrade so as to have a fallback option.
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
April 9, 2011 at 8:04 am
thanks for the post
upgrade assistance may help us in choosing right configuration for upgrade.
but i m more concerned with my current databases, logins and sql jobs.
if i upgrade to SQL server 2008 R2 , do i get all the stuff or i may have to reconfigure those things again ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply