Now I'm more confused. We have 3 new SANs with replication for DR. I don't see how this helps me with point in time restores for a database....

TheAccidentalDBA (8/27/2014)

---

SSC-Addicted nice points and links. I posted two responses separately.Yes, totally agree on your points that its needs to be tested with restore. Logically, the following might work.

1. Only...

SSC-Addicted (8/27/2014)

I don't see any bug with Microsoft here, they offer a 3rd party interface to allow access to SQL backup for integrated backup solutions, but the ultimate responsibility for...

You got the second parameter for the db, so it looks good to me. I think the trace will catch something.

Does the procedure run a long time?...

I think the focus should be database centric because filegroups are database centric. Rather than arbitrary unique names across database, have a set of standard names to use in...

Are you checking the last_execution_time? Running a filtered trace will either confirm an issue or help identify how the procedure is being run.

Thanks for the responses. I'll ask operations to make insure 'Application Aware Image Processing' and 'Do not truncate' are selected. Are the strategies below valid? Are there...

BTW, a zero downtime application would be hard to design. You probably need to nail down the requirements to get at what the client needs rather than wants. ...

A magic merge? Perhaps an SSIS package to migrate last minute data? If only some activities cause issues and are okay to disable a short time, that would...

Thanks. We have a job to back up the transaction logs, so truncating them is probably not the option for us. Is this option only for SQL Servers...

That would explain it. The agent job information cached has to be refreshed. This is not done when using system tables directly. In addition, the supported methods...

I would have thought that the option specify an escape character or a literal string would have been added years ago. I guess it's not that important in the...

This might be fun to try. The number of quotes required is exponential with the nesting level. I used spaces, not tabs, in some places to help format...

One thing that I find interesting is that the escape character can be specified with a LIKE. I don't see why the same syntax could not apply to a...

I had also had this issue today on a test server (e.g., desktop). I've been defecting and re-mastering a lot. I changed my service account today as well...