This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C394D0.D84DC670
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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!
--=_NextPart_000_0008_01C394D0.D84DC670
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
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!
--=_NextPart_000_0008_01C394D0.D84DC670--<<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@.hotmail.com> wrote in message news:%23uuq0HPlDHA.2232@.TK2MSFTNGP09.phx.gbl...
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!|||Also, you can always use RESTORE HEADERONLY and FILELISTONLY from query analyzer, of course.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"JLS" <jlshoop@.hotmail.com> wrote in message news:%23uuq0HPlDHA.2232@.TK2MSFTNGP09.phx.gbl...
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!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment