When I say warehouse application, I mean an application that runs a warehouse facility, not a data warehouse.

🙂

Yes, there was a little error in my description.

Thank you both for the info and links, I will read them and I'll decide what to do.

There is a warehouse application...

Before upgrading the server for our most productive client and put it on 64 and Windows 2008 R2, I have had the same problem, but, unfortunately, my OS was Microsoft...

In fact, it did failover, that's why that database was in "Mirror, restoring" mode. But both of them were in "Mirror, restoring", and the only event in log was on...

Please tell me how could I know which was the principal?

If you haven't configured it using Reconfigure statement, try again using:

SP_CONFIGURE “Max Server Memory”, 120832;RECONFIGURE;

Even if as far as I know, a restart is not necessary, if possible, restart again...

118 GB = 120832 MB and that's the value you entered in the Maximum Server Memory box?

Hmmm... I'll check why is this happening

What value have you written there?

Hi,

I have a question. After you set the max memory, have you restarted the mssql service?

I dont' know if possible, because I have nerver tested them, but have you tried:

1. to update the db files status in the sys.database_files?

or maybe you can read a little...

But... I'm sorry, I really don't want to be rude...I just want to understand.

I don't understand... the db is for 3 months in restoring? What happened?

Why haven't you panicate earlier...

To be more specific, many people are confused when looking to this info.

It is like that:

this is the Sql Server 2005 info:

Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov...

Hi,

This version: 9.00.4035.00 (X64) is not SP2, is SP3.

Hello,

Are you 100% positive there is no process working on that db?

Have you looked in Activity Monitor if there is no process there?

Have you tried to detach the db using

dbcc...

Ok, but in order to restart the activity (very fast, without knowing the reasons of the failure, just because the business needs to go further), all the steps described and...