We can install SQL server but the problem is the configuration can be
different from the original. we looking forward if the base backup/archive
client and OFM can deliver the full image backup of SQL server (including
based applications and physical database files). So, incase of corruptions,
we can able to restore completely, then, restore using TDP of SQL the latest
backup of database/transaction logs.

is it possible? thanks....


-----Original Message-----
From: Del Hoobler [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 5:45 PM
To: [EMAIL PROTECTED]
Subject: Re: Open file for TSM


> Hi Andy,
>
> How about the SQL data files? There are open files when the SQL service
is
> started and the ADSM/TSM unable to backup the said files. How do you
recover
> if the SQL server crashed without installing the application and creating
> the databases?  Is this TDP for SQL Server can do the recover without
> installing the based application?

Zosimo,

TDP for SQL protects the database files and their transaction logs only.
It does not protect the SQL Server application files.
The base backup/archive client can be used to protect those files.
In the event of a disaster, where the SQL Server application is
corrupted, you can re-install SQL Server, and then restore your
databases via TDP for SQL.

Thanks,

Del

----------------------------------------------------

Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

"Celebrate we will. Life is short but sweet for certain..."  -- Dave

Reply via email to