Hi, Can you please let me know how to do those reservations in the system.

Hi Experts, adding to the above details, below are the error messages logged in sql server at the time of job failure.

The lease between availability group XXX and the Windows...

Check the fragmentation of all indexes by using sys.dm_index_usage_physical_stats.

If the fragmentation is more than 35% --Rebuild all the indices.

Ask the users about any change of code..? If so, Check for...

Your Windows Machine is 32-bit or 64-bit.

If 32-bit, Please Enable AWE. For 64-bit machines it is auto enabled.

If possible, increase the Virtual memory on your machine.

In 2005 it is not possible to encrypt the whole database. TDE is the feature which is available in sql server 2008 with this feature you can encrypt the complete...

Can anyone help me to sort out this issue.

Today i faced problem with this server, suddenly there is nothing executed on this server.

In Event Viewer i noticed the Error :...

Hello Mr.Jay,

Did u sort out this issue...? can u share the solution, am facing same issue.

TIA....

IF OBJECT_ID('tempdb..#CheckDB') IS NOT NULL

DROP TABLE #CheckDB

CREATE TABLE #CheckDB (LogDate DATETIME, ProcessInfo VARCHAR(50), [Text] VARCHAR(500))

INSERT #CheckDB

EXEC XP_READERRORLOG 0, 1, 'CheckDB'

SELECT SUBSTRING([Text], 23, CHARINDEX( '''',[Text],23)-23) AS DatabaseName,

SUBSTRING([Text], CHARINDEX( '2',[Text],PATINDEX('%errors%',...

I got a query, which results when DBCC CHECKDB was ran last time. so that i came to know it was executed yesterday.

No I didn't find any thing in errorlogs about DBCC CHECKDB.

DBCC CHECKDB was last executed on 2012-01-17(i.e., yesterday). But since 13/12/2011 there are no error logs..

Thanks a lot for quick response.

Autoclose option is set to false.Now i started profiler to check.

I can't find any thing from SQL ErrorLogs.

Thank you for your input,

In No Recovery mode i can't access the Database in QA.

Here the thing is i want to access and needs to do modifications in QA Database...

Duplicates are ok with my case and this is not Production Server. it is in DEV environment.

Temporarily data is in very less size and as of now am copying the data to QA Server according client request with simple insert into Statement.

Thanks for your input gail.

my requirement is exactly what u mentioned. i.e., i want to copy the new data which has changed(insert,update,delete in source Server) to Destination(in my case QA).

i...