Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Device activation error . the physical file name

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2006-11-08 : 08:10:44
rajesh writes "Hi All

When i attach my production database i got an device activation Error
attach database."

Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-08 : 08:55:42
Some error number? Windows log?

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Yak with Vast SQL Skills

899 Posts

Posted - 2006-11-08 : 12:46:47
(Replies may be delayed as I'm OOF again - this time at TechEds in Spain)

My guess is that the directory that the original files lived in no longer exists - so you have to provide the new location of the files.

Are you 2000 or 2005? Look at the BOL for CREATE DATABASE .. FOR ATTACH on 2005, sp_attach_db on 2000.


Paul Randal
Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

- Advertisement -