November 28, 2007 at 2:41 pm
Hi,
Actually,we are planning to upgrade our SS 7.0 to 2005 (side by side).The thing is we are having databases closely to 80 in count and all of them are really VLDB.I did studied all the documentation in SQL books online regarding upgradation.I am planning to go for Backup/Restore.Can you help me what is the best way of upgradation.
Thanks in advance
Regards,
CS
November 28, 2007 at 3:55 pm
Try this artilce...
Have you run the Upgrade Advisor against your current setup?
Also if all your db's are VLDB's then you we need a lot of physical disk space to use the backup restore method. And if you use the deatach/atach method, ensure you keep the orginal database files so you have a fall back if it does not go according to plan.
Gethyn Elliswww.gethynellis.com
November 28, 2007 at 10:30 pm
Going form SQL 7 to SQL 2k5 is a big jump mostly becuase a lot of the system components change. Also be sure to have a solid backout plan due to the way 2k5 handles jobs, and some of the packages if you are moving those as well(i assume you are). If you can try to test this in a development environment a good 3 or 4 times(many as you can) before doing this in production. The one area i cant emphasize enough is your back-out plan mainly due to the unexpected when making such a drastic jump.(altho its for the better...i am sure 🙂 ) Good luck
DHeath
November 29, 2007 at 6:31 am
Hi,
I am sorry,I didn't make my question clear.Actually we are migrating from SS 7.0 to 2005.I just wanna make sure that whether all the datbase logins will be remained same as before or not! If not what are things i need to take care and How about server login?I guess we have to create server logins but is there any way to migrate server logins
Thanks in advance
Regards,
Sireesh Chigurupati
November 29, 2007 at 11:12 am
I have used the follwing link to help with login transfers;
http://support.microsoft.com/kb/246133
Its helped me more then once. You may also want to look on the scripts pages inside of SSC. I am sure there are some others that you can possibly use.
-D-
DHeath
November 29, 2007 at 5:31 pm
I'm not sure if you can do a side-by-side installation. I would script out all logins using the sp_help_revlogin tool and also save DTS packages out on the file system, and make sure you back up and practice restoring master and msdb on to a fresh 7.0 system so you can restore back. I highly suggest running the Upgrade Advisor and studying the results. The help file that comes with UA is very good too in documenting differences.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply