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