 Re: Backup Question -
10-20-2003
, 02:10 AM
<<I understand that backup up to a device is done for backward compatibility, and backup to disk
would be the preferred method for Sql 2000.>>
That is not true. Why do you say that? I always use pre-defined backup devices just for the
advantage of them being listed in EM. EM does not have a GUI to read info from the backup history
tables (which would be required for a GUI to show stuff from directly addressed backup
destinations), nor have I seen any such GUI (although I've thought of writing one myself, but
time...).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"JLS" <jlshoop (AT) hotmail (DOT) com> wrote
I understand that backup up to a device is done for backward compatibility, and backup to disk would
be the preferred method for Sql 2000.
If I backup to a device, I can easily view what is on the backup device in EM. By clicking on the
Backup device in EM, I can see the full backup, followed by the log backups, therefore, easily
obtaining the file numbers I want for restoring the logs.
How can I see this information if the backup is to disk?
Thanx!
 |
Linear Mode
