Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

External Drive Died - Help Expand / Collapse
Author
Message
Posted Tuesday, July 9, 2013 8:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 29, 2014 1:51 PM
Points: 138, Visits: 370
Hi -
We have our product databases on a Raid 5 disk array mirrored to another Raid 5 disk array. However, we have (had) our "testing" database on an attached USB drive. It just died yesterday. Now I have have testing databases that I can't access and can't remove.

How do I remove them?

Thank you.
Mike Meer
Post #1471662
Posted Tuesday, July 9, 2013 8:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
Hm, take it offline and then delete the databases from SQL sounds about right just off the top of my head.

Gail may have a better answer..

CEWII
Post #1471666
Posted Tuesday, July 9, 2013 8:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 29, 2014 1:51 PM
Points: 138, Visits: 370
All,

It wants to "delete database backuphistory". This seems to be the issue. If I skip that, will I have issues later down the road?

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'xx_Training'
GO
USE [master]
GO
/****** Object: Database [xx_Training] Script Date: 07/09/2013 07:48:36 ******/
DROP DATABASE [xx_Training]
GO

Thank you
Post #1471672
Posted Tuesday, July 9, 2013 9:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
No, backup history allows you to more simply restore backups. Which you can do without backup history it just takes longer.

CEWII
Post #1471683
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse