On 04/18/2014 09:08 PM, Saravanan wrote: > While querying backups(active, inactive) during restore in version TDP SQL > 6.4, its taking much time, some time more than 5 hours. Is there any > parameters can set in .cfg or .opt file to get faster response? Like TOC in > NAS
You didn't provide any detail about your environment. In earlier versions of the TDP for SQL, at least, the SQL Server had to restore the backup metadata objects to query backups because it didn't keep local or centralized copies of that data the way Oracle does (with control files or a RMAN catalog database). So best practice is to keep all TDP SQL metadata backups on fast-access storage pools (DISK, FILE or VTL) so there is no appreciable delay (from tape mounts or seeks) in restoring the metadata objects. The TDP for SQL documentation describes this and gives examples of how to configure include statements to direct the metadata backups to a suitable storage pool (which you have to set up first). Hope this is useful. If you're already configured this way, please provide us more detail about your environment for us to offer further advice. =Dave -- Hello World. David Bronder - Systems Architect Segmentation Fault ITS-EI, Univ. of Iowa Core dumped, disk trashed, quota filled, soda warm. [email protected]
