U can use SSIS PACKAGE for fetching data in csv format and save it to a location which u want

For Database what profile name who have made mention that.

EXEC MSDB.DBO.SP_SEND_DBMAIL

@PROFILE_NAME = 'XYZ', ...

use this in the job step while executing

EXEC MSDB.DBO.SP_SEND_DBMAIL

@PROFILE_NAME = @MPOFILENAME, ...

Use the following command:

SELECT file_id,name ,size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS AvailableSpaceInMB

FROM sys.database_files;

after this command u will find the file id which has free space then run DBCC shrinkfile(file...

It is possible to run SQL Server 2005 and 2008 instance on Two Node Cluster.

What is ur drive size in which your log files are and what is the size of the Database that is being logshipped.

TUF file is created when configuring log shipping in Standby mode.All uncommitted transactions are recorded to the TUF file while restoring the log backup into standby database so that users...

It's the undo file that is needed to keep the secondary server in the read-only state and if you use the norecovery instead, you wouldn't have that file on the...

run the dbcc checktable with repair and rebuild option and with error msg.

this can done the page repare in database.

this will retrive all the data without data loss. i...

This can be achived by following command

Restore log test

from disk='I:\Test_logshipping\Test_20120228055827.trn'

with move 'logical name of new file'to 'Physical location on DR where it will be placed',norecovery

No there is no such error.

Do we need to enable any trace flag for that so that its is visible in the errorlog

There is nothing in the errorlog prior to running checkdb which can help us.

We are running check db through maintanence plan.

I am unable to find any thing in the error log because the DBCC CHECK DB did'nt complete before completing it gave the above error...

It got resolved by changing VCHMESSAGE VARCHAR(800)

to VCHMESSAGE VARCHAR(max)

We have alert set virtually for everything but that day it didn't run due to sql server agent issue.

The error we got on sql server agent log was :-

SQLServer Error:...