Do you have the back up of this database.
Seems the database was not in consistent state when you detached these files.
-----Original Message-----
From: Loach Simon
[mailto:mssqldba-ezmlmshield-x61727661.[Email address protected]
Sent: Tuesday, January 30, 2007 5:54 PM
To: LazyDBA Discussion
Subject: RE: How can I attach a SQL2000 database that only has .MDF file
Should have added Im using 2005 and when I try and reattach just the mdf it
returns the error "the system cannot find the file specified" (the ldf)
-si
-----Original Message-----
From: Loach Simon
[mailto:mssqldba-ezmlmshield-x59553230.[Email address protected]
Sent: 30 January 2007 12:01
To: LazyDBA Discussion
Subject: RE: How can I attach a SQL2000 database that only has .MDF file
yeah unfortunately no joy with that approach either :-)
-si
-----Original Message-----
From: Carol Green
[mailto:mssqldba-ezmlmshield-x31431929.[Email address protected]
Sent: 30 January 2007 11:55
To: LazyDBA Discussion
Subject: RE: How can I attach a SQL2000 database that only has .MDF file
Just a thought - have you tried restoring it as a different name?
-----Original Message-----
From: Loach Simon
[mailto:mssqldba-ezmlmshield-x98708450.[Email address protected]
Sent: 30 January 2007 11:56
To: LazyDBA Discussion
Subject: RE: How can I attach a SQL2000 database that only has .MDF file
No if I use
sp_attach_single_file_db @dbname = 'CommunityServer20',
@physname = N'C:\SQL
Backups\CommunityServer20.mdf';
I get
File activation failure. The physical file name "C:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\CommunityServer_log20.LDF"
may be incorrect. The log cannot be rebuilt because the database was not
cleanly shut down. Msg 1813, Level 16, State 2, Line 1 Could not open
new database 'CommunityServer20'. CREATE DATABASE is aborted.
--si
-----Original Message-----
From: Gowda Prashanth [mailto:mssqldba-ezmlmshield-x94521564.[Email
address protected]
Sent: 30 January 2007 11:43
To: LazyDBA Discussion
Subject: RE: How can I attach a SQL2000 database that only has .MDF file
I think .Mdf file is enough and it will ask you to creates the .ldf file
while attaching ???
-----Original Message-----
From: Loach Simon
[mailto:mssqldba-ezmlmshield-x91321660.[Email address protected]
Sent: Tuesday, January 30, 2007 4:43 PM
To: LazyDBA Discussion
Subject: RE: How can I attach a SQL2000 database that only has .MDF file
Similar problem except my db wasn't happily detached but more ripped
kicking and screaming by sharepoint :-(
So I have a mdf file but no ldf, sp_attach_single_file_db doesn't work
for me
-----Original Message-----
From: Michael Sexton (US-IT Contractor)
[mailto:mssqldba-ezmlmshield-x5550580.[Email address protected]
Sent: 29 January 2007 19:11
To: LazyDBA Discussion
Subject: RE: How can I attach a SQL2000 database that only has .MDF file
Use sp_attach_single_file_db
Mike
-----Original Message-----
From: Jianming Xing [mailto:mssqldba-ezmlmshield-x46178493.[Email
address protected]
Sent: Monday, January 29, 2007 11:56 AM
To: LazyDBA Discussion
Subject: How can I attach a SQL2000 database that only has .MDF file
Hello all,
I have a detached database that has only .MDF file. When I try to attach
it, I got Error 1813. It said "Could not open new database 'XXXX'.
Create database is aborted. Device activation error. The physical file
name XXXX.LDF may be incorrect". We should be able attach a database
that has no .LDF. It supposes to create a new .LDF. But I failed. Does
any pro have experience on attaching only .MDF database?
thank you in advance for any tips.
JIANMING
This e-mail message and any attachments are confidential. They may also
be privileged or otherwise protected by work product immunity. If you
have received this e-mail by mistake, please notify us by reply e-mail,
delete it from your system, and any disclosure, copying or use of its
contents is prohibited. Thank you, www.oceantomo.com.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This message and any attachments are intended only for the use of the
addressee and may contain information that is privileged and
confidential. If the reader of the message is not the intended recipient
or an authorized representative of the intended recipient, you are
hereby notified that any dissemination of this communication is strictly
prohibited. If you have received this communication in error, notify the
sender immediately by return email and delete the message and any
attachments from your system.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be
copied, disclosed to, retained or used by, any other party. If you are
not an intended recipient then please promptly delete this e-mail and
any attachment and all copies and inform the sender. Thank you.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This message and any attachments are intended only for the use of the
addressee and may contain information that is privileged and
confidential. If the reader of the message is not the intended recipient
or an authorized representative of the intended recipient, you are
hereby notified that any dissemination of this communication is strictly
prohibited. If you have received this communication in error, notify the
sender immediately by return email and delete the message and any
attachments from your system.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This email and any files transmitted within it are private and confidential.
If you are not the intended recipient, this email and any attachments within
it have been transmitted to you in error.
You are prohibited from using, copying, distributing or otherwise using the
information contained within this email.
Nothing in this email message amounts to a contractual or legal commitment
on the part of Optilan unless confirmed by a communication signed on behalf
of the company.
Any email cannot be guaranteed to be secure, error free or free from
viruses. Although every possible care is taken by Optilan, Optilan does not
accept any liability whatsoever for any loss or damage which may be caused
as a result of the transmission of this message by email.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This message and any attachments are intended only for the use of the
addressee and may contain information that is privileged and confidential.
If the reader of the message is not the intended recipient or an authorized
representative of the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, notify the sender immediately by
return email and delete the message and any attachments from your system.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately by return email and delete the message and any attachments from your system.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page