Question #1: I am looking for some opinions on using Restricted or
Unrestricted file growth for SQL Data and Log files. Please respond
with Pros and Cons of each. Is there a "Best Practice" or standard for
automatically growing files.

Question #2: Does anyone backup Log files to another server or do you
just keep them on the same server(assuming no local tape drive). I
manage a very large Informix database in addition to some smaller SQL
server Databases. The Informix database is setup to backup logs to tape
every hour (or when the disk log is full). However, our firm does not
do this with any of its SQL servers. They backup DBs and Logs to the
local HD and then use Backup Exec to capture the entire server nightly.
If there was a major disk failure on one of the SQL servers, they may
not be able to restore from the logs (on the local HD) and the Backup
Exec backup would only be valid from the time of the backup. What are
other firms doing?

Thanks.
Mark




Above email is for intended recipient only and may be confidential and protected by attorney/client privilege.
If you are not the intended recipient, please advise the sender immediately.
Unauthorized use or distribution is prohibited and may be unlawful.

MS Sql Server LazyDBA home page