Hi Del!
Thank you VERY much!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
-----Original Message-----
From: Del Hoobler [mailto:hoobler AT US.IBM DOT COM]
Sent: Wednesday, August 25, 2004 14:34
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SQL Database backup
Eric,
Deleted databases do not "automatically" get inactivated.
You must manually inactivate them.
>>From the command-line interface, use the TDPSQLC INACTIVATE command.
It is very similar to the RESTORE command.
Enter TDPSQLC HELP INACTIVATE to see the exact syntax.
>>From the GUI, go to "View", "Inactivate Tab", and you will see
a new tab show up which allows you to choose the database
backups that you would like to inactivate.
Thanks,
Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 08/25/2004
07:05:41 AM:
> Hi *SM-ers!
> DP for SQL Server 5.2.1 on a SQL Server 7.0 SP3.
> When a user removes a database on a SQL Server, what happens to the
backups
> for that database?
> Yesterday, the user told me that a database was removed from one of his
> nodes. I did a select * from backups for that node and I noticed that
there
> were still active backups listed for the specific database, while a
backup
> was done last night.
> Is there anything special a user has to do to mark these backups
inactive?
> Thank you very much for your reply in advance!
**********************************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential and
privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment may be
disclosed, copied or distributed, and that any other action related to this
e-mail or attachment is strictly prohibited, and may be unlawful. If you have
received this e-mail by error, please notify the sender immediately by return
e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM),
its subsidiaries and/or its employees shall not be liable for the incorrect or
incomplete transmission of this e-mail or any attachments, nor responsible for
any delay in receipt.
**********************************************************************
|