Sorry, wrong tick on the answers. This has been corrected and points awarded back.

The question has been edited to say in-row storage.

My opinion is that looking at LOB storage is storage outside the row, and it shouldn't be used in terms of...

Nice

It would need enough space, but you're not necessarily backing up the entire server. It doesn't really make sense to back up anything other than the database and log backups...

The contractor is not a bad idea if the workload is large. And you'd want to think about this creatively. You might hire a contractor to do someone else's job...

Wow, you are very welcome, and I appreciate the comments.

Note that it wasn't all me. Andy Warren and Brian Knight started this site with me and worked hard for years...

Glad to see that there are places that recognize the value of teamwork and that need for people to pull together. I'd like to think it's that way more places...

Other responses here: http://www.sqlservercentral.com/Forums/Topic535907-359-1.aspx

Please do not cross post.

I agree with Jeff, we're happy to help, but we'd like to see a try.

GROUP BY, maybe include a HAVING clause for the COUNT() of records for a patient.

Schemas are a way to separate out objects and assign permissions. You could have all stuff moved into one of two schemas, which would make production administration easier.

You still have...

I think you need CONTROL permissions on the table (or all the tables) to do this.

I'm not sure how you can do this directly in SQL 2000. You could setup...

Most backup solutions only attach to one server and you send files from other servers to that one, or there is a backup agent that moves files.

Arcserve, Veritsa, BMC, all...

You don't connect SQL Server to VSS. You would need to manage this from your clients.

If you are new to VSS, you should spend some time learning how it works....

I think I had an HP jukebox, circa 95, and it was always flaky.

I'm not sure the cost of storage drops to make up for the cost of storing...

If the MDF file is corrupted, and you're sure, first make a copy of it and the LDF files immediately. That way someone can help you. If you can run...