Paul,

It isn't a silly question. Developers should not have that ability on Production. In fact, there should be a tight throttle on the # of people who do have production...

It's funny. This subject came up last night at our local users group. I'd never heard of it before then. Now you guys are talking about it on this thread....

Bulk-logged...

Who is responsible for the actual server, the physical box? Who installs the OS, monitors patch updates, and might install an anti-virus program on the box?

This is the person you...

jorge.torralba (3/18/2010)

---

I think the best solution for us will be database snapshots every 15 minutes. This comes with a price. Losing transactions between snapshots. But, restore time is just a...

CirquedeSQLeil (3/18/2010)

---

You only need to restore the Primary...

Be very careful about using compression & encryption on your database backups at the same time. These two tools don't play play well together and can hose your backup files.

To...

Do they know what tempdb...

shusta (3/17/2010)

---

So would it be safe to say that each night when this Full Mode database is backed up it's backed up in its entirety including the data in the...

Starterm,

Go ahead and start a new topic for this issue. Your problem seems to be different than the OP. The OP is having trouble making a File backup. Your problem...

jorge.torralba (3/17/2010)

---

Wasn't an app. It was a developer dba running a script that dropped the tables. Thought I could go back in time to a point without having tio restore...

Glad we could help.

Please answer the other questions so we know what you've checked and what you haven't checked. Otherwise, we can't help you further.

Your post is a little hard to read, so forgive me if I don't quite understand the problem.

Is it just Maint. Plans that are taking forever or is it all...

parthi-1705 (3/17/2010)

---

I am having a 30 million records i need to delete 25 million old records with minimum log how it can be done there will be continues users accessing...

That's actually a pretty good idea. The only thing to keep in mind, though, is that it will potentially stripe the data across the files or shove them all in...