|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Attaching SQL Server 2000 database on SQL Serve 2005
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 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.' Show quoteHide quote "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 > > > you should copy the datafile to a specifically catalog 。And use new files to
attach.Otherwise 2000 server's 'test' database will disappear Show quoteHide quote "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,
Thanks for you reply. I do know how to detach/attach database. My question is whether anyone has experienced any problems while attaching terabyte databases. Thanks, Igor Show quoteHide quote "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 >> > >> > >> > 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 Show quoteHide quote "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,
Thanks for you feedback. Igor Show quoteHide quote "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 >> >> >>  
Other interesting topics
Difference between 2000 and 2005. Maybe a bug?
Sql Server 2005 - SMS "Modify Table option" times out when trying to 'alter' very large table sql2k log backup user accounts after restore in SQL 2000 SQLExpress Rename Cluster Instance - New Hardware - Keep Name Moving the SQL 2005 System Tables linked server to Excel SQL Server CPU Spikes query performance with large tables |
|||||||||||||||||||||||
