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!
Showing posts with label d84dc670. Show all posts
Showing posts with label d84dc670. Show all posts
Tuesday, March 20, 2012
Subscribe to:
Posts (Atom)