Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL2000: SP1 installed, now can't find backup device

Status
Not open for further replies.
ShackDaddy

ShackDaddy

MIS
Joined
Sep 20, 1999
Messages
3,824
Location
US
I have a clustered SQL2000 installation in an Active/Passive configuration. The node that is usually active has a Quantum DLT drive in it. Prior to installing SP1, the DLT was configured as a backup device within SQL and was used regularly for scheduled backups. After the Service Pack installation, I can still see and manipulate the DLT within the OS, but SQL can't see it, and jobs that try to use the virtual backup device fail. I've deleted my backup device assignments to start fresh, but SQL can't find the DLT to make a new virtual device out of it.

Any ideas, short of rolling back the SP install?

ShackDaddy
 
Status
Not open for further replies.

Similar threads

how2trainyourdragon
  • Locked
  • Question Question
SQL Server 2016 to 2019 now SSRS Cannot create a connection to data source
Replies
1
Views
593
how2trainyourdragon
how2trainyourdragon
Lidias13
  • Locked
  • Question Question
Issue trying to find "closest" dated record to a rather complex query (not working)
Replies
1
Views
409
ggriffit
ggriffit
bmacbmac
  • Locked
  • Question Question
Help with RegEx to find non alphanumeric characters
Replies
1
Views
2K
ggriffit
ggriffit
Olaf Doschke
  • Locked
  • Question Question
backup strategy
Replies
0
Views
217
Olaf Doschke
Olaf Doschke
EM1107
  • Locked
  • Question Question
Find missing level number in dable.
Replies
7
Views
367
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top