Antero Ruiz (6/12/2009)

---

2. It is in full recovery mode, we make log backups every 20 minutes, but immediately delete them because they are too big. We don't need point in...

developer team will never accept that major cause of poor performance is 'bad design'.

:doze:

auxinet07 (6/12/2009)

---

I have a requirement to carry out a Disaster Recovery of the SQL Server onto new similar hardware as part of a business continuity exercise. The new server...

can u post what command you're firing? Along with detailed error.

http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx

Also Read BOL (Books Online) for details.

without the trace running, i dont think its possible to track deleted data. Other method is you can write a trigger on the base tables that logs dml information in...

A subscriber can act as...

Even though it might not be of use in your...

Thanks for the clearing the doubts Gail 🙂

Simultaneously i was also going through http://msdn.microsoft.com/en-us/library/ms190692.aspx which helped too.

http://www.mssqltips.com/tip.asp?tip=1380

has lots of tips for disabling. u can use similar steps for enabling.

Gail, I'm little confused here. I think in bulk logged, all bulk insert transactions cant be recovered in case of failure or we cant restore to point in time. If...

Thanks for the explanation 🙂

doesn't maxdop=0 means use all available processors? or am i missing something here?

There are plenty of articles on internet that gives step by step guidence. to begin with you can start with BOL or Perry's article: http://www.sqlservercentral.com/articles/Clustering/65994/

go through this article

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