Database Move

[cceng]

I will be moving a few databases to a new SQl server. One issue I have is that the location of the database files on the current server is E: and where they will be on the new server is c:

When I detach and attach the database to the new server does it recognize the new location of the files?

I am using the command sp_detach and sp_attach to move the database.

 

[RickCole]

You will have to specify the new location of the files once they have been moved and you use sp_attach_db.

Example:

EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\mssql7\data\pubs.mdf',
@filename2 = N'c:\mssql7\data\pubs_log.ldf'


Rick.

 

[cceng]

Thanks!