Moving Data from SQL Server 2000 to SQL Server 2005 - Parking Data in SQL 2005 Server, continued
(Page 4 of 4 )
The program goes through its motions and presto! The Northwind database is attached to the SQL 2005 Server. You will see the Northwind database objects are present by expanding the database node.
Now if you open Windows Explorer you will be able to locate these files as shown. They will be found in the MSSQL.1 sub-folder.
You need both the mdf and ldf files. If you fail to copy the .ldf file to the correct folder, or if it is missing you get the following screen.
When you click OK to this screen, you will get the following message to let you know there was a problem.
When you click OK you will be returned to the previous screen, and now a message is available as a hyperlink in the Messages column in the table under Databases to attach:. Attach in the message column. Clicking this link opens the MS SQL Server Management Studio message that gives more details about the failed attempt as shown.
Summary
It is very easy to attach/detach SQL Server 2000 databases to the SQL 2005 Server. It was noticed that the file sizes increased when attached to the SQL 2005 Server and provision must be made if very large databases are moved. The northwnd.mdf changed from 3.0 MB to 4.0 MB and the northwnd.ldf changed from 1.0 MB to 4.6 MB. Also, remember to take heed of Microsoft's recommendations as to the new stored procedures while attaching to SQL 2005.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
|
| · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | · | | | | |
|
/ 60 
