Friday, February 17, 2012

DB in Loading State

There was a restore script executed against a test
database that failed and left the database in loading
state. I fixed the restore script and executed it again.
I need confirmation if this is alright. I noticed the
MDF and LDF files date changed to the current date.
This looks ok as now restore works. Whenever the restore operation fails the
database is shown in loading state.
"J Lee" wrote:

> There was a restore script executed against a test
> database that failed and left the database in loading
> state. I fixed the restore script and executed it again.
> I need confirmation if this is alright. I noticed the
> MDF and LDF files date changed to the current date.
>

No comments:

Post a Comment