Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 load database on 6.5 failing

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-06 : 17:14:01
sacok writes "hi

i am restoring a backup taken from one 6.5 box to another 6.5 which wouod act as a warm standby in case the main fails and restoring on to another box.as a scheduled job on another drive and this is the command i use .

Load Database DB_dbname
From disk = ' E:\SQLDUMP\xxx\DB_xxx_DUMP.DAT'
but i get the following error

Can't open dump device ' E:\ SQLDUMP\1621\DB_CORE_DUMP.DAT', device error or device off line. Please consult the SQL Server error log for more details

am doing any thing wrong at all

thanks for your help

sacok"
   

- Advertisement -