Date parsed: 16/10/2007 11:46:48
Date: Tue, 16 Oct 2007 18:46:48 -0700

Hi,
I have a few questions about sql 2005 as follows:
1. Which MS SQL version (edtion) is good as database to
support a midium size web size?
2. I have old *.mdf and .ldf file from ms sql 2000. Does it
work if I just simple copy them (or just *.mdf file) to 2005
sql server (any edition). to make it work as sql 2000?

TIA,
steve

Date parsed: 17/10/2007 14:26:03
Date: Wed, 17 Oct 2007 11:26:03 +0300

It's you to determine your workload and choose the best edition:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

--
Ekrem ?nsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT



<aaabbb16@hotmail.com> wrote in message
news:1192585608.121780.22060@t8g2000prg.googlegroups.com...
> Hi,
> I have a few questions about sql 2005 as follows:
> 1. Which MS SQL version (edtion) is good as database to
> support a midium size web size?
> 2. I have old *.mdf and .ldf file from ms sql 2000. Does it
> work if I just simple copy them (or just *.mdf file) to 2005
> sql server (any edition). to make it work as sql 2000?
>
> TIA,
> steve
>

Date parsed: 18/10/2007 05:29:04
Date: Thu, 18 Oct 2007 12:29:04 -0700

On 10 17 , 9 59 , "Rick Heiges" <heige...@hotmail.com> wrote:
> As others have already answered,the answer is "it depends". Also, you may
> attach a 2000 MDF to 2005, but once you do so, you may not reattach it to
> 2000. Also, there are some functionality and supported syntax differences
> between the two versions. Your MDF will attach, but your application may
> not behave properly. Fortunately, there are several tools to help you with
> this... Upgrade Advisor and Upgrade Assistant.
>
> Rick Heiges, SQL MVP<aaabb...@hotmail.com> wrote in message
>
> news:1192585608.121780.22060@t8g2000prg.googlegroups.com...
>
>
I dont see "attach" on my 2005 express management studio.
(database_name-->tasks-> detatch, shrink backup,restor.)
no attach item.
Does it need standard 2005 management studo?
Some books show one more "copy" item, but I dont see my studio.
also download Upgrad advisor and play a while,still not see how to
attach
my old *.mdf and *.ldf to my 2005 sql server express.
Is that limitation for 2005 sql server express?

Thanks,
Steve