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