"imarchenko" wrote:

> Hello!
>
>     We are planning to migrate our multi terabyte SQL Server 2000 database
> by detaching data/log files on 2000 box and reattaching them on 2005. Has
> anyone experienced any issues with this process in general and databases of
> such size in particular? As far as I know, SQL Server will perform database
> conversion when attaching database on SQL 2005.
>
>
> Any thoughts are greatly appreciated,
> Igor
>
>
>

"luyan" wrote:

> This is a simple test,with a database names 'test' which on sqlserver 2000.
> first:
> Stop the database's servers(2000) on machine.
> second:
> Execute the command on 2005 server:
> exec sp_attach_db @dbname = N'test',
> @filename1 = N'd:\sqlserver database\MSSQL\data\test_Data.MDF',
> @filename2 = N'd:\sqlserver database\MSSQL\data\test_Log.LDF'
>
> ok.So easy.And the server will return a message:'Converting database 'test'
> from version 539 to the current version 607.'
>
> "imarchenko" wrote:
>
> > Hello!
> >
> >     We are planning to migrate our multi terabyte SQL Server 2000 database
> > by detaching data/log files on 2000 box and reattaching them on 2005. Has
> > anyone experienced any issues with this process in general and databases of
> > such size in particular? As far as I know, SQL Server will perform database
> > conversion when attaching database on SQL 2005.
> >
> >
> > Any thoughts are greatly appreciated,
> > Igor
> >
> >
> >

"luyan" <lu***@discussions.microsoft.com> wrote in message
news:051EBA51-A12E-4E42-A07B-94B5D588DA72@microsoft.com...
> you should copy the datafile to a specifically catalog ?And use new files
> to
> attach.Otherwise 2000 server's 'test' database will disappear
>
> "luyan" wrote:
>
>> This is a simple test,with a database names 'test' which on sqlserver
>> 2000.
>> first:
>> Stop the database's servers(2000) on machine.
>> second:
>> Execute the command on 2005 server:
>> exec sp_attach_db @dbname = N'test',
>> @filename1 = N'd:\sqlserver database\MSSQL\data\test_Data.MDF',
>> @filename2 = N'd:\sqlserver database\MSSQL\data\test_Log.LDF'
>>
>> ok.So easy.And the server will return a message:'Converting database
>> 'test'
>> from version 539 to the current version 607.'
>>
>> "imarchenko" wrote:
>>
>> > Hello!
>> >
>> >     We are planning to migrate our multi terabyte SQL Server 2000
>> > database
>> > by detaching data/log files on 2000 box and reattaching them on 2005.
>> > Has
>> > anyone experienced any issues with this process in general and
>> > databases of
>> > such size in particular? As far as I know, SQL Server will perform
>> > database
>> > conversion when attaching database on SQL 2005.
>> >
>> >
>> > Any thoughts are greatly appreciated,
>> > Igor
>> >
>> >
>> >

"imarchenko" wrote:

> Hello!
>
>     We are planning to migrate our multi terabyte SQL Server 2000 database
> by detaching data/log files on 2000 box and reattaching them on 2005. Has
> anyone experienced any issues with this process in general and databases of
> such size in particular? As far as I know, SQL Server will perform database
> conversion when attaching database on SQL 2005.
>
>
> Any thoughts are greatly appreciated,
> Igor
>
>
>

"Bill Wang" <BillW***@discussions.microsoft.com> wrote in message
news:D23E2D1B-DAA2-4FA2-A5CA-E253DC148BED@microsoft.com...
> It may take a long time. I did restore a 500 MB SQL 2000 DB to SQL 2005
> and
> it took about 10 minutes on SAN system. In your situation you have to
> consider this issue.
>
> Bill
>
> "imarchenko" wrote:
>
>> Hello!
>>
>>     We are planning to migrate our multi terabyte SQL Server 2000
>> database
>> by detaching data/log files on 2000 box and reattaching them on 2005. Has
>> anyone experienced any issues with this process in general and databases
>> of
>> such size in particular? As far as I know, SQL Server will perform
>> database
>> conversion when attaching database on SQL 2005.
>>
>>
>> Any thoughts are greatly appreciated,
>> Igor
>>
>>
>>