Hi Del! Thank you VERY much! Kindest regards, Eric van Loon KLM Royal Dutch Airlines
-----Original Message----- From: Del Hoobler [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 14:34 To: [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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. **********************************************************************
