opc.three (9/7/2012)

---

Taking a differential backup from the primary and restoring it to the secondary will re-establish your log chain, just remember to supply the proper option on the restore (STANDBY...

You are welcome!

webtomte (9/6/2012)

---

We have SQL 2008 R2 (x64) on MS Server 2008 R2 with all the SP including SP2 for SQL Server 10.50.4000.

This is a new server and we started using...

I think Gail gave you already a great answer....

jjohnsqldba (9/7/2012)

---

Hi,

We have a log-shipping set up on the production server for reporting purpose.

Unknowingly, I have set up a backup strategy which also includes trans-log backups.

So, my log-shipping failed. Restoration...

You may find this link very interesting "http://blog.sqlauthority.com/2011/02/01/sql-server-introduction-to-wait-stats-and-wait-types-wait-type-day-1-of-28".

If you would like more info on the default trace, you can check this link "http://ignaciosalom.com/2012/02/08/the-sql-server-default-trace/".

Could you please provide more info. If you want to see what is going on your Server you can use the dynamic management views.

jitendra.padhiyar (5/15/2012)

---

Hello Masters,

During upgradation, all the user database will be upgraded to new version, but what will happen to system databases and Scheduled tasks and jobs? How would we upgrade...

I'm glad I could help! 😉

_nzrdb6 (5/8/2012)

---

Hi everybody,

I need to audit all DBA activity on an instance but I'm not sure what the Server Audit Specification should look like. Does anyone have an example...

pawana.paul (5/8/2012)

---

Hi,

Any way to find last table updated inforamtion. I think, we can use triggers or enable auditing. Please let me know any other option like sys tables or dynamic...

Duran (4/16/2012)

---

Hello,

In case anyone out there has the same issue, I dont want them to get to the end of this thread and find no resolution, so I'll just say...

Duran (4/12/2012)

---

Hello,

I think the SPID is blocking up the Tempdb database, I'm wondering if perhaps I need to just restart the instance to get round this. If I run DBCC...

Excuse me for not replying before. Don't you have an old backup of that database? If you do, try restoring the most recent backup on another server and run DBCC...

Try restoring the database to another Server and run the DBCC checkdb there!