Sorry, Steve. I did find the Recent Posts link under My Account in the second row. I wonder why you duplicate the My Account button.

I tried the Recent Posts, it...

Thank you for the clarification. Now I understand that your query copy is the 'production' database and 'attach' did work better for you than the restore. I think you still...

I am confused about your scenario. Are you refreshing a production copy with a development copy? Why do you copy it to two separate machines?

To make a warm stanby of...

Steve, I don't see Recent Post under My Accounts. Logged out and logged back in.

Thank you very much for your help.

Sorry, I found the thread about the same issue I posted before. See, the problem does cause duplicate postings...

Thank you very much, Mark, for the infor.

Backing up to multiple devices, will I be able to combine them into one data file and one log file during the restore?

I don't think so. When the transaction log is full, your database will not be operational which is why you can't access it through EM...

Thank you for the quick response, Bill.

Will the following three things do the same trick?

1. Restore ... WITH NORECOVERY

2. RESTORE ... STANDBY

3. Enterprise Manager - Restore Database:

Leave...

Thank you, guys, for the helpful input. I already did a full restore of the database in the EM, which took 5 hours. Can I get around it without another...

Also, to apply the differential backup, do I need to restore the full backup in a special way? Thanks.

The update is to change value in a column. The row count will stay the same. Isn't it?

Thanks.

Thank you, Allen, for the input.

You are right, Mark. My QA window is connected to the db not master. It worked.

Thanks again.

I did kill all connections before the restore. I have to have one query window to issue the command.

The destination is in Warm Standby mode. How do you get the...

Please Help...