Thanks Gail. It worked.

GilaMonster (1/23/2012)

---

You can restore the full backup WITH STANDBY, that makes the DB read only (as opposed to completely inaccessible as with WITH NORECOVERY), you can then query and investigate...

I was going to rely on someone else to do this but I want this to happen sooner rather than...

So what is the recommended way of getting out of this situation?

Somehow I have the last Database to be restored in a restoring state.

I can't restore it until the compression...

Nothing relative to this issue.

I tried taking the Databases offline.

I got an error but I was able to restore both databases.

I have moved 17 of 18 Databases.

This is the statement that I ran,

RESTORE DATABASE DataArchive

FROM DISK = 'I:DataArchive_backup_201201201349.bak'

WITH REPLACE,

MOVE 'DataArchive' TO 'D:\SQLServer\Data\DataArchive.mdf',

MOVE 'DataArchive_log' TO 'D:\SQLServer\Log\DataArchive.ldf'

In progress, thanks.

Thanks for the hint it was definitely IO related.

I did not find any entries in the Event Log but...

gweiho4xd2 (1/20/2012)

---

Hi,

I've tried using the 'sa' login and another login which had been working fine for years. The permissions for the other login are:

public

db_ddladmin

db_datareader

db_datawriter

I can access the data via ODBC...

The SSIS Packages are dynamically generated every night based on the values in two Databases.

I really don't have to worry about it because CSC owns this process but thanks for...

I take it that you are going to tell me that it can't be done if the SSIS PAckages are...

Thanks, what are the steps?

waittypewaittimelastwaittypestatuslogin_timelast_batch

0x00622028234ASYNC_IO_COMPLETION suspended ...

Grant,

Thanks. What is weird is I executed the jobs to perform...