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 mime. Show all posts
Showing posts with label mime. Show all posts
Tuesday, March 20, 2012
Wednesday, March 7, 2012
Backup on Network Drive
This is a multi-part message in MIME format.
--=_NextPart_000_004E_01C3ECC2.CF1CAF40
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
We want to take back up of databases on network drives. How should we do = this ?
- Ketan
--=_NextPart_000_004E_01C3ECC2.CF1CAF40
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,
We want to take back up = of databases on network drives. How should we do this ?
- Ketan
--=_NextPart_000_004E_01C3ECC2.CF1CAF40--It is not generally recommended to backup directly to network drives. You
might be better off backup up to a local array, & then copying the file
across the network. There is a discussion on this here:
http://www.sql-server-performance.com/backup_restore_tuning.asp
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Use an UNC path in the destination file name. Make sure that the SQL Server service account has
appropriate permissions on that share.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Ketan Patel" <ketanforever@.indiatimes.com> wrote in message
news:ua9$kQJ7DHA.2392@.TK2MSFTNGP11.phx.gbl...
Hi,
We want to take back up of databases on network drives. How should we do this ?
- Ketan|||Thanks for your reply.
I have verified the service account. It was System account. I have changed
this to other having appropriate access to network drives and this works.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OqqmdWJ7DHA.3360@.tk2msftngp13.phx.gbl...
> Use an UNC path in the destination file name. Make sure that the SQL
Server service account has
> appropriate permissions on that share.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Ketan Patel" <ketanforever@.indiatimes.com> wrote in message
> news:ua9$kQJ7DHA.2392@.TK2MSFTNGP11.phx.gbl...
> Hi,
> We want to take back up of databases on network drives. How should we do
this ?
> - Ketan
>
>
>
>|||I will vouch for that from experience.
:-)
Greg Jackson
PDX, Oregon
--=_NextPart_000_004E_01C3ECC2.CF1CAF40
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
We want to take back up of databases on network drives. How should we do = this ?
- Ketan
--=_NextPart_000_004E_01C3ECC2.CF1CAF40
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,
We want to take back up = of databases on network drives. How should we do this ?
- Ketan
--=_NextPart_000_004E_01C3ECC2.CF1CAF40--It is not generally recommended to backup directly to network drives. You
might be better off backup up to a local array, & then copying the file
across the network. There is a discussion on this here:
http://www.sql-server-performance.com/backup_restore_tuning.asp
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Use an UNC path in the destination file name. Make sure that the SQL Server service account has
appropriate permissions on that share.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Ketan Patel" <ketanforever@.indiatimes.com> wrote in message
news:ua9$kQJ7DHA.2392@.TK2MSFTNGP11.phx.gbl...
Hi,
We want to take back up of databases on network drives. How should we do this ?
- Ketan|||Thanks for your reply.
I have verified the service account. It was System account. I have changed
this to other having appropriate access to network drives and this works.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OqqmdWJ7DHA.3360@.tk2msftngp13.phx.gbl...
> Use an UNC path in the destination file name. Make sure that the SQL
Server service account has
> appropriate permissions on that share.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Ketan Patel" <ketanforever@.indiatimes.com> wrote in message
> news:ua9$kQJ7DHA.2392@.TK2MSFTNGP11.phx.gbl...
> Hi,
> We want to take back up of databases on network drives. How should we do
this ?
> - Ketan
>
>
>
>|||I will vouch for that from experience.
:-)
Greg Jackson
PDX, Oregon
Subscribe to:
Posts (Atom)