I have an SQL 2008 SP1 server (running on Win2k8 x64 SP2 up to date, Xeon 3Ghz and 8Gb RAM) with some user databases (~50, from 100Mb to 1Gb). As it's a production server (since almost 2 year), I have an "heavy" backup plan :
-from 8am to 8pm, every 15 minutes each base have a LOG backup
-from 8am to 8pm, every hour each base have a SQL differential backup
-at 3am every day, a SQL full backup is done
Those backup are done on a different place, thus is the datacenter is lost we are garantee to loose only 15min max of data.
Everything run great and I don't have any problem.
Now, I'm trying to remove one of the user database from this server. But it seems it cannot be done, as the msdb.dbo.sp_delete_database_backuphistory won't do the job. I've tried it this sunday, disabling my maintenance plan, it run for 5hours (100% CPU).
It just seems to be mark as 'RUNNABLE' on the activity monitor.
I've already tried to rebuild indexes on the master databases with no result. Also I found this post http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/9642d874-b311-48c9-80ce-71d758999368/ and so tried to to this maintenance (deleting old history)
but it does the same behaviour. Do I really have to launch this task at 9pm and wait all the night to complete ?
Lastly I w
View Complete Post