Truncate is minimally logged operation. Rows affected by truncate operations are not logged, however, the log contains info that a particular...

ColdCoffee (4/24/2010)

---

Nice thread, imho!!

Me born in , une fois par le territoire français (once a french territory) PONDICHERRY, in INDIA! 😉

And now working in chennai (again in INDIA) for one...

There is an options under control panel -> forum settings where you can save your own time zone. Then, u'll be able to see timestamps of differents posts in ur...

Ejacksonjames (4/27/2010)

---

Is there a way I can verify the backup from a central location by setting up a script that can run on each database that will create a report...

pls go through this URL.

http://technet.microsoft.com/en-us/library/ms190679.aspx

Are you taking backup to the local disk or SAN disks or on a network machine?

when u truncate tables in the source database; after the corresponding log backup is restored in secondary, those tables will be truncated as well.

Truncate is minimally logged command.

You have to register the SPN to the domain controller.

This URL should assist you in doing the same.

http://blogs.msdn.com/sql_protocols/archive/2005/10/12/479871.aspx

Remember to run the setspn command at domain controller. And a domain...

Why do you need us to prepare and give faq for mirroring? is that for interview?

Seth, I guess this is what the OP is looking out for..

I understand your concern of having less mapped drive size, however cant...

Danb7183 (4/14/2010)

---

I.e. if the size of the secondary server share was 1GB and the next transaction log copied to this share meant the overall size of the drive was greater...

You didnt reply to the second...

reddy06 (4/14/2010)

---

I am having a temporary table with 10 rows and 10 columns

I need to insert each cell into a new table.

How can i find the cell values like...

You can begin with Grant's article.

http://www.simple-talk.com/sql/performance/execution-plan-basics/