It has a weekly full back up with a nightly incremental backup, so that is an option, I would just loose some data from today. I was hoping to keep the current MDF file and just get SQL server to rebuild the log file.
Thanks. ---------------------------------------- What backup plan is in place? When was you last .bak? "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Jeff D. Chastain To: CF-Talk Sent: Wed Jul 19 23:30:41 2006 Subject: Re: SQL Server Emergency Well, for one the database in question is huge. But, I went ahead and tried it anyways using the DTS Import/Export and it fails with a 'Fatal Error 8908' which I have never seen before. Thanks -- Jeff ---------------------------------------- Jeff, Not sure I have an answer for you regarding detaching, but.... What about creating a blank DB....import the database that is having issues....drop the old DB...rename the new one and voila! you should be up and running again Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247131 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4