Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Device Activation Error

Status
Not open for further replies.
parsql

parsql

MIS
Nov 10, 2005
106
US
Hi all,

I am trying to attached database to the system but it is giving me error saying that :

error 3813 could not open new database 'test'. Create database is aborted.
device activation error. the physical file name 'f:/mssql/logs/test_log.ldf' may be incorrect!

How can i solve it. and attach database.

Thanks
 
Sort by date Sort by votes
Have you confirmed that you are pointing to the correct .mdf in the correct location?
 
Upvote 0 Downvote
yeah the mdf file is in the d: drive in mssql/data folder?
 
Upvote 0 Downvote
It's looking for the ldf file in f:\mssql\logs\. Are you sure that this folder exists and that it's not a mapped drive?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Upvote 0 Downvote
How are you trying to attach the file? Are you using a script or Enterprise Manager?

If a script, make sure you enter the correct file path.
If Enterprise Manager, make sure you browse to the correct files.

As MrDenny says...you state the files are in the D:\MSSQL\Data folder, but SQL Server is being told to look for them in 'f:/mssql/logs/test_log.ldf'

-SQLBill

Posting advice: FAQ481-4875
 
Upvote 0 Downvote
No I get error saying that

Cannot associate files with different databases.
 
Upvote 0 Downvote
what is this error not after try to attache it gives me that the
Cannot associate files with different databases.

But there is not data base exist on system by that name(testdb)??
 
Upvote 0 Downvote
That error usually means you are trying to attach the wrong files:

For example:
You want to attach TestDB, but are using files from OtherDB.

You say the error is this:
the physical file name 'f:/mssql/logs/test_log.ldf' may be incorrect!

But you say the database files are in:
the mdf file is in the d: drive in mssql/data folder

Were the .ldf files always on the F drive? Were the .mdf always on the D drive?

-SQLBill

Posting advice: FAQ481-4875
 
Upvote 0 Downvote
Please post the exact script that you are running to attach the database.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
731
Andrzejek
Andrzejek
Virendra Yaduvanshi
  • Locked
  • Question
SSRS - Subscription page error
Replies
0
Views
317
Virendra Yaduvanshi
Virendra Yaduvanshi
new_to_sql
  • Locked
  • Question
Access SQL Query Error
Replies
5
Views
329
dhookom
dhookom
kingz2000
  • Locked
  • Question
connection - runtime error (Excel to SQL-Sever) 1
Replies
2
Views
262
kingz2000
kingz2000
G12Consult
  • Locked
  • Question
Geography data type error
Replies
3
Views
267
G12Consult
G12Consult

Part and Inventory Search

Sponsor

Back
Top