Hi,

Use below like..

DB INSTANCE NAME :- 10.120.X.X,1433

or

DB INSTANCE NAME :- HOSTNAME,1433 (If you use default instance)

DB INSTANCE NAME :- HOSTNAME\INSTANCENAME,1433...

Hi,

I believe you gave different DB or they may be using different DB. Check it..

Hi All,

I have done on 1st passive node successfully and when i doing on 2nd passive node (mean move passive as active) struckup in on...

Hi,

I have tried run as Administrator but login failed..

Now i fixed the issue.

Stop the all services except SQL Server (MSSQLSERVER) --> Right...

Hi,

i belive your are shrinking the log file through query if no do it is good practice.

1st check the checkpoint than shrink tlog file through...

Hi

I have faced same issue after updating SP.

When the Database take offline and back to online its work fine...

Thanks Kevin... Its working fine...

Hi Gail,

Same query using which i shared, could you current me if i wrong or advice me which query shall i use..

Thanks

Satish

Yes, go with the up-gradation easy and best solution.

Hi Sushil,

Why you will not going with SQL Mail Alerts because when ever job will fail you get a mail and...

Hi Salone,

This is the Production server, using SQL server 2005 & Mirror configuration with SP2

Thank You...

Satish

Hi Sumanth,

Thanks for your replay but i didn't understand that. Will you explain me please...

Satish

Hi Gilo,

Same thing i told him, i will take a tail-log back up...

He asked me syntax...

tail log backup dbname to dish = 'path'.....this is my answer

but...

Hi,

But it will restore upto 9:00 PM, what about my last 5 min backup.....

Hi,

1st check the correct instance name or try from Ip, check all SQL services, if not started start the services or once you restart the server....it...