Did any of you ever get a resolution to this problem?

are you using the standard maintenance plan tasks or a custom script? at first i thought you were using the standard tools but then you mentioned about dynamically adding...

interesting, thanks Shinoj

interesting. what limit are you hitting? number of publications?

beejug1983 (8/6/2010)

---

Hi,

Is there any way to find out details of particular transaction. We can check current transaction ID in SQL 2005, but can we check the whole details of transaction...

try adding some logging on your agent job and output it to a text file, see how far the agent is getting and whether its running into any problems. ...

regarding how often you back up the t-log that depends on your environment. you need to ask yourself how much you can afford the log to grow, how often...

"Emptying"/backing up the transaction log makes the inactive part of the transaction log available again to store more transactions. so before a backup your active transaction log will grow...

one other point, using the send mail task just uses sp_send_dbmail in the background anyway, so if they already have the sql code you may as well just use it...

ask whoever maintains your mail server (assuming you have an SMTP driven mail service). if you dont then there are plenty guides around to use various web mail providers...

ive had database mail randomly change itself after a server reboot. normally using profiles where it will work for a period of time, then will start sending mails from...

thanks guys. ive used redgate sql compare before and trialled data compare but never used it in production. Ill have a look into that but will probably go...

Steve Jones - Editor (8/4/2010)

---

Honestly I think you'll end up wasting tons of time moving this data. I only think that custom SSIS type scripts will work here, and since...

Brandie Tarvin (8/4/2010)

If you absolutely have to do this, set up Transactional Replication down to your Dev environment to a non-Dev database. Back up THAT database every morning and restore...

Brandie Tarvin (8/4/2010)

---

Honestly, I think you're approaching your problem the wrong way. You shouldn't need live data *every* day to have a Dev database. And whether or not you script...