Is it possible as an example assuming hardware is identical and the only
thing running is Full backups that one database of say 100 GB runs for an
hour whereas another database could run for 3 hours.
Is the backups dependent upon maybe the type of data in the database ?Interesting question..
The backup should simply read the mdb files, and copy it to tape. Then it
will read the log and backup any changes made since the full backup
began...Backup ONLY backs up real data however, and not the empty space in
the files. Just because the physcial file is 100 GB, doesn't mean there is
100 GB of data... Compare the backup file sizes... One could be backing up
lots of data, and the other only a small amount... even if both contained
only 10 GB of data in the 100GB file... The data in one database could be
compressed near the front of the file ( causing minimum disk io) while the
other dB could have it's 10 GB of data spread evenly across the entire 100
GB physical file ( causing 10X more IO.)
hope this helps..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u71QVDCNFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Is it possible as an example assuming hardware is identical and the only
> thing running is Full backups that one database of say 100 GB runs for an
> hour whereas another database could run for 3 hours.
> Is the backups dependent upon maybe the type of data in the database ?
>
Showing posts with label identical. Show all posts
Showing posts with label identical. Show all posts
Tuesday, March 20, 2012
Monday, March 19, 2012
backup question
Is it possible as an example assuming hardware is identical and the only
thing running is Full backups that one database of say 100 GB runs for an
hour whereas another database could run for 3 hours.
Is the backups dependent upon maybe the type of data in the database ?Interesting question..
The backup should simply read the mdb files, and copy it to tape. Then it
will read the log and backup any changes made since the full backup
began...Backup ONLY backs up real data however, and not the empty space in
the files. Just because the physcial file is 100 GB, doesn't mean there is
100 GB of data... Compare the backup file sizes... One could be backing up
lots of data, and the other only a small amount... even if both contained
only 10 GB of data in the 100GB file... The data in one database could be
compressed near the front of the file ( causing minimum disk io) while the
other dB could have it's 10 GB of data spread evenly across the entire 100
GB physical file ( causing 10X more IO.)
hope this helps..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u71QVDCNFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Is it possible as an example assuming hardware is identical and the only
> thing running is Full backups that one database of say 100 GB runs for an
> hour whereas another database could run for 3 hours.
> Is the backups dependent upon maybe the type of data in the database ?
>
thing running is Full backups that one database of say 100 GB runs for an
hour whereas another database could run for 3 hours.
Is the backups dependent upon maybe the type of data in the database ?Interesting question..
The backup should simply read the mdb files, and copy it to tape. Then it
will read the log and backup any changes made since the full backup
began...Backup ONLY backs up real data however, and not the empty space in
the files. Just because the physcial file is 100 GB, doesn't mean there is
100 GB of data... Compare the backup file sizes... One could be backing up
lots of data, and the other only a small amount... even if both contained
only 10 GB of data in the 100GB file... The data in one database could be
compressed near the front of the file ( causing minimum disk io) while the
other dB could have it's 10 GB of data spread evenly across the entire 100
GB physical file ( causing 10X more IO.)
hope this helps..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u71QVDCNFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Is it possible as an example assuming hardware is identical and the only
> thing running is Full backups that one database of say 100 GB runs for an
> hour whereas another database could run for 3 hours.
> Is the backups dependent upon maybe the type of data in the database ?
>
backup question
Is it possible as an example assuming hardware is identical and the only
thing running is Full backups that one database of say 100 GB runs for an
hour whereas another database could run for 3 hours.
Is the backups dependent upon maybe the type of data in the database ?
Interesting question..
The backup should simply read the mdb files, and copy it to tape. Then it
will read the log and backup any changes made since the full backup
began...Backup ONLY backs up real data however, and not the empty space in
the files. Just because the physcial file is 100 GB, doesn't mean there is
100 GB of data... Compare the backup file sizes... One could be backing up
lots of data, and the other only a small amount... even if both contained
only 10 GB of data in the 100GB file... The data in one database could be
compressed near the front of the file ( causing minimum disk io) while the
other dB could have it's 10 GB of data spread evenly across the entire 100
GB physical file ( causing 10X more IO.)
hope this helps..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u71QVDCNFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Is it possible as an example assuming hardware is identical and the only
> thing running is Full backups that one database of say 100 GB runs for an
> hour whereas another database could run for 3 hours.
> Is the backups dependent upon maybe the type of data in the database ?
>
thing running is Full backups that one database of say 100 GB runs for an
hour whereas another database could run for 3 hours.
Is the backups dependent upon maybe the type of data in the database ?
Interesting question..
The backup should simply read the mdb files, and copy it to tape. Then it
will read the log and backup any changes made since the full backup
began...Backup ONLY backs up real data however, and not the empty space in
the files. Just because the physcial file is 100 GB, doesn't mean there is
100 GB of data... Compare the backup file sizes... One could be backing up
lots of data, and the other only a small amount... even if both contained
only 10 GB of data in the 100GB file... The data in one database could be
compressed near the front of the file ( causing minimum disk io) while the
other dB could have it's 10 GB of data spread evenly across the entire 100
GB physical file ( causing 10X more IO.)
hope this helps..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u71QVDCNFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Is it possible as an example assuming hardware is identical and the only
> thing running is Full backups that one database of say 100 GB runs for an
> hour whereas another database could run for 3 hours.
> Is the backups dependent upon maybe the type of data in the database ?
>
Wednesday, March 7, 2012
Backup one server, restore to another
I frequently restore the backups of my production server to my standby/test
server. They (the servers) aren't completely identical, however. Production
has 3 logical disks for OS, data and logs while standby has only two disks.
The real problem though is the time it takes to do a restore using EM. It
seems that I have to restore the full backup then each transaction log
separately. It would be very convenient to be able to specify (using add
device) the full backup and all of the logs I want at once, then only have
to change the paths to the database and log files one time. I've read
through BOL but it is silent on this issue. Is it possible through EM? Or
should I be looking at a third-party app from e.g. Red Gate?You could write a SQL script that implements the WITH MOVE option of the
backup command. Enterprise Manager is a nice tool, but I haven't figured
out how to automate a series of mouse clicks. For repeatability, you have
to go to T_SQL scripts.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ron Hinds" <__ron__dontspamme@.wedontlikespam_garageiq.com> wrote in message
news:e3vH%23OT0GHA.4648@.TK2MSFTNGP04.phx.gbl...
>I frequently restore the backups of my production server to my standby/test
> server. They (the servers) aren't completely identical, however.
> Production
> has 3 logical disks for OS, data and logs while standby has only two
> disks.
> The real problem though is the time it takes to do a restore using EM. It
> seems that I have to restore the full backup then each transaction log
> separately. It would be very convenient to be able to specify (using add
> device) the full backup and all of the logs I want at once, then only have
> to change the paths to the database and log files one time. I've read
> through BOL but it is silent on this issue. Is it possible through EM? Or
> should I be looking at a third-party app from e.g. Red Gate?
>
server. They (the servers) aren't completely identical, however. Production
has 3 logical disks for OS, data and logs while standby has only two disks.
The real problem though is the time it takes to do a restore using EM. It
seems that I have to restore the full backup then each transaction log
separately. It would be very convenient to be able to specify (using add
device) the full backup and all of the logs I want at once, then only have
to change the paths to the database and log files one time. I've read
through BOL but it is silent on this issue. Is it possible through EM? Or
should I be looking at a third-party app from e.g. Red Gate?You could write a SQL script that implements the WITH MOVE option of the
backup command. Enterprise Manager is a nice tool, but I haven't figured
out how to automate a series of mouse clicks. For repeatability, you have
to go to T_SQL scripts.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ron Hinds" <__ron__dontspamme@.wedontlikespam_garageiq.com> wrote in message
news:e3vH%23OT0GHA.4648@.TK2MSFTNGP04.phx.gbl...
>I frequently restore the backups of my production server to my standby/test
> server. They (the servers) aren't completely identical, however.
> Production
> has 3 logical disks for OS, data and logs while standby has only two
> disks.
> The real problem though is the time it takes to do a restore using EM. It
> seems that I have to restore the full backup then each transaction log
> separately. It would be very convenient to be able to specify (using add
> device) the full backup and all of the logs I want at once, then only have
> to change the paths to the database and log files one time. I've read
> through BOL but it is silent on this issue. Is it possible through EM? Or
> should I be looking at a third-party app from e.g. Red Gate?
>
Backup one server, restore to another
I frequently restore the backups of my production server to my standby/test
server. They (the servers) aren't completely identical, however. Production
has 3 logical disks for OS, data and logs while standby has only two disks.
The real problem though is the time it takes to do a restore using EM. It
seems that I have to restore the full backup then each transaction log
separately. It would be very convenient to be able to specify (using add
device) the full backup and all of the logs I want at once, then only have
to change the paths to the database and log files one time. I've read
through BOL but it is silent on this issue. Is it possible through EM? Or
should I be looking at a third-party app from e.g. Red Gate?You could write a SQL script that implements the WITH MOVE option of the
backup command. Enterprise Manager is a nice tool, but I haven't figured
out how to automate a series of mouse clicks. For repeatability, you have
to go to T_SQL scripts.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ron Hinds" < __ron__dontspamme@.wedontlikespam_garagei
q.com> wrote in message
news:e3vH%23OT0GHA.4648@.TK2MSFTNGP04.phx.gbl...
>I frequently restore the backups of my production server to my standby/test
> server. They (the servers) aren't completely identical, however.
> Production
> has 3 logical disks for OS, data and logs while standby has only two
> disks.
> The real problem though is the time it takes to do a restore using EM. It
> seems that I have to restore the full backup then each transaction log
> separately. It would be very convenient to be able to specify (using add
> device) the full backup and all of the logs I want at once, then only have
> to change the paths to the database and log files one time. I've read
> through BOL but it is silent on this issue. Is it possible through EM? Or
> should I be looking at a third-party app from e.g. Red Gate?
>
server. They (the servers) aren't completely identical, however. Production
has 3 logical disks for OS, data and logs while standby has only two disks.
The real problem though is the time it takes to do a restore using EM. It
seems that I have to restore the full backup then each transaction log
separately. It would be very convenient to be able to specify (using add
device) the full backup and all of the logs I want at once, then only have
to change the paths to the database and log files one time. I've read
through BOL but it is silent on this issue. Is it possible through EM? Or
should I be looking at a third-party app from e.g. Red Gate?You could write a SQL script that implements the WITH MOVE option of the
backup command. Enterprise Manager is a nice tool, but I haven't figured
out how to automate a series of mouse clicks. For repeatability, you have
to go to T_SQL scripts.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ron Hinds" < __ron__dontspamme@.wedontlikespam_garagei
q.com> wrote in message
news:e3vH%23OT0GHA.4648@.TK2MSFTNGP04.phx.gbl...
>I frequently restore the backups of my production server to my standby/test
> server. They (the servers) aren't completely identical, however.
> Production
> has 3 logical disks for OS, data and logs while standby has only two
> disks.
> The real problem though is the time it takes to do a restore using EM. It
> seems that I have to restore the full backup then each transaction log
> separately. It would be very convenient to be able to specify (using add
> device) the full backup and all of the logs I want at once, then only have
> to change the paths to the database and log files one time. I've read
> through BOL but it is silent on this issue. Is it possible through EM? Or
> should I be looking at a third-party app from e.g. Red Gate?
>
Friday, February 10, 2012
Backup Guidelines for Recovery
Thomas,
the pages on MSDN are more or less identical to BOL
(http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/replsql/replbackup_8enn.asp).
Perhaps you have some specific questions regarding
transactional backups?
Regards,
Paul Ibison
No. thanks
On Wed, 28 Jul 2004 06:21:17 -0700, "Paul Ibison"
<Paul.Ibison@.Pygmalion.Com> wrote:
>Thomas,
>the pages on MSDN are more or less identical to BOL
>(http://msdn.microsoft.com/library/default.asp?
>url=/library/en-us/replsql/replbackup_8enn.asp).
>Perhaps you have some specific questions regarding
>transactional backups?
>Regards,
>Paul Ibison
the pages on MSDN are more or less identical to BOL
(http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/replsql/replbackup_8enn.asp).
Perhaps you have some specific questions regarding
transactional backups?
Regards,
Paul Ibison
No. thanks
On Wed, 28 Jul 2004 06:21:17 -0700, "Paul Ibison"
<Paul.Ibison@.Pygmalion.Com> wrote:
>Thomas,
>the pages on MSDN are more or less identical to BOL
>(http://msdn.microsoft.com/library/default.asp?
>url=/library/en-us/replsql/replbackup_8enn.asp).
>Perhaps you have some specific questions regarding
>transactional backups?
>Regards,
>Paul Ibison
Subscribe to:
Posts (Atom)