>- see footer for list info -< Russ, This is a passage for BOL.
BACKUP DATABASE Northwind TO DISK = 'c:\Northwind.bak' RESTORE FILELISTONLY FROM DISK = 'c:\Northwind.bak' RESTORE DATABASE TestDB FROM DISK = 'c:\Northwind.bak' WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf', MOVE 'Northwind_log' TO 'c:\test\testdb.ldf' GO Try removing the 'NORECOVERY' statement and see if that works, its not used in there example above. Gene -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Snake Sent: Friday, July 29, 2005 10:42 AM 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 -< _______________________________________________ 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 -<
