Error In Log

Morning All,
Rececntly I have been getting quite a few errors on the resotre of my
databases, what happens is the files are downloaded from a remote server,
unziped and then I run some script to restore them.....this has been workin
g
fine for quite some time with no problems whatsoever, until recently where
things have been crashing and my databases have been getting set to
Single-User mode which I do not want. I thought the failing of the restores
might have been a conflict in times of when things happen so I have made som
e
changes where this can not possibly be the issue, and I have now removed the
ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script from my
restore process as a temp measure. After all this I am now getting a strang
e
error in the Log Files which I am not really sure what it means so I am
hoping someone can help, it says -:
BackupDiskFile::OpenMedia: Backup device
'C:\Download\Found' failed to open. Operating
syster error = 2(error not found).
Thanks for any help offered and I am currently using SQL Server 2000
Thanks PDPhil
When you say "some script to restore them.." , did you mean you was be able
to restore database? If so , do you have last backup of the database?
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
> Morning All,
> Rececntly I have been getting quite a few errors on the resotre of my
> databases, what happens is the files are downloaded from a remote server,
> unziped and then I run some script to restore them.....this has been
> working
> fine for quite some time with no problems whatsoever, until recently where
> things have been crashing and my databases have been getting set to
> Single-User mode which I do not want. I thought the failing of the
> restores
> might have been a conflict in times of when things happen so I have made
> some
> changes where this can not possibly be the issue, and I have now removed
> the
> ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script from
> my
> restore process as a temp measure. After all this I am now getting a
> strange
> error in the Log Files which I am not really sure what it means so I am
> hoping someone can help, it says -:
> BackupDiskFile::OpenMedia: Backup device
> 'C:\Download\Found' failed to open. Operating
> syster error = 2(error not found).
> Thanks for any help offered and I am currently using SQL Server 2000
> Thanks PD|||Hi,
Thanks for the quick reply, yes I do have the last backup of the database,
the databases are downloaded to a folder on the SQL Server and then Restored
from there! I can get them to restore but there seems to be problems with
the reliability at the moment! Thats why I thought the error message that I
posted here might have something to do with it
Thanks for you help, Phil
"Uri Dimant" wrote:

> Phil
> When you say "some script to restore them.." , did you mean you was be abl
e
> to restore database? If so , do you have last backup of the database?
>
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
>
>|||Phil
Don't you perform BACKUP LOG ...?
Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...[vbcol=seagreen]
> Hi,
> Thanks for the quick reply, yes I do have the last backup of the database,
> the databases are downloaded to a folder on the SQL Server and then
> Restored
> from there! I can get them to restore but there seems to be problems with
> the reliability at the moment! Thats why I thought the error message that
> I
> posted here might have something to do with it
>
> Thanks for you help, Phil
> "Uri Dimant" wrote:
>|||Windows Error codes are listed here:
http://www.support.tabs3.com/main/R10307.htm
Error code 2 means file not found.
Paul
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23xFWWtF6GHA.5068@.TK2MSFTNGP06.phx.gbl...
> Phil
> Don't you perform BACKUP LOG ...?
> Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...
>|||Hi Uri,
No I dont perform a BACKUP LOG, the database that I download comes from a
completely different company from the one that I work for and during the day
they perform (Complete Backups) and then we download them as zip files where
I then unpack them and restore over the top of the previous one. The script
that I have loads all the backups names into a table for a specific database
that I want to restore and lists them by date and picks the most recent
backup to restore!
Thanks Phil
"Uri Dimant" wrote:

> Phil
> Don't you perform BACKUP LOG ...?
> Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...
>
>