>- see footer for list info -< If you have a backup file of the database, you don't need to create a new, blank database to restore the backup. Just go all tasks-> restore, then change the name to whatever you want to restore it as at the top, then click the 'from device' radio button, click select devices button, click add, browse for the backup file you want to restore, click OK all the way back to the first screen (where you named what you want to restore it as). Click the options tab, and you see a list of all file names with 'move to physical filename' next to it. Click in this box, and you can change the file path/name of where the new restore will be saved to. Change this to what you need, and that's it. Seems a lot of steps, but it isn't really ...
-----Original Message----- From: Snake [mailto:[EMAIL PROTECTED] 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 -- 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 >-< **************************************************************************** Notice: This e-mail and any attachments are confidential and may contain legally privileged information and/or copyright material of Hansen Technologies Limited or third parties. Copying, distributing, disclosing, commercialising or otherwise acting in reliance on this e-mail and any attachments is strictly prohibited unless you are the addressee of this e-mail and have written permission to do so. If you have received this e-mail in error please delete this e-mail (including any copies and attachments) and contact Hansen Technologies Limited by return e-mail or by telephone on + 61 39840 3000. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of or be a commitment by the organisation, except where the individual sender has the authority and expressly states them to be so. **************************************************************************** _______________________________________________ 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 -<
