ADSM-L

SQL Database backup

2004-08-25 07:45:29
Subject: SQL Database backup
From: "Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 25 Aug 2004 13:05:41 +0200
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!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


**********************************************************************
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.
**********************************************************************

<Prev in Thread] Current Thread [Next in Thread>