That is old, and it's not something you normally do. I'd agree with Michael's advice.

Can you check the recovery model and post the exact code being used?

Jeff Kelly-310227 (5/21/2012)

---

it's exactly as Gila mentions.

I'm currently testing this with IBM's svc flashcopy manager.

These types of specialized SAN apps are fully SQL aware and use VDI (same as Microsoft's...

I assume you have queries to get this data? If not, you'll need someone to help you write a query. If you have questions on that, post some DDL and...

Sorry for the delay: http://www.rmtechtrifecta.com/

How can you apply transaction logs to a running database? Forget about the snapshot, how can you apply a transaction log to a database that is running without ever doing...

Each time you post, you can set a new default.

Note that if you have the R2 or 2012 versions, they won't attach.

I tend to like the 2008 version since it has the Filestream stuff. If you don't need that,...

Enjoy! I'll be speaking downtown in Denver tomorrow at the Rocky Mountain Tech...

Perhaps for a holiday. Can...

TravisDBA (5/18/2012)

---

Steve,

Agreed, 12 is manageable for most users I think. 20 is just overkill and it is the default. You must also keep in mind that many of our users...

No way. What you are doing is saying, can I restore T-logs at any point in time to my production databases. That's what an OS snapshot is.

The answer is no....

Ray K (5/18/2012)

---

Been quiet here lately! How about we stir up the pot?

Let's see . . . how about the following hypothetical situation . . .

You're the manager....

Not 1999?

("we're gonna party like...

Hmm, I thought that Compare would work against a script. I see an option against source control, which doesn't help, but you can compare against a backup.

If you copied your...

The load would be when your backups run on the primary. What is the workload like?

Check basic perfmon (CPU, pages/sec, disk IO) while people are working, and then when...