RE: How can I attach a SQL2000 database that only has .MDF file

RE: How can I attach a SQL2000 database that only has .MDF file

 

  

Hi JIANMING,

Drop existing 'CommunityServer20' database and then go for
sp_attach_single_file_db.

Regards,
Chetan


-----Original Message-----
From: Gowda Prashanth
[mailto:mssqldba-ezmlmshield-x11755327.[Email address protected]
Sent: 31 January 2007 04:59
To: LazyDBA Discussion
Subject: RE: How can I attach a SQL2000 database that only has .MDF file

NO problem at current db, however you will not get old Logs. The logs
will be new.

Regards,
Prashanth

-----Original Message-----
From: Jianming Xing
[mailto:mssqldba-ezmlmshield-x67420282.[Email address protected]
Sent: Wednesday, January 31, 2007 1:48 AM
To: LazyDBA Discussion
Subject: RE: How can I attach a SQL2000 database that only has .MDF file


But if the mdf file was damaged or not consistent, it will be another
situation.


JIANMING

________________________________

From: Axtell Megan [mailto:mssqldba-ezmlmshield-x4533018.[Email address
protected]
Sent: Tue 1/30/2007 9:16 AM
To: LazyDBA Discussion
Subject: RE: How can I attach a SQL2000 database that only has .MDF file



Okay, so I created a database, detached it, and deleted the ldf file.
When I went to attach it the system asked me if I wanted to create a new
ldf. I said yes and it attached fine.

I'm confused as to what the exact problem is?



-----Original Message-----
From: Loach Simon
[mailto:mssqldba-ezmlmshield-x98708450.[Email address protected]
Sent: Tuesday, January 30, 2007 4:56 AM
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



---------------------------------------------------------------------
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



---------------------------------------------------------------------
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