Just a suggestion...

Get used to using Query Analyzer for performing most of your DBA tasks.  Not only will it increase your knowledge of the database, it will also give you...

Joe,

If you need encryption for the transfer (which may be excessive, but only you know your security requirements), then you have to use Secure http://FTP.   I'm familiar with...

I guess it depends on a variety of factors:

1. What's the size of the client db?
2. What are the security requirements (authenticated access, logging, encryption, etc).
3. What is the availability timeframe on the...

I have to agree with Mark.  You just won't be able to sustain the I/O required with a NAS.  For more info, check out this article:

http://www.sql-server-performance.com/ew_san.asp

Adam

John,

Thanks for the input.  I'd love to hear more from your friend if he has the time.

Adam

An excerpt from a webchat transcript:

MS_Stephen_D:

Q: gaurav_bindlish: Still I am asking if there is some tool to release the memory immediately.

 

A: No, SQL Server is designed...

Good point - we actually perform this process during our weekend maintenance window when user volume is quite low.  Acceptable risk?  maybe...

Our backup scheme includes 15 minute tran log backups. ...

There is a great article by Bill Wunder on DBCC INDEXDEFRAG and DBCC DBREINDEX.  He touches on transaction log growth.  See http://www.sswug.org/see/18075

Personally, I built a series of sprocs...

You should be able to decrease the size of your transaction log significantly by using QA to execute:

BACKUP LOG <db name> WITH TRUNCATE_ONLY

then

DBCC SHRINKFILE (<file name>, <size (mb)&gt

FYI - there is a great article on this site by Brian Knight.  It may save you a RESTORE next time.  See here:

http://www.sqlservercentral.com/columnists/bknight/unmarksuspect.asp

Adam