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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Deleted database device.

Status
Not open for further replies.
c4sob

c4sob

IS-IT--Management
Joined
Mar 6, 2001
Messages
10
Location
US
I have a database that I would like to drop but at some point the device for this database was physically deleted from the file system.
I've tried all sorts of things but it doesn't seem like Sybase will let me do anything with this database.
Is there a way to manually go in and delete this database?

--Charlie
 
Sort by date Sort by votes
Hi,

You can use dbcc dbrepair(databasename,dropdb) to drop the database name.
 
Upvote 0 Downvote
Hi,

You can use dbcc dbrepair(databasename,dropdb) to drop the database name.

Regards
suchetan
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Tim1988
  • Locked
  • Question Question
Setting up access Database
Replies
1
Views
287
SkipVought
S
SQLScholar
  • Locked
  • Question Question
Advantage Database Server
Replies
1
Views
326
SQLScholar
SQLScholar
mgupta10
  • Locked
  • Question Question
How to import source definition from MYSQL database?
Replies
1
Views
321
rasETL
rasETL
davidoptini
  • Locked
  • Question Question
Script for XML database updates?
Replies
0
Views
196
davidoptini
davidoptini
roatanbuzz
  • Locked
  • Question Question
DataStage connect to remote UniVerse database
Replies
0
Views
222
roatanbuzz
roatanbuzz

Part and Inventory Search

Sponsor

Back
Top