March 21, 2002 at 6:58 am
SQL Server 7.0 Standard --> SQL Server 2000 Enterprise
I am using sp_attach to test the upgrade process for our databases.
The steps I have are:
1. Source: shut down SQL Server services
2. Copy the .MDF & .LDF files to Destination
3. Start back up the SQL Services on Source
4. sp_attach the .MDF & .LDF files on Destination
Do I need to create the databases on the Destination SQL Server first when using sp_attach ? If so, does it need to have the same directory structure as the source database ?
Anything else I am missing here ???
March 21, 2002 at 7:28 am
No because you will name it.
EXEC sp_attach_db
@dbname = N'yourdbnamehere',
@filename1 = N'drive:\path\file.mdf',
@filename2 = N'drive:\path\file.ldf'
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 21, 2002 at 7:47 am
So I don't need to create the database before hand and I can put the .MDF and .LDF files whereever I want ?
March 21, 2002 at 7:58 am
March 21, 2002 at 9:03 am
sweet.
Also, does the 7.0 database get "upgraded" in the process.(i.e. does SQL Server make any changes at the database level, etc...)
March 21, 2002 at 10:29 am
I do not believe that anything happens to the database as SQL 2000 is capable of readin 7 databases without issue.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Edited by - antares686 on 03/21/2002 10:30:28 AM
Sorry I was wrong it does upgrade to SQL2K the internals.
Edited by - antares686 on 03/21/2002 10:45:24 AM
March 21, 2002 at 11:25 am
"it does upgrade to SQL2K the internals".
do you know exactly what happens here ?
March 21, 2002 at 1:36 pm
Also,
Books Online:
"sp_attach_db should only be executed on databases that were previously detached from the database server using an explicit sp_detach_db operation".
Do you guys do this or just shut down the Source sql server services, copy the files and then sp_attach on Destination ?
March 22, 2002 at 5:15 am
quote:
do you know exactly what happens here ?
Mostly adds system objects that only exist in 2000 that you can see right off, I am not sure what else, someone may have looked into these details and can post.
quote:
Do you guys do this or just shut down the Source sql server services, copy the files and then sp_attach on Destination ?
I have done it both ways. I believe this is a saftey precaution more than anything when Microsoft states this so that it is not longer connected to the old server if you are planning on moving.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 2, 2002 at 12:17 pm
"Mostly adds system objects that only exist in 2000"
Can anyone expand on this ?
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply