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
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Adding new database

Author  Topic 

Starting Member

1 Post

Posted - 2015-03-28 : 14:48:40
I am new to sql but i tried to add one data base , i am getting error message When i try to attach the database
Not primary database file

Please any body can help

O buzaid

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2015-03-28 : 15:57:42
Is the file a primary database file? By default the primary file has the extension .MDF. If it is a backup file, you will need to RESTORE rather than ATTACH. Usually people give .BAK extension to backup files.
Go to Top of Page

- Advertisement -