I don't know. At that moment (I think an year has passed 🙁 ), I've looked in all the logs and it seemed to be a networking issue.

The witness had...

Yes, you're right, and it works if the database compatibility level is 90.

Even if I work with SQL Server 2005, because of the application, my dbs compatiliblty levels are...

Hi,

You find below a solution:

SELECT

com.IDAS ID,

com.FnameAS Fname,

com.LnameAS Lname,

com.AgeAS Age,

com.SexAS Sex,

com.LocationAS Location,

CASE WHEN EXISTS (SELECT '1' FROM tblCommon_tblSkills comski

left JOIN tblskills ski ON comski.skill_id=ski.id WHERE comski.common_id=com.id AND ski.id=1)...

Yes, my mistake... I should have said that the both db became mirror, restoring 🙁

Sorry

There were both of them with the status Mirror, Restoring

Unfortunately, It happend twice 🙁 and I don't really know why. I've looked in all the logs and the only idea I get it was that somehow the networking was...

Hi,

You can make a function which gets the profession name paramater and out an int (the porf id) and then make just un update in the person table,

Or... without a...

I've forgotten to say that's the reason I haven't been accepted to an interview where at the beggining before going to the face-to-face interview I had to describe ONLINE a...

Hello again,

Today...I realized that on the node with problems, the sql server version was 9.00.1399.00 (RTM) and on the other node was the sp3 version (9.00.4035.00)

I've applied the SP3 version...

I've just read the article posted by you.

I can't believe that in all this time I've lived with the feeling that after the log backups, the .ldf file size was...

ALZDBA, I have run the script provided by you and I've minimized my .ldf files.

My Production database is very intensive, so the .ldf file will increase and increase. In order...

That' what I don't understand. I knew that if the db is in full recovery model, a constant log backup causes its truncation, so... the .ldf file size decreasing. Am...

Yes, I have a log backup maintenance plan which is running from 45 to 45 minutes. It's working just fine. I have never had included in my maintenance plans, a...

In this weekend we've made the DB size something like 6G (from 23) and I'm reffering only to the data file (.mdf) because the .ldf file was constantly at a...

Thank you for your answers. I'll try to see what to do further.

The thing I can't understand at all is why till this weekend, when log backups were doing, the...