>- see footer for list info -< Neil, I have resolved my problem which I have told you, and do not wish to participate in a stupid Argument over whether or not SQL Server tells you to use the MOVE command when I have seen it with my own eyes and know it to be true so I am certainly not going to waste time trying to prove it to you.
Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robertson-Ravo, Neil (RX) Sent: 29 July 2005 11:46 To: Coldfusion Development Subject: RE: [CF-Dev] Restoring a database with MOVE >- see footer for list info -< As others have noted (and what they teach you in the MS exams) restoring a DB this way is simple -as long as A) you have a .BAK and that you are changing the path to point to the new DB AND the log file. Send me some screen grabs of you need to but really if all you have is a .bak and you are restoring to a blank database should take you no longer than 10 minutes. N -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Snake Sent: 29 July 2005 11:47 To: 'Coldfusion Development' Subject: RE: [CF-Dev] Restoring a database with MOVE >- see footer for list info -< NEIL, You are incorrect. I have done this many times, and the restoration path has been correct every time. And SQL Server always throws that error and tells you to use MOVE when trying to rename the database. Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robertson-Ravo, Neil (RX) Sent: 29 July 2005 11:07 To: Coldfusion Development Subject: RE: [CF-Dev] Restoring a database with MOVE >- see footer for list info -< It will ONLY error if you have specified an incorrect path in the move to Physical File name - note: this process will only work with .BAK files not MDF/LDF. For example you create a new Blank DB on C:\mydatabases but your backup is from D:\mydatabases - this will error when restoring as the backup file keeps the old filepath, but if you alter the path before restoring it will work fine , this is the defacto way of restoring a database uinless you want to Detach and do some other tasks on it. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Snake Sent: 29 July 2005 11:08 To: 'Coldfusion Development' Subject: RE: [CF-Dev] Restoring a database with MOVE >- see footer for list info -< If it was this simple I would have done it, to repeat my last reply. If you try and restore over an existing database and rename it, SQL Server will throw an error telling you. Use WITH MOVE to identify a valid location for the file. But I have managed to do it by not restoring over an existing database, and renaming the database as well when it is restored. Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robertson-Ravo, Neil (RX) Sent: 29 July 2005 10:50 To: Coldfusion Development Subject: RE: [CF-Dev] Restoring a database with MOVE >- see footer for list info -< Well, if all you are doing is to creating a blank DB and you want to restore simply do this 1. Right-click on the blank DB > All tasks > Restore Database, 2. Click From Device checkbox and select your .BAK file (not the LDF of MDF as you shouldn't need these) 3. Force over Existing Database and ensure you alter the paths in the . 4. Click on Options Tab > check Force restore over existing database 5. Click within the Move To Physical File Name box and ensure the path is pointing to your new blank DB which you created. 6. Click OK That is all you should need to do to restore a DB over a blank DB with the same data and schema as its original. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Snake Sent: 29 July 2005 10:51 To: 'Coldfusion Development' Subject: RE: [CF-Dev] Restoring a database with MOVE >- see footer for list info -< Because SQL then tells you. Use WITH MOVE to identify a valid location for the file. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robertson-Ravo, Neil (RX) Sent: 29 July 2005 10:38 To: Coldfusion Development Subject: RE: [CF-Dev] Restoring a database with MOVE >- see footer for list info -< Why don't you just perform a forced database restore). -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Snake Sent: 29 July 2005 10:42 To: 'Coldfusion Development' Subject: [CF-Dev] Restoring a database with MOVE >- see footer for list info -< I have a database backup (SQL Server 2000) That I need to restore with another name,filename. So have created a blank database and am trying to restore over the top of it using MOVE. Obviously something is not right here as SQL Server is still telling me. File 'proWorkFlow_v3_SQL_dat' cannot be restored to 'd:\MSSQL\Data\fused_PWF.mdf'. Use WITH MOVE to identify a valid location for the file. Can anyone spot my mistake. RESTORE DATABASE fused_PWF FROM DISK = 'd:\backups\MSSQL\proworkflow_v3.7.bak' WITH NORECOVERY, MOVE 'proWorkFlow_v3_SQL_dat' TO 'd:\MSSQL\Data\fused_PWF.mdf', MOVE 'proWorkFlow_v3_SQL_log' TO 'd:\MSSQL\Data\fused_PWF_log.ldf', REPLACE -- Russ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< 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 _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< 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 _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< 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 _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< 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 _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
