The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.
Showing posts with label event. Show all posts
Showing posts with label event. Show all posts
Monday, March 26, 2012
Entire 2005 Database deleted
The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.
Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.
Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.
Entire 2005 Database deleted
The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.
Wednesday, March 21, 2012
Enterprise Manager Tape Backup issue
I have multiple failed backups jobs through the enterprise manager. I have an
event id 9 "\device\scis\aic78u21 did not respond within the timeout period"
and event id 15 "\device\tape0 is not ready for access yet." The aic78u21 is
the scsi controller and only appeared once. Since then, I have had multiple
event id 15. However I did boot up into the scsi utility and teh dlt tape
device is listed in the utility with scsi id 3, and the controler listed as
scsi id 7. I then ran a ntbackup job on a new media set and it ran fine.
However the scheduled jobs within enterprise manager still will not run. Our
SQL admin is no longer with us, and myself and another have been tasked with
the SQL admin, so we are both leery of making any changes that might have bad
reprecussions later. I thought about deleting and adding the tape device back
into the enterprise manager, but I'm wondering if it is a media set issue.
What do you think?I forgot to mention that the device does show up in device manager with the
questions marks in the other devices category. Is this due to the device
running off of the scsi controller drivers?
"sigm" wrote:
> I have multiple failed backups jobs through the enterprise manager. I have an
> event id 9 "\device\scis\aic78u21 did not respond within the timeout period"
> and event id 15 "\device\tape0 is not ready for access yet." The aic78u21 is
> the scsi controller and only appeared once. Since then, I have had multiple
> event id 15. However I did boot up into the scsi utility and teh dlt tape
> device is listed in the utility with scsi id 3, and the controler listed as
> scsi id 7. I then ran a ntbackup job on a new media set and it ran fine.
> However the scheduled jobs within enterprise manager still will not run. Our
> SQL admin is no longer with us, and myself and another have been tasked with
> the SQL admin, so we are both leery of making any changes that might have bad
> reprecussions later. I thought about deleting and adding the tape device back
> into the enterprise manager, but I'm wondering if it is a media set issue.
> What do you think?
event id 9 "\device\scis\aic78u21 did not respond within the timeout period"
and event id 15 "\device\tape0 is not ready for access yet." The aic78u21 is
the scsi controller and only appeared once. Since then, I have had multiple
event id 15. However I did boot up into the scsi utility and teh dlt tape
device is listed in the utility with scsi id 3, and the controler listed as
scsi id 7. I then ran a ntbackup job on a new media set and it ran fine.
However the scheduled jobs within enterprise manager still will not run. Our
SQL admin is no longer with us, and myself and another have been tasked with
the SQL admin, so we are both leery of making any changes that might have bad
reprecussions later. I thought about deleting and adding the tape device back
into the enterprise manager, but I'm wondering if it is a media set issue.
What do you think?I forgot to mention that the device does show up in device manager with the
questions marks in the other devices category. Is this due to the device
running off of the scsi controller drivers?
"sigm" wrote:
> I have multiple failed backups jobs through the enterprise manager. I have an
> event id 9 "\device\scis\aic78u21 did not respond within the timeout period"
> and event id 15 "\device\tape0 is not ready for access yet." The aic78u21 is
> the scsi controller and only appeared once. Since then, I have had multiple
> event id 15. However I did boot up into the scsi utility and teh dlt tape
> device is listed in the utility with scsi id 3, and the controler listed as
> scsi id 7. I then ran a ntbackup job on a new media set and it ran fine.
> However the scheduled jobs within enterprise manager still will not run. Our
> SQL admin is no longer with us, and myself and another have been tasked with
> the SQL admin, so we are both leery of making any changes that might have bad
> reprecussions later. I thought about deleting and adding the tape device back
> into the enterprise manager, but I'm wondering if it is a media set issue.
> What do you think?
Subscribe to:
Posts (Atom)