Skip to main content
added 27 characters in body
Source Link
Álvaro González
  • 1.1k
  • 5
  • 17
  • 32

I created a maintenance plan a week ago and it's been executing fine every night. Now the Database Shrink task has stopped working and throws this error:

Property Size is not available for Database '[master]''[foo]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.

Yesterday I installed a couple of SQL Server hotfixes offered by Windows Update (4411 and 4457, if that matters). It's the only change I've possibly made.

My task looks like this:

  • Connection: Local server connection (sa)
  • Database(s): All databases All user databases
  • Shrink database when it grows beyond: 50 MB
  • Amount of free space to remain after shrink (10%)
  • Return freed space to operating system

Some of my findings:

  • If I generate the T-SQL code and execute it manually it runs flawlessly.
  • If I create a new maintenance plan with an identical Database Shrink task it runs flawlessly.

What can the problem be?

I created a maintenance plan a week ago and it's been executing fine every night. Now the Database Shrink task has stopped working and throws this error:

Property Size is not available for Database '[master]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.

Yesterday I installed a couple of SQL Server hotfixes offered by Windows Update (4411 and 4457, if that matters). It's the only change I've possibly made.

My task looks like this:

  • Connection: Local server connection (sa)
  • Database(s): All databases
  • Shrink database when it grows beyond: 50 MB
  • Amount of free space to remain after shrink (10%)
  • Return freed space to operating system

Some of my findings:

  • If I generate the T-SQL code and execute it manually it runs flawlessly.
  • If I create a new maintenance plan with an identical Database Shrink task it runs flawlessly.

What can the problem be?

I created a maintenance plan a week ago and it's been executing fine every night. Now the Database Shrink task has stopped working and throws this error:

Property Size is not available for Database '[foo]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.

Yesterday I installed a couple of SQL Server hotfixes offered by Windows Update (4411 and 4457, if that matters). It's the only change I've possibly made.

My task looks like this:

  • Connection: Local server connection (sa)
  • Database(s): All databases All user databases
  • Shrink database when it grows beyond: 50 MB
  • Amount of free space to remain after shrink (10%)
  • Return freed space to operating system

Some of my findings:

  • If I generate the T-SQL code and execute it manually it runs flawlessly.
  • If I create a new maintenance plan with an identical Database Shrink task it runs flawlessly.

What can the problem be?

Source Link
Álvaro González
  • 1.1k
  • 5
  • 17
  • 32

Database Shrink task fails

I created a maintenance plan a week ago and it's been executing fine every night. Now the Database Shrink task has stopped working and throws this error:

Property Size is not available for Database '[master]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.

Yesterday I installed a couple of SQL Server hotfixes offered by Windows Update (4411 and 4457, if that matters). It's the only change I've possibly made.

My task looks like this:

  • Connection: Local server connection (sa)
  • Database(s): All databases
  • Shrink database when it grows beyond: 50 MB
  • Amount of free space to remain after shrink (10%)
  • Return freed space to operating system

Some of my findings:

  • If I generate the T-SQL code and execute it manually it runs flawlessly.
  • If I create a new maintenance plan with an identical Database Shrink task it runs flawlessly.

What can the problem be?