I would guess what they mean is that if you're restoring log backups to get to just before some disaster (like a dropped table), you can restore with standby, query...

You can use SSMS on your workstation. Personally I don't feel that user apps should be installed on a server.

(no, it can't be downloaded, you'd install SSMS from the SQL...

what do you mean by 'inspection usage'?

How to apply what?

and what is the standby file, how to...

Yes, why not?

Am I right in that the 3rd phase (Undo) is where...

Typically used in log shipping when you want the secondary to be readable (restore with norecovery is not) and still allow further logs to be restored.

Yes, you could have. The DB was online and available.

The max server memory setting controls the buffer pool. That's all of the caches (buffer pool, plan cache, etc) plus the query workspace memory. SQL can and does take memory...

That's a UPS, not a storage device.

YSLGuru (1/10/2013)

---

Is it possible duing the restore to restore the DB so that it have a small amount of room to grow and not the full amount that the live...

If you're talking about a RAID array write cache backup battery, then you either must replace it or must disable the write cache or you are risking a corrupt database.

Start...

High memory usage from SQL is a good thing. SQL uses memory to cache data and to cache plans. Both of those allow for better performance than if it didn't...

DBCC ShrinkFile or DBCC ShrinkDatabase.

Well... the next step would be to figure out whether high buffer page usage by that object is a problem or not. If it's a large table that's frequently read,...

The update lock is held until the transaction commits or rolls back.

yes, providing all the tables have the same column. Not sure it's necessarily a good idea, but you can do it.