Clever Geek Handbook

SQL Server 2008 maintenance plans Failure because database is in use

I have created a couple of maintenance plans for our Sql Server 2008 databases that do backups (full and differential) to run overnight, but they keep failing with the message that the database is currently in use.

We generally have little traffic when maintenance plans are planned, so I'm not sure why I am getting this error. Is there a command I can add to the maintenance plan or a configuration change I can make to the plan (s) to allow the plans to run?

Thank.

0


source to share


3 answers


One of my databases seems to be "stuck" in a recovery state. Removing this database from the plan seems to have taken care of this. Now let's find out what caused this database to "get stuck" ...



0


source


I can speak for 2000/2005 and state that the database is not being used under backups. Are there other maintenance steps that might be causing this? Have you configured the maintenance plan report / logging options to write to the log file? This may provide a little more information.



+1


source


If there is little traffic during maintenance plans, you must take your database in read-only mode or turn it offline, all transactions will be suspended while you can take a backup. it is exactly the same.

0


source






More articles:


All Articles