July 9, 2013 at 8:43 am
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
July 9, 2013 at 8:46 am
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
July 9, 2013 at 8:54 am
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
July 9, 2013 at 9:05 am
No, backup history allows you to more simply restore backups. Which you can do without backup history it just takes longer.
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply