Well if the transaction log file is increasing it means it needs that much of space. You can shrink the log file but, your log file would increase anyway.

How...

http://technet.microsoft.com/en-gb/library/cc966500.aspx

That's an abuse:-D.

Transaction log file is such an important part of a database. Even...

As Grant advised, chose non- clustered indexes only when needed.

Have you got any clustered indexes on your table? First start of creating clustered index and then build any non clustered...

Hari (3/27/2009)

I had created a Non clustered Index on a table on 12 Fields and other 23 tables, as the existing retrieval was slow, anticipating the increase in speed.

Before applying...

Let me give a shot too:

1.) There should...

My pleasure 🙂

Oops not a good forum etiquette:-D. only English please 🙂

Oh! you have got hat error already saying "Primary and secondary servers are out of synch". what happens is, if you take log backups separately breaks the log chain and...

Have you checked the link I provided? Similar problem discussed there.

Is this not the job created when you have setup logshipping with a latency of 15 mins...

Silly 😀

From here>>>>>>>>>>>>>http://msdn.microsoft.com/en-us/library/ms130214(SQL.90).aspx ...

Is this a Production or Test environment? Restore...

Are you setting up this job on your local server?

Check this out, similar problem discussed here:

http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/12181324-bc51-41a5-a8a5-608bfe2725e9/

and Why do you want to do this anyway:-P? That's a disaster.