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