Transaction Log Backup

Hi Sabina,

What version of SQL Server are you running? You can get the specific version in SSMS. For example, 10.50.2500.  

From what I can tell from our servers running 10.50.2500 (SQL Server 2008 R2 SP1), the sysmaintplan_subplans.msx_plan column is configured to have a default value of 0. In that kind of situation, the error you are receiving should never occur (unless the INSERT statement explicitly tries to set msx_plan to NULL).

You may want to check the column properties. If it is set with a default of 0, then the error message you are receiving may actually be pointing to some other issue. If the column is missing that default setting, then there may be some repair needed to get those tables setup properly.

Here is a screen shot to show what I’m referring to:

Thanks,

David

_______________________________________________________
David Frederick
Database Applications Analyst
Segerstrom Center for the Arts
600 Town Center Drive, Costa Mesa, CA 92626
T (714) 556-2122 x 4067 E DFrederick@SCFTA.org

Hello,

I am so lost .... After upgrading TEST database to Version 11 Weekly Transaction Log Backup was throwing an error.  I deleted the job and trying to create a new Maintenance Plan  for Transaction Log Backup using a Maintenance Plan Wizard.  At the very end I am getting the following error :

'Cannot insert the value NULL into column 'msx_plan', table 'msdb.dbo.sysmaintplan_subplans'; column does not allow nulls. INSERT fails.'

The Plan is still created but it not working : )  Any help would be appreciated!

Thanks,

Sabina

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!