Backups don't contain the empty space, so shrinking won't help, and is detrimental to the database due to the fragmentation it causes. Your indexes may now need to be defragmented.

After...

Can you schedule the 2 jobs so they don't conflict ? If they are both EOD jobs, maybe they should run consecutively ?

For my large tables, I reorg/rebuild indexes one at a time in a script, with t-log backups inbetween.

Grant Fritchey (9/22/2010)

---

You can run it for 24 hours, you just have to be prepared for the fact that you're going to get a whole lot of data. Plan accordingly,...

I agree with Jeffrey. I have a folder with all the trans log backup files for various databases, even up to a week. Yes, there are many thousands, but who...

Can you be more specific about what you want to do ?

How frequently is your subscriber pulling updates ? I think if you set it to "continuous" you should get fast deletes at server B

(I've been away from replication for...

A view is not a table. Views can be complicated, joining multiple tables with 'where' clauses. They need to be well written just as a query does.

I think there have been some scripts and threads posted here before.

I would not suggest just arbitrarily killing a job after 10 minutes. You might cause worse problems for your...

ColdCoffee (9/18/2010)

---

Varinder Sandhu (9/18/2010)

---

found the solutions...

actually if the tables lie in different dbs

then create temp table in db X that contain the data of tableB from db Y

this...

I think the default is blank, but it seems to "remember" from previous backups. I've found that sometimes the destination and file name is already there and I need to...

Bhuvnesh (9/17/2010)

---

instead take backup with datetime suffix and delete the...

I found a freeware gui to use for scheduling jobs in Express ... works fine.

http://www.lazycoding.com/products.aspx

sqlbuddy123 (9/16/2010)

---

This would most possibly have occured due to a single large transaction. If you can find the time period during which this happens, you can either use a profiler...

So, without a trace actively running at the time, I guess there's no way to find out what was running ? A tool like Apex Log reader: "can show...