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

Enterprise Manager Tape Backup issue

I have multiple failed backups jobs through the enterprise manager. I have a
n
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 ba
d
reprecussions later. I thought about deleting and adding the tape device bac
k
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 perio
d"
> 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 multipl
e
> 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 a
s
> 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. O
ur
> SQL admin is no longer with us, and myself and another have been tasked wi
th
> 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 b
ack
> into the enterprise manager, but I'm wondering if it is a media set issue.
> What do you think?

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?

Enterprise Manager and MSDE

I have an MSDE database that I want to be able to look at the table
structure and schedule backups.
Does MSDE come with a set of client tools?
If not, can I simply install the client tools from SQL Server 2000 Standard
Edition and use them with MSDE?
> Does MSDE come with a set of client tools?
No.

> If not, can I simply install the client tools from SQL Server 2000
Standard
> Edition and use them with MSDE?
This can be a very tricky licensing issue, and I strongly recommend speaking
to your licensing rep (or where you obtained the standard license(s)) to
determine if your current agreement allows you to manage MSDE. MS' response
to this issue has varied from "whatever" to "you cannot do that."
In the meantime, you can try and see if any of these other tools will allow
you to schedule backups/jobs (most, if not all, will allow you to look at
schema):
http://www.aspfaq.com/2442
http://www.aspfaq.com/
(Reverse address to reply.)
|||HI
Does MSDE come with a set of client tools? : Not, but if you have SQL Server
2000 Server licence, you can install client tools, like Enterprise manager
ect. an you can use with MSDE.
Andras Jakus MCDBA
"Dave" wrote:

> I have an MSDE database that I want to be able to look at the table
> structure and schedule backups.
> Does MSDE come with a set of client tools?
> If not, can I simply install the client tools from SQL Server 2000 Standard
> Edition and use them with MSDE?
>
>
|||No, that's not true. Generally you cannot use those tools against MSDE. See
the sixth question in the Appropriate Uses of MSDE FAQ at
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp, copied below for
your benefit. The big catch here is the "in conjunction with a properly
licensed copy of SQL Server 2000", the definition of which is left up to
your lawyer because from what I've heard, the explanation of what that means
requires a room full of lawyers and a white board. :-) I'd strongly
recommend that you take a look at the alternatives that Aaron pointed you
at.
The good news is the MSDE's replacement, SQL Server 2005 Express, will come
with a GUI administration interface. The bad news is that SQL Server 2005
won't be released until next year.
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the How
to Buy page for information on obtaining a valid SQL Server license.
Note: The tools and services included with SQL Server Developer
Edition may not be used to manage production server environments.
The following utilities are installed by the MSDE setup application
and are provided without restrictions for use with the copy of MSDE that is
installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe,
sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
dtsrun.exe utility is also provided, but can only be used to run existing
Data Transformation Services (DTS) packages against the copy of MSDE
installed by your application; it cannot be used to develop new DTS
packages.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andras Jakus" <AndrasJakus@.discussions.microsoft.com> wrote in message
news:47DD19D4-A087-42F5-86D0-CB0BC3444DAA@.microsoft.com...[vbcol=seagreen]
> HI
> Does MSDE come with a set of client tools? : Not, but if you have SQL
> Server
> 2000 Server licence, you can install client tools, like Enterprise manager
> ect. an you can use with MSDE.
> Andras Jakus MCDBA
> "Dave" wrote:
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end

Enterprise Manager and MSDE

I have an MSDE database that I want to be able to look at the table
structure and schedule backups.
Does MSDE come with a set of client tools?
If not, can I simply install the client tools from SQL Server 2000 Standard
Edition and use them with MSDE?> Does MSDE come with a set of client tools?
No.
> If not, can I simply install the client tools from SQL Server 2000
Standard
> Edition and use them with MSDE?
This can be a very tricky licensing issue, and I strongly recommend speaking
to your licensing rep (or where you obtained the standard license(s)) to
determine if your current agreement allows you to manage MSDE. MS' response
to this issue has varied from "whatever" to "you cannot do that."
In the meantime, you can try and see if any of these other tools will allow
you to schedule backups/jobs (most, if not all, will allow you to look at
schema):
http://www.aspfaq.com/2442
--
http://www.aspfaq.com/
(Reverse address to reply.)|||HI
Does MSDE come with a set of client tools? : Not, but if you have SQL Server
2000 Server licence, you can install client tools, like Enterprise manager
ect. an you can use with MSDE.
Andras Jakus MCDBA
"Dave" wrote:
> I have an MSDE database that I want to be able to look at the table
> structure and schedule backups.
> Does MSDE come with a set of client tools?
> If not, can I simply install the client tools from SQL Server 2000 Standard
> Edition and use them with MSDE?
>
>|||No, that's not true. Generally you cannot use those tools against MSDE. See
the sixth question in the Appropriate Uses of MSDE FAQ at
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp, copied below for
your benefit. The big catch here is the "in conjunction with a properly
licensed copy of SQL Server 2000", the definition of which is left up to
your lawyer because from what I've heard, the explanation of what that means
requires a room full of lawyers and a white board. :-) I'd strongly
recommend that you take a look at the alternatives that Aaron pointed you
at.
The good news is the MSDE's replacement, SQL Server 2005 Express, will come
with a GUI administration interface. The bad news is that SQL Server 2005
won't be released until next year.
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the How
to Buy page for information on obtaining a valid SQL Server license.
Note: The tools and services included with SQL Server Developer
Edition may not be used to manage production server environments.
The following utilities are installed by the MSDE setup application
and are provided without restrictions for use with the copy of MSDE that is
installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe,
sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
dtsrun.exe utility is also provided, but can only be used to run existing
Data Transformation Services (DTS) packages against the copy of MSDE
installed by your application; it cannot be used to develop new DTS
packages.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andras Jakus" <AndrasJakus@.discussions.microsoft.com> wrote in message
news:47DD19D4-A087-42F5-86D0-CB0BC3444DAA@.microsoft.com...
> HI
> Does MSDE come with a set of client tools? : Not, but if you have SQL
> Server
> 2000 Server licence, you can install client tools, like Enterprise manager
> ect. an you can use with MSDE.
> Andras Jakus MCDBA
> "Dave" wrote:
>> I have an MSDE database that I want to be able to look at the table
>> structure and schedule backups.
>> Does MSDE come with a set of client tools?
>> If not, can I simply install the client tools from SQL Server 2000
>> Standard
>> Edition and use them with MSDE?
>>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end