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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2006-10-16 : 08:50:28
|
| There is a database called AdventureWorks_Data.mdf in c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA on the local machine.In sql server 2005 Express, I would like to add this database. So in enterprise manager, right click databases, Attached, browse to the folder where the .mdf is located.But then the system does not pick up the .mdf files in the Data folder so it does not allow me to add the database file. How can this be resolved please? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-16 : 08:53:01
|
| Which error message are you getting?Peter LarssonHelsingborg, Sweden |
 |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2006-10-16 : 08:53:52
|
quote:
Originally posted by fmardani
There is a database called AdventureWorks_Data.mdf in c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA on the local machine.In sql server 2005 Express, I would like to add this database. So in enterprise manager, right click databases, Attached, browse to the folder where the .mdf is located.But then the system does not pick up the .mdf files in the Data folder so it does not allow me to add the database file. How can this be resolved please?
This was solved by moving the .mdf to another location.Thanks |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-16 : 09:07:19
|
| Great!That was outputted in the error message, right? Path not found?Peter LarssonHelsingborg, Sweden |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2006-10-16 : 09:10:29
|
quote:
Originally posted by Peso
Great!That was outputted in the error message, right? Path not found?Peter LarssonHelsingborg, Sweden
Hi, there was no error message, the system simply was unable to pick up the .mdf file from the original source so just relocated the file and the system did indeed pick up that file to select.Thanks |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-16 : 09:11:56
|
| How did you find out where to relocate the mdf-file?Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
|
|
Attach database