Prev: Best Practice - Converting ntext to nvarchar(max)
Next: SQL Server 2005 sp3 Query Execution Issue
From: Greg on 22 Apr 2010 15:01
All of my databases are currently in SQL Server 2005. Thus, I have SQL Server
2005 Management Studio installed on my machine to connect to my SQL Server
2005 instances. We now have a SQL Server 2008 instance setup and I want to
know if I connect to a SQL Server 2008 database via my current Management
Studio? Should I be upgrading to the 2008 version?

Also, is it possible to create Maintenace Packages to backup my SQL Server
2005 database from my SQL Server 2008 server? I want to start setting up new
Maintenance Plans on the 2008 box if that's possible?

Finally, I have SQL Server 2005 Express installed on my personal Notebook at
home so that I can work on my 2005 database at home when necessary. I'd like
to upgrade my SQL Server to 2008, but I still need to be able to use 2005.
Can I install SQL Server 2008 on my notebook with 2005 and run both instances
when necessary? I'm running Windows Vista Enterprise 64-Bit Edition.

Thanks.
--
Greg Setnes
cSharpWeb Developers
From: Jeroen Mostert on 22 Apr 2010 15:42
On 2010-04-22 21:01, Greg wrote:
> All of my databases are currently in SQL Server 2005. Thus, I have SQL Server
> 2005 Management Studio installed on my machine to connect to my SQL Server
> 2005 instances. We now have a SQL Server 2008 instance setup and I want to
> know if I connect to a SQL Server 2008 database via my current Management
> Studio?

You can't.

> Should I be upgrading to the 2008 version?

Yes. The 2008 Management Studio is fully compatible with 2005.

> Also, is it possible to create Maintenace Packages to backup my SQL Server
> 2005 database from my SQL Server 2008 server? I want to start setting up new
> Maintenance Plans on the 2008 box if that's possible?
>
This should work. If the 10.0 Native Client is installed on a 2005 server,
it should even work the other way around (a 2005 server issuing backup
commands to a 2008 server), though I haven't tested either scenario.

> Finally, I have SQL Server 2005 Express installed on my personal Notebook at
> home so that I can work on my 2005 database at home when necessary. I'd like
> to upgrade my SQL Server to 2008, but I still need to be able to use 2005.
> Can I install SQL Server 2008 on my notebook with 2005 and run both instances
> when necessary? I'm running Windows Vista Enterprise 64-Bit Edition.
>
This is no problem at all. You just have to make sure that either you do not
run the servers concurrently, or you give them unique ports and/or instance
names, just as you would need to do if you had two instances with the same
version.

--
J.


From: Erland Sommarskog on 22 Apr 2010 17:42
Jeroen Mostert (jmostert(a)xs4all.nl) writes:
> On 2010-04-22 21:01, Greg wrote:
>> All of my databases are currently in SQL Server 2005. Thus, I have SQL
>> Server 2005 Management Studio installed on my machine to connect to my
>> SQL Server 2005 instances. We now have a SQL Server 2008 instance setup
>> and I want to know if I connect to a SQL Server 2008 database via my
>> current Management Studio?
>
> You can't.

This is incorrect. But you must make sure that you have SP3 of the SQL 2005
tools on your box. SSMS 2005 SP2 cannot connect to SQL 2008.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

From: Jeroen Mostert on 23 Apr 2010 00:56
On 2010-04-22 23:42, Erland Sommarskog wrote:
> Jeroen Mostert (jmostert(a)xs4all.nl) writes:
>> On 2010-04-22 21:01, Greg wrote:
>>> All of my databases are currently in SQL Server 2005. Thus, I have SQL
>>> Server 2005 Management Studio installed on my machine to connect to my
>>> SQL Server 2005 instances. We now have a SQL Server 2008 instance setup
>>> and I want to know if I connect to a SQL Server 2008 database via my
>>> current Management Studio?
>>
>> You can't.
>
> This is incorrect. But you must make sure that you have SP3 of the SQL 2005
> tools on your box. SSMS 2005 SP2 cannot connect to SQL 2008.
>
Oh, that's good to know. Obviously I've never tried beyond SP2, as I imagine
many others haven't.

--
J.
 | 
Pages: 1
Prev: Best Practice - Converting ntext to nvarchar(max)
Next: SQL Server 2005 sp3 Query Execution Issue