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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 copy database

Author  Topic 

shanmugaraj
Posting Yak Master

219 Posts

Posted - 2006-03-07 : 03:09:30
when i try this query to attach a database,


EXEC sp_attach_db @dbname = 'EnvNew',
@filename1 = 'D:\K-Plus\EngineeringDB\Database\EnvNew.mdf',
@filename2 = 'D:\K-Plus\EngineeringDB\Database\EnvNew.ldf'



ERROR :

Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'D:\K-Plus\EngineeringDB\Database\EnvNew.mdf' is not a valid database file header. The PageAudit property is incorrect.








pls help me....

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2006-03-07 : 03:22:32
Try to attach from enterprise mamager..

------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page

mr_mist
Grunnio

1870 Posts

Posted - 2006-03-07 : 04:03:29
Please try to keep related messages in the same thread, rather than starting new ones for the same issue. Your problem was already being discussed in

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62755

-------
Moo. :)
Go to Top of Page

shanmugaraj
Posting Yak Master

219 Posts

Posted - 2006-03-07 : 04:16:04

sorry ... i have the server in remote.. pls tell how to do ?
quote:
Originally posted by ravilobo

Try to attach from enterprise mamager..

------------------------
I think, therefore I am - Rene Descartes


Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2006-03-07 : 04:23:55
You can register a remote server to your local EM or use RDC to login to the remote server.

------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page
   

- Advertisement -