FunkyDexter (5/9/2012)

---

Speaking as a relative newcomer to the forum I find the point per post system a bit flawed in that it encourages garbage posting. I find this to...

Yep. I did it with 30 or so files.

Someone more knowledgeable regarding the tlog is welcome to help here.

Yes, this is quite possible.

drgn38 (5/8/2012)

---

Hello Lynn,

Sorry I am having issues finding the link do you happen to have that. I would love to take a look to see the proper way for writing...

philgee (5/8/2012)

---

Here would be an example of the table. I reworded my originall post so that hopefully it is a bit clearer.

The table is fairly simple. Be a...

Were any large tables truncated during the time the t-log backups were disabled?

Full backups (and differential backups) do not truncate the transaction log. The only way to manage the size of the transaction log is by running t-log backups. I...

Paraphrasing now based on your expected results. If the data starts and ends within the timeframe, plus if it starts within the time frame or ends within the time...

drgn38 (5/8/2012)

---

Thank you for your reply Lynn.

I already was as the Server and DBNames are passed in dynamically in a looping process. I guess I could do try to...

drgn38 (5/8/2012)

---

Hello All,

I have taken it upon my self to build a client configuration database for my company. This is meant to be an automated discover process where all you...

Actually, log compression for the data transfer between mirrored databases is designed to increase throughput of data between mirroed databases as more data can be transmitted in each packet. ...

Based on your sample data, what should be returned by your query?

Would help to see what you are talking about. Please read the first article I reference below in my signature block. Following the instructions in that article will...

madhu-686862 (5/8/2012)

---

Sean,

I executed the below code as you suggested and I'm getting the below results in SSMS

declare @Delete int, @Update int, @Insert int

DELETE FROM [dbo].[DATA_EWT]

...