Solved

Reindex error -1073548784

Posted on 2014-11-19
2
151 Views
Last Modified: 2014-12-03
I am getting the following error with reindexing a sql database any suggestions?

This is the error I receive in the maintenance plan.

Thanks!
0
Comment
Question by:cobp
2 Comments
 
LVL 49

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 total points
ID: 40452489
Did you check the error log?
Also check if you have free space available on disk.
If you find nothing then run a DBCC CHECKDB on the database.
0
 
LVL 40

Accepted Solution

by:
lcohan earned 250 total points
ID: 40455567
Maybe just not sufficient disk space?

Please see: http://blogs.msdn.com/b/repltalk/archive/2011/09/25/update-statistics-fails-with-error-number-1073548784-quot-could-not-allocate-space-for-object-dbo-sort.aspx


<<
It sounds like TempDB is not large enough on that system. I would suggest running DBCC CHECKDB WITH ESTIMATEONLY to see how much TempDB space CheckDB thinks it needs. That should be more than enough to cover the spill from sp_updatestats.

In general, I try to steer people away from maintenance plans for things like this. My preference is for each database to get a reindex job using a script that first checks for fragmentation before reindexing to save on time and server resources. There are a number of really good scripts out there that do this. In the reindex job I also like to run sp_updatestats as a second step to update only the statistics that need updating. Finally, putting each database CheckDB in a separate job and logging to a text file makes it incredibly easy to chase down CheckDB failures when they happen. You get the exact database with the failure and the complete log every time where maintenance plans can lose some of that data.

>>
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question