What edition of SQL Server is this? If it's not Enterprise, you can't restore Primary and then get people working while you restore other files.

I have heard this advice before,...

Apologies. I was unclear.

That's good to know, but more about what connects to what, and for what purpose? How does this application work?

Are you thinking this is a series...

Alvin Ramard (1/12/2011)

---

Don't...

Make sure you dig in and understand what happens.

Also realize that when the CIO says "shrink", he doesn't necessarily mean "run dbcc shrinkfile". What he means could be "make sure...

You have to have primary available, and then you can restore another filegroup.

So if you have your db at 5:00pm. Some things in Primary, some in Reporting. If you have...

If it is subsequent actions, you would schedule a few log backups to clean it up. The reindex will be one large logged operation.

Nice memory

I tend to agree that you don't want your SQL Server exposed directly. Can you explain a little more on your setup?

Nope, everything is written to the transaction log. Even index rebuilds. This is so if they fail in the middle, they can be rolled back and maintain an intact index.

The above answer is correct. Shrink is not part of backup, and you should not shrink to a point below that which you need for maintenance operations.

How much data do...

Excellent. Don't get too technical, don't use too much T-SQL/BOL style of explanation. Think junior DBA, secretary trained to handle basics, and explain in a simple way what to do...

cold

254K this morning

Koen (da-zero) (1/10/2011)

---

Brandie Tarvin (1/6/2011)

---

Jack Corbett (1/6/2011)

---

I also want to encourage all you who are PASS members to opt-in to the session voting for SQLRally. See my this post...

Doh!, can't believe I didn't catch that. Fixed.

Excellent explanation, Ed. This would actually make a great article if you wanted to write it. I wasn't aware of the UAC issue for local administrators on W2K8.