Database drop ederken msdb kullandigi script icin index
Definition Description
USE [msdb] GO Aşağıdaki sorgu için oluşturulan index EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'SunmarOperatorProd' CREATE NONCLUSTERED INDEX [DBA_backupset_databasename_20141104] ON [dbo].[backupset] ([database_name]) INCLUDE ([backup_set_id]) WITH(ONLINE=ON) GO USE [msdb] GO CREATE NONCLUSTERED INDEX [DBA_backupset_database_name_20141105] ON [dbo].[backupset] ([database_name]) INCLUDE ([media_set_id]) WITH(ONLINE=ON) GO USE [msdb] GO CREATE NONCLUSTERED INDEX [DBA_backupset_media_set_id_20141105] ON [dbo].[backupset] ([media_set_id]) WITH(ONLINE=ON) GO