Sorry -forget to mention you can only mirror to one server.

Thanks

Imran

Hi Anil,

Please check out this link ; as its much detailed then my reply.

http://sqlserverpedia.com/wiki/Setting_Up_Log_Shipping_(SQL_Server_2005)

Thanks

Imran

Hi Anil,

In this mode the servers work synchronously; that means the principal server waits for a response from the mirror server. The mirror server then responds when it has hardened...

Hello,

This might be helpful for you .

In high-availability mode, you need all the three server roles: principal, mirror, and witness. In this mode, the transaction safety level is set...

Hi ,

Looks like your SQL Job is fine and trying to send the notification mail but your exchange server is unavailable or something wrong on that side.

The below link will...

Thanks for your Advice Gianluca.

Yes ;that what I have followed .Its Column Id's looks like maxed out. So I am doing an new table and check the max id which...

Hi Gail,

Your answers are really good.

Is there a way to check which update cause the problem and can it be rolled back. I know it happened on one of our...

To run SQL Server Profiler, on the Start menu, point to All Programs, Microsoft SQL Server 2005/2008, Performance Tools, and then click SQL Server Profiler.

If its there ; you can...

Hi Here is a query which I would use to get the Buffer Cache Hit Ratio informations.

SELECT

(CAST(SUM(CASE LTRIM(RTRIM(counter_name)) WHEN 'Buffer cache hit ratio'...

Hi Azhar,

I am not a guru but hers is the link below which might help you as some one get it resolved following the post.

http://www.developmentnow.com/g/114_2005_6_0_0_547448/Tran-Rep-Error-The-initial-snapshot-for-article-object-name-is-not-yet-available-.htm

Thanks

ImI

Thanks much. It really worked for me.Much appreciated.

Thanks for you advice.

It's resolved now. I have to re-ran the process. It was the indexes which were causing the problem so I have to drop the indexes and resolved...

Thanks Lowell

but I am doing it as below

WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [INDEXES]

ImI

Thanks Gianluca

Ran your query along with the script and

its coming back as

Internal object MB Space=43374.125000

Internal Object dealloc MB Space=0.437500

Any advice.

Thanks Again

1) It Drops the Table every time -the job runs and there is only one no clustered index on the table created.No I am not shrinking it again and again....