How about

1. Using third party backup tool which creates compressed backup file.

2. Writing a stored procedure to take backup which will retry if the backup fails.

Yes.

Example:

create procedure spEmployeeUpdate

(

@EmpId integer,

@Name char(75),

@Salary decimal(8, 2)

)

as

update employee set [name] = @Name, Salary = @Salary where empid = @EmpId

Do you go to different clients site to fix when they have issues?

Or do you...

Thanks Terry for the link.

Thanks Mani Singh.

I restarted the SQL Server service. But it didn't get restarted. Status was "Stopping".

Non-administrator users were not able to login.

So, I rebooted the server.

Suresh

Thanks Terry,

Do you have the link?

Suresh

1. A simple example for BACKUP LOG command:

BACKUP LOG DatabaseName

TO DISK = 'BackupFileName.TRN'

2. Use Maintenance Plan schedule the job.

3. Third party tools are available which create compressed backup file.

4. Crosscheck...

Thanks to all those who replied.

Thanks to Mani Singh for the link.

Suresh

>>I get this exact message whether or not the job succeeds or fails.

I think, you have selected "When the job COMPLETES".

Change it to "When the job FAILS"

It is integer operations issue. Write as follows

(MostLikelyCost / 100.0) * MinimumPercentage

>> i am accessing through my .NET Application, that time its giving error like that, but if i am Executing any query from my Managememnt Studio then its working...

>> set @strsql=' SELECT *from history_view Where Send_by = '' &(@userid)'''

I think the above statement has problem.

Change it as follows:

set @strsql=' SELECT *from history_view Where Send_by = ''' + @userid...

declare @TableName char(50)

select @TableName = 'PING_' + left(convert(char(50), getdate(), 120), 4)

print @TableName

execute sp_rename 'PING', @TableName

>> why I was not successful when I assigned server name directly to Data Source parameter in connection string

In case of named instance, ServerName\InstanceName should be used. In case of...

>> So, is there a way on a production server to capture things like the deadlock graph without the Profiler running?

Yes. Using "WMI event alert" it is possible.