Re: SQL server backups
2003-09-23 14:11:17
Thomas,
Take a look at DP for SQL "/STRIPes=numstripes" option.
DP for SQL allows you to send separate streams called stripes.
This is normally done for performance reasons, but could
also be used for splitting the backup into smaller objects.
SQL 2000 allows up to 64 separate striped objects.
For more details, take a look at the DP for SQL User's Guide:
http://publib.boulder.ibm.com/tividd/td/StorageManagerforDatabases5.2.1.html
Thanks,
Del
----------------------------------------------------
> My company has a Windows server supporting a very large SQL Server
database.
> Before the last hardware upgrade, the database was backed up with the
SQL
> Server Connect Agent. Since the upgrade the database has been dumped to
a
> flat file which is then backed up by the backup/archive client. Either
way
> the backup arrives at the TSM server as a single file containing about
> 20 gigabytes of data. A single file this size causes a number of
problems.
> The recovery log gets pinned for hours. Tape reclamation tends to
perform
> poorly. The system administrator is now considering installing TDP for
> SQL Server. Would this software still send the backup as a single huge
> file?
|
|
|