Author: "Leonard, Christopher" <christopher-leonard AT UIOWA DOT EDU>
Date: Thu, 1 Jul 2004 12:02:22 -0500
John, This may not help you right now, but in case you're wanting to throw SQL Server out the Window because of this "feature," I thought I'd mention that this will change in SQL Server 2005. As othe
One of my users is trying to restore a 22 gig MSSQL database using TDP v5.2.1. The entire restore is taking several hours from start to finish and I have no idea why. I've watched the process and onc
Author: David Longo <David.Longo AT HEALTH-FIRST DOT ORG>
Date: Wed, 30 Jun 2004 16:05:21 -0400
The delay is that with large DB's, you have to wait for the DB file to be recreated on disk before it can be restored from backup. With only say a 1 GB file, it's hardly noticeable. They has been som
John, This is normal. SQL Server is pre-formatting the files in preparation for the restore. Data Protection for SQL restores a small bit of information that the SQL Server requires to properly set u