Another reason is the unnecessary impact when the database needs to grow again

Ninja's_RGR'us (8/10/2011)

---

sebastian.rodriguez 21698 (8/10/2011)

---

Hi! i have the same problem that SSC Eights!, but a little bigger... i had a Log file of 1 TB,

i tried every single step of every...

Trying to figure out the issue...

- Is it a NAS drive?

- Is the backup location a compressed volume?

Hi there,

Are you backing up directly to a network location?

On second thoughts, it looks like it might do the job - Thanks again!

Thanks a mil Adi,

This isn't 100% what I was looking for, but is definately a step in the right direction, I'll play around with the counters & see if there's...

I think like their CRM product, clever sales people impress manangement with pretty reports & graphs.

But the business requirements are often more complex than what the application can handle...

Nice thanks,

I think it's probably best then set auto_update stats on & not worry too much about including it (stats update) in my maintenance plans.

GilaMonster (4/16/2009)

---

Update them. If you delete the statistics you're forcing SQL to recreate them when it thinks they're necessary. Doing so could adversely affect an important query.

Use UPDATE STATISTICS rather...

Sure, but when you have a requirement with a smaller latency, let's say 30 - 60 mins, it probably won't work either.

It's probably all down to the business requirement.

Nope - We just use SQL Logins

I would assume:

When the job starts - Users are disconnected & the restore job is the only process connected to the database (Single User).

While the job's in progress - You...

Hi there,

SQL Mail is deprecated. Try using Database mail instead.

More info on how to set it up & use it:

Setup:

http://articles.techrepublic.com.com/5100-10878_11-6161839.html

Usage:

http://articles.techrepublic.com.com/5100-10878_11-6164310.html?tag=rbxccnbtr1

For a SQL Agent job, you can send a mail to...

Hi Jerry,

Yes this is a 'valid' query - But for the size of the table & the complexity of the transaction, it shouldn't hold locks for as long as it...

Is there anyting else you can think of?