Home / server / Questions / 391265
Accepted
Manjot
Asked: 2012-05-22 17:41:06 +0800 CST

MSSQL: running update usage after restoring database

  • 772

Why do we need to run dbcc updateusage(0) after restoring a SQL Server database on a different server? What are the implications of not running it?

sql-server

1 Answers

  1. Best Answer

    You don't need to run dbcc updateusage after you restore a database. The only time that you need to run this DBCC statement is if the output from sp_spaceused isn't being reported correctly or if some of the reports in SSMS (or third party tools) aren't showing the space usage for the database correctly.

    • 2