Re: Unable to detect USB ver Tape Drive on SQL Server 2000

a. I did test it on two different SQL Servers (computers), one on Windows
2000 server and another on Windows 2003 server. Both are unable to detect
tape drive on Enterprise Manager.

b. Yes, it works when using the Backup Database T-SQL command to backup to
tape.

Thanks.

(PS: I will be away from office for next few days. Will try to respond to
any advices as soon as i get back)

"William Wang[MSFT]" <v-rxwang@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:RBR1tr6rFHA.3604@xxxxxxxxxxxxxxxxxxxxxxxx
> I'd like to check the following to narrow down this issue:
>
> a. Attach the TAPE to another SQL Server computer and see if it's still
> not
> available in Enterprise Manager.
>
> b. Backup a database to the TAPE using the T-SQL command to see if it's
> possible.
>
> Please let me know the results of your testing. I look forward to your
> reply.
>
> Sincerely,
>
> William Wang
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>







.

Relevant Pages

  • Denying access to a server
    ... I want to deny access to our SQL servers from all computers except for ... specific computers. ... Is there a way to do this in windows with out having to ... use a router and ACL's between the SQL servers and the rest of the network. ...
    (microsoft.public.win2000.security)
  • List SQL servers in a network
    ... Most of the solutions use SQLDMO to list all sql servers in the network like ... public static string[] GetAvailableSQLServers ... - this does not work with Windows XP (see SQLDMO documentation: ...
    (microsoft.public.dotnet.general)
  • Re: Speed
    ... look at how much RAM is allocated to each of the servers via the ... server properties - even though each machine has 2GB of RAM, the setup may ... may be using resources contributing to system slow down of the SQL servers. ... >I test Sql server in three computers: ...
    (microsoft.public.sqlserver.setup)
  • MS03-031 Problems
    ... I manage several SQL Servers (2000 Enterprise Edition ... default instance and two or more named instances ... These servers run in a Windows NT4 ... I have found that if I configure the service accounts to ...
    (microsoft.public.sqlserver.security)
  • RE: Cross domain authentication in SQL 2005
    ... SQL Server Windows authentication works fine when the two domains trust each ... My concern is that if we add the SQL servers to domain B, ...
    (microsoft.public.sqlserver.setup)