From a backup/restore perspective then, especially to try to restore a portion of a system to a certain point-in-time, is there

any reason to use Filegroups?

In this particular application, the only...

You mention a contractor gets involved when things go awry...........

Sounds like that person has a LOT of job security/work for the long future with these rules in place !!!!

Appreciate everyone's help.

I'm taking off for the day, so I'll look at this on Monday.

I'll pursue the RESTORE SNAPSHOT process. That sounds promising.

Their interface does allow you to create...

eVault Long story why we have it. It does do what we need, except for it...

Ok. I've read that process on various sites.

Since the software is generating a .mdf, .ldf, and then .bak files, I figured there must be a way to use...

I'd like the number column included as it helps people research the case.

Yes, I checked that before posting. Everything matches up. It is a varchar(10) column. We've not added any translation or other data manipulation on this...

It's a simple SSIS package with one, Transfer SQL Server Objects, for the tables in the database. We are copying all the tables in the given database. ...

Yes. That is correct. D

Data is stored into a XML data type. Want to return a resultset where the tags are the columns.

I do want to do this at run-time and I'd like to avoid passing a parameter.

In short, I'm considering a security type of stored procedures that other stored procedures call....

Thanks for the info!

Per auditor's requests, at our site we are going through and removing the use xp_cmdshell completely.

Some of the changes to replace the use of xp_cmdshell have involved a fair...

Bru,

No. If you stop and start the sql service, the system doesn't treat that as an unexpected stop so those settings do not take effect.

Doug

Is SQL3 just reading data, no updates?

If so, I wouldn't use Merge (as you say, there's alot of overhead, the Merge advantage from my experience is managing changes...

How does someone determine what is the best value for the -g option? Is it strictly trial and error?

I was hoping Microsoft or someone could give me recommendations...