I tried out sp_attach_db too but I get the same error.
-----Original Message-----
From: Gentle, Mary [mailto:Mary.[Email Address Removed]
Sent: March 22, 2004 1:50 PM
To: Aaron; LazyDBA.com Discussion
Subject: RE: Attach Database
Does you database have multiple log files?
If so, see http://support.microsoft.com/default.aspx?scid=kb;en-us;271223
-----Original Message-----
From: Aaron [mailto:[Email Address Removed] Monday, March 22, 2004 11:35 AM
To: LazyDBA.com Discussion
Subject: RE: Attach Database
It's on a local drive.
I detached the db to remove the transaction log - but now I can't seem to
re-attach it.
-----Original Message-----
From: Horton, Joe (LNI) [mailto:[Email Address Removed] March 22, 2004 1:33 PM
To: 'Aaron'; LazyDBA.com Discussion
Subject: RE: Attach Database
Is it a local drive? If not use the UNC
__________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200
-----Original Message-----
From: Aaron [mailto:[Email Address Removed] Monday, March 22, 2004 10:30 AM
To: LazyDBA.com Discussion
Subject: RE: Attach Database
Everything there is correct. The BOL was just an example. I copied & pasted
the path from Windows Explorer
-----Original Message-----
From: Herrera, Jorge [mailto:[Email Address Removed] March 22, 2004 1:25 PM
To: LazyDBA.com Discussion
Subject: RE: Attach Database
Aaron,
Check the Path and DB name for correct spelling.
Jorge A. Herrera
MSSQL DBA
Chevy Chase Bank
6200 Chevy Chase Drive
Laurel, MD. 20707
[Email Address Removed] Message-----
From: Aaron [mailto:[Email Address Removed] Monday, March 22, 2004 1:04 PM
To: LazyDBA.com Discussion
Subject: Attach Database
From BOL I have used this example to attempt to re-attach a .mdf
EXEC sp_attach_single_file_db @dbname = 'pubs',
@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'
But, I'm getting this error all the time:
Server: Msg 1813, Level 16, State 2, Line 1 Could not open new database
'db1'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'D:\sqldata\db1_log.ldf' may
be incorrect.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed] is to be used for Chevy Chase Bank business purposes only.
Confidential information should not be sent via email as there is no
expectation of privacy or integrity of the message through the Internet.
**********************************************************************
**********************************************************************
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
This footnote confirms that this email message has been scanned for the
presence of computer viruses.
Chevy Chase Bank
**********************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page