February 1, 2011 at 4:20 pm
I am responsible for SQL Servers running various versions. A few are SQL 2008, most are SQL 2005, and there are some SQL 2000 SP4 instances as well.
On my workstation, I have Management Studio 2008 R2 installed. Is MS2008R2 compatable with all admin functions for all backend versions back to SQL 2000? Or are there certain functions for which I should log on to the servers (which have the admin tools for their respective versions)?
February 1, 2011 at 4:26 pm
DTS and SSIS are the biggest problems that stand out that you'll need multiple environments to deal with. There's emulators you can run to get into DTS from 2k5, but I would recommend being able to RDC to a box with just that installed.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 7, 2011 at 10:44 am
dan-572483 (2/1/2011)
Is MS2008R2 compatable with all admin functions for all backend versions back to SQL 2000? Or are there certain functions for which I should log on to the servers (which have the admin tools for their respective versions)?
There are certain upgrades that were made to SQL 2k5 and 2k8 that are not backward-compatible with SQL 2000. I can't remember them off the top of my head, though. On the other hand, almost anything you could do to SQL 2000 in EM or QA, you should be able to do via SSMS.
The exceptions being what Craig has already mentioned. DTS package maintenance and manipulation needs a plug-in, etc.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply