Thanks adi. Actually truncating log and log backup was taking place at the same time. Now it is running fine.

Hi Gail,

You are right. I am trying to figure it out...

Hi Gail,

I followed the same as described in your article.

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

We are taking log backup every two hour successfully. We can not take it to simple recovery mode because user wants...

I was installing a new failover cluster instance.

yes this is live cluster and there is already default cluster instance.

This is the log in details.

Microsoft SQL Server 2005 Setup beginning at Tue Jul 12 15:27:04 2011

Process ID : 8284

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe Version:...

Hi,

Actually I should have posted this in SQL server 2005 thread.

I am getting an error "Setup failed to start on the remote machine. Check the Task Scheduler event log...

No, I dont find any proper match for the database name.

It returns 2011-06-28 10:05:18.113

I ran the below query where log_35.trc is my default trace

SELECT * FROM ::fn_trace_gettable('C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\log_35.trc',default)

where TextData like '%drop%'

--I cannot find any drop statement here.

Thanks Gianluca Sartori and Gail

The database was deleted today and found the same from schema change history report. But unfortunately I cannot get it from the default trace. I...

Yes..I should post it in SQL server 2008 thread.

Are you using the same SQLUser as the one used for the remote connection ( is there a login trigger active ?...

@ALZDBA - I ran the query which you have provided. Infact it gives the same error.

@adi Cohn-120898

I have checked the SQL error log and it says "Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for...

Hi,

Please see the result below.

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit)...

I checked with the user and they are connecting the right server and instance.

But the backup will always have less size than actual database size. So can you please clarify if this calculation will give me the exact data growth?