Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CMangano
Starting Member
16 Posts |
 Posted - 2001-12-20 : 11:29:51
|
| I am having problems when I try to attach a database from SQL 7 to SQL 2000. I ran sp_detach_db on the SQL 7 db, then copied the data files (MDF, LDF) to a different location. I then re-attached the db. No problems.I moved the copies of the data files to my other server and tried to attach them using sp_attach_db but I keep getting the following error:"Device Activation Error. The physical file name 'C:\Microsoft SQL Server\MSSQL\Data\dbname.mdf' may be incorrect." I know the path is correct. I even tried it by moving the files to the root of C and doing it, and I got the same error. Is there something else I need to do when moving a SQL 7 db to 2000? |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2001-12-20 : 11:40:55
|
| Make sure you don't have a permissions problem.Try: master..xp_cmdshell 'dir C:\Microsoft SQL Server\MSSQL\Data\dbname.mdf' And see if the filename is returned to the results pane. If not, the MSSQLServer account may not have access to that directory, or file.-Chad |
 |
|
|
|
|
|
Attaching a SQL Server 7 DB to SQL Server 2000