That make sense.

Anyone can answer these kind of questions right by just cut and past to their SSMS

Zach,

The research looks great and the article is nice explains itself very good. In SQL Server or any RDBMS partitioning large table helps in many ways and batch processing always...

Thank you so much.

Where can I read more about it?

Here is the code... (I try to post it yesterday, no luck)

CREATE TRIGGER dbo.MyTrigger ON dbo.MyTable

FOR INSERT, UPDATE AS

BEGIN

Set Nocount ON

--AUDIT NEW RECORD.

INSERT INTO TrackingDB.dbo.TrackingTable (

Col1, Col2, Col3, Col4

)...

Hi Guys, Thank you for your help. I have resolved this issue by use "SET NOCOUNT ON", it was my first step to try to make it work and it...

I have used Quest Spotlight for a long time. It has saved lots of time and many times it help me fine tune the server very well. Many companies have...

Well, we continue to google it and able to bring it back the database again without log files. It took 2 hours to bring the database from suspect more live....

Thank you for the detail answer that helped me a lot, now I understand where did I drop the ball.

Noep, I did not do that... I just added a file and modified the existing one. That did not take any effect. My biggest concern is why the physical file...

Log Files can be more than one according to BOL. At least one is a must.

Steve,

Thank you for the reply. I am trying to use FG to reduce the size of backup and restore that's all. In this way I can keep loading one particular...

Steve,

I agree with you, mirroring is the good idea to setup a secondary read only database. Log shipping could be other choice but you cannot access the database while logs...

Well, Thanks for the reply. I understand the transaction log back up and restore. I am wondering if I can do that using Online File Group Backup and File Group...