Skip to content

SQL Server Faq

  • Home
  • About
  • Archives
  • Contact
SQL Server Faq

restore time

Performance | SQL 2012

Impact of Pre-grown Data & Log Files on the Restore Time of the Database

Today, I was asked the following question by one of my colleague who specializes in Sharepoint If the actual data is 50GB in size & if we create a pre-grown data file of 200GB to avoid autogrow & fragmentation, the database restore time for the pre-grown database should be much larger than the restore time…

Read More Impact of Pre-grown Data & Log Files on the Restore Time of the DatabaseContinue

© 2023 SQL Server Faq

  • Home
  • About
  • Archives
  • Contact