I have DBCC in the maintenance plan.

Where the DBCC output message log file will be created?

Log Ship will be insync once you follow steps.

I suggest, pl verify on test server for surity. We always do.

Jeffrey, Gila and Paul, Thanks for your response too.

RBarryYoung, Thanks for your response and article pointer.

Now it's clear to me that adding log file will not help. Will focussed...

Jeffery and Tim,

Thanks for your response.

Please note that

1. Log file is on it's own dedicated disk.

2....

NO NEED TO BACKUP AND RESTORE FULL DATABASE. Differential will do...

1. FULL BACKUP;

2. Let One Log Backup and Restore on Secondary;

3. DISABLE Log BACKUP (DO NOT STOP LOG SHIPPING, DO...

Thanks GURSETHI.

It works for Windows Account.

In my case I want to make it work for SQL Server Account. I mean SQL Authentication.

Follow these steps:

a. Click Start, and then click Run.

b. In the Run dialog box, type dcomcnfg.exe, and then click OK.

c. In the Component Services window, expand...

Enable Distributed COM on this Computer

Gail,

This is weekly maintenance plan and we run both DBCC command in the same job.

What do you suggest to run first? CHECKDB OR REINDEX?

For each table in the database, DBCC CHECKDB checks that:

Index and data pages are correctly linked.

Indexes are in their proper sort order.

So order can be DBCC Checkdb and DBCC...

RBarryYoung and Gail,

I got it 100 percent..... It's clear now.....:hehe:

Thanks

Gail,

Try Following:

USE MASTER

GO

CREATE PROCEDURE sp_ABC AS

print 'IS FROM Master DB'

GO

USE pubs

GO

CREATE PROCEDURE sp_ABC AS

print 'IS FROM Pubs DB'

GO

USE master

go

EXEC sp_ABC

go

USE pubs

go

EXEC sp_ABC

go

See the Output running from pubs database. My question...

Thanks and sorry for not reading your original post completely.

When it's doing clustered scan How can we check the time and reads of...

I agree with most of the respondent regarding Auto Update Statistics ON but I did not see any good reason to keep Auto Create Statistics ON on Production database.

Why we...