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 example. Show all posts
Showing posts with label example. 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 ?
>
Thursday, March 8, 2012
backup over ip and compress with rar
Hi,
Does somebody knows the syntax to backup a scheduled db to another server
over ip. After that compress the database with winrar for example?
Is this possible or should it be done in another way.
Please let me know.
JYou may want to use SQL LiteSpeed instead: www.imceda.com.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Jason" <jasonlewis@.hotrmail.com> wrote in message
news:uL1R6KCFFHA.2052@.TK2MSFTNGP09.phx.gbl...
Hi,
Does somebody knows the syntax to backup a scheduled db to another server
over ip. After that compress the database with winrar for example?
Is this possible or should it be done in another way.
Please let me know.
J
Does somebody knows the syntax to backup a scheduled db to another server
over ip. After that compress the database with winrar for example?
Is this possible or should it be done in another way.
Please let me know.
JYou may want to use SQL LiteSpeed instead: www.imceda.com.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Jason" <jasonlewis@.hotrmail.com> wrote in message
news:uL1R6KCFFHA.2052@.TK2MSFTNGP09.phx.gbl...
Hi,
Does somebody knows the syntax to backup a scheduled db to another server
over ip. After that compress the database with winrar for example?
Is this possible or should it be done in another way.
Please let me know.
J
Sunday, February 12, 2012
Backup information
Hi,
I need to get information from a backup file. For example the logical name
of database file (data/log) that exist in the backup set.
I know that RESTORE FILELISTONLY and RESTORE HEADERONLY provide this
information, but I need to get them in variables, or something that makes me
able to use these information in my dynamic tsql string.
Thanks in advance,
Leila
Kimberly Tripp has a real cool script that automatically backups
a 2000 database and restores to 2005. It uses a temporary table
#BackupFileList to hold the filelist info.
INSERT #BackupFileList
EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
then she works through the temporary table using a cursor.
http://www.sqlskills.com/blogs/kimbe...3-10b2d34981bb
Karl Tarbet
MCSD .net
|||And some potentially useful code here as well:
http://www.karaszi.com/SQLServer/uti...ll_in_file.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Karl" <ktarbet@.[xx-no-spam-xx]gmail.com> wrote in message
news:CAD48B53-94CC-413F-B1CF-B9DC9547E470@.microsoft.com...
> Kimberly Tripp has a real cool script that automatically backups
> a 2000 database and restores to 2005. It uses a temporary table
> #BackupFileList to hold the filelist info.
> --
> INSERT #BackupFileList
> EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
> --
> then she works through the temporary table using a cursor.
> http://www.sqlskills.com/blogs/kimbe...3-10b2d34981bb
> --
> Karl Tarbet
> MCSD .net
>
I need to get information from a backup file. For example the logical name
of database file (data/log) that exist in the backup set.
I know that RESTORE FILELISTONLY and RESTORE HEADERONLY provide this
information, but I need to get them in variables, or something that makes me
able to use these information in my dynamic tsql string.
Thanks in advance,
Leila
Kimberly Tripp has a real cool script that automatically backups
a 2000 database and restores to 2005. It uses a temporary table
#BackupFileList to hold the filelist info.
INSERT #BackupFileList
EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
then she works through the temporary table using a cursor.
http://www.sqlskills.com/blogs/kimbe...3-10b2d34981bb
Karl Tarbet
MCSD .net
|||And some potentially useful code here as well:
http://www.karaszi.com/SQLServer/uti...ll_in_file.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Karl" <ktarbet@.[xx-no-spam-xx]gmail.com> wrote in message
news:CAD48B53-94CC-413F-B1CF-B9DC9547E470@.microsoft.com...
> Kimberly Tripp has a real cool script that automatically backups
> a 2000 database and restores to 2005. It uses a temporary table
> #BackupFileList to hold the filelist info.
> --
> INSERT #BackupFileList
> EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
> --
> then she works through the temporary table using a cursor.
> http://www.sqlskills.com/blogs/kimbe...3-10b2d34981bb
> --
> Karl Tarbet
> MCSD .net
>
Backup information
Hi,
I need to get information from a backup file. For example the logical name
of database file (data/log) that exist in the backup set.
I know that RESTORE FILELISTONLY and RESTORE HEADERONLY provide this
information, but I need to get them in variables, or something that makes me
able to use these information in my dynamic tsql string.
Thanks in advance,
LeilaKimberly Tripp has a real cool script that automatically backups
a 2000 database and restores to 2005. It uses a temporary table
#BackupFileList to hold the filelist info.
--
INSERT #BackupFileList
EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
--
then she works through the temporary table using a cursor.
3-10b2d34981bb" target="_blank">http://www.sqlskills.com/blogs/kimb...
3-10b2d34981bb
--
Karl Tarbet
MCSD .net|||And some potentially useful code here as well:
http://www.karaszi.com/SQLServer/ut...all_in_file.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Karl" <ktarbet@.[xx-no-spam-xx]gmail.com> wrote in message
news:CAD48B53-94CC-413F-B1CF-B9DC9547E470@.microsoft.com...
> Kimberly Tripp has a real cool script that automatically backups
> a 2000 database and restores to 2005. It uses a temporary table
> #BackupFileList to hold the filelist info.
> --
> INSERT #BackupFileList
> EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
> --
> then she works through the temporary table using a cursor.
> f33-10b2d34981bb" target="_blank">http://www.sqlskills.com/blogs/kimb...33-10b2d34981bb
> --
> Karl Tarbet
> MCSD .net
>
I need to get information from a backup file. For example the logical name
of database file (data/log) that exist in the backup set.
I know that RESTORE FILELISTONLY and RESTORE HEADERONLY provide this
information, but I need to get them in variables, or something that makes me
able to use these information in my dynamic tsql string.
Thanks in advance,
LeilaKimberly Tripp has a real cool script that automatically backups
a 2000 database and restores to 2005. It uses a temporary table
#BackupFileList to hold the filelist info.
--
INSERT #BackupFileList
EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
--
then she works through the temporary table using a cursor.
3-10b2d34981bb" target="_blank">http://www.sqlskills.com/blogs/kimb...
3-10b2d34981bb
--
Karl Tarbet
MCSD .net|||And some potentially useful code here as well:
http://www.karaszi.com/SQLServer/ut...all_in_file.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Karl" <ktarbet@.[xx-no-spam-xx]gmail.com> wrote in message
news:CAD48B53-94CC-413F-B1CF-B9DC9547E470@.microsoft.com...
> Kimberly Tripp has a real cool script that automatically backups
> a 2000 database and restores to 2005. It uses a temporary table
> #BackupFileList to hold the filelist info.
> --
> INSERT #BackupFileList
> EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
> --
> then she works through the temporary table using a cursor.
> f33-10b2d34981bb" target="_blank">http://www.sqlskills.com/blogs/kimb...33-10b2d34981bb
> --
> Karl Tarbet
> MCSD .net
>
Backup information
Hi,
I need to get information from a backup file. For example the logical name
of database file (data/log) that exist in the backup set.
I know that RESTORE FILELISTONLY and RESTORE HEADERONLY provide this
information, but I need to get them in variables, or something that makes me
able to use these information in my dynamic tsql string.
Thanks in advance,
LeilaKimberly Tripp has a real cool script that automatically backups
a 2000 database and restores to 2005. It uses a temporary table
#BackupFileList to hold the filelist info.
--
INSERT #BackupFileList
EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
--
then she works through the temporary table using a cursor.
http://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=edcbec05-a111-49c6-af33-10b2d34981bb
--
Karl Tarbet
MCSD .net|||And some potentially useful code here as well:
http://www.karaszi.com/SQLServer/util_restore_all_in_file.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Karl" <ktarbet@.[xx-no-spam-xx]gmail.com> wrote in message
news:CAD48B53-94CC-413F-B1CF-B9DC9547E470@.microsoft.com...
> Kimberly Tripp has a real cool script that automatically backups
> a 2000 database and restores to 2005. It uses a temporary table
> #BackupFileList to hold the filelist info.
> --
> INSERT #BackupFileList
> EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
> --
> then she works through the temporary table using a cursor.
> http://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=edcbec05-a111-49c6-af33-10b2d34981bb
> --
> Karl Tarbet
> MCSD .net
>
I need to get information from a backup file. For example the logical name
of database file (data/log) that exist in the backup set.
I know that RESTORE FILELISTONLY and RESTORE HEADERONLY provide this
information, but I need to get them in variables, or something that makes me
able to use these information in my dynamic tsql string.
Thanks in advance,
LeilaKimberly Tripp has a real cool script that automatically backups
a 2000 database and restores to 2005. It uses a temporary table
#BackupFileList to hold the filelist info.
--
INSERT #BackupFileList
EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
--
then she works through the temporary table using a cursor.
http://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=edcbec05-a111-49c6-af33-10b2d34981bb
--
Karl Tarbet
MCSD .net|||And some potentially useful code here as well:
http://www.karaszi.com/SQLServer/util_restore_all_in_file.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Karl" <ktarbet@.[xx-no-spam-xx]gmail.com> wrote in message
news:CAD48B53-94CC-413F-B1CF-B9DC9547E470@.microsoft.com...
> Kimberly Tripp has a real cool script that automatically backups
> a 2000 database and restores to 2005. It uses a temporary table
> #BackupFileList to hold the filelist info.
> --
> INSERT #BackupFileList
> EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
> --
> then she works through the temporary table using a cursor.
> http://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=edcbec05-a111-49c6-af33-10b2d34981bb
> --
> Karl Tarbet
> MCSD .net
>
Backup information
Hi,
I need to get information from a backup file. For example the logical name
of database file (data/log) that exist in the backup set.
I know that RESTORE FILELISTONLY and RESTORE HEADERONLY provide this
information, but I need to get them in variables, or something that makes me
able to use these information in my dynamic tsql string.
Thanks in advance,
LeilaKimberly Tripp has a real
script that automatically backups
a 2000 database and restores to 2005. It uses a temporary table
#BackupFileList to hold the filelist info.
--
INSERT #BackupFileList
EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
--
then she works through the temporary table using a cursor.
http://www.sqlskills.com/blogs/kimb...
3-10b2d34981bb
--
Karl Tarbet
MCSD .net|||And some potentially useful code here as well:
http://www.karaszi.com/SQLServer/ut...all_in_file.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Karl" <ktarbet@.[xx-no-spam-xx]gmail.com> wrote in message
news:CAD48B53-94CC-413F-B1CF-B9DC9547E470@.microsoft.com...
> Kimberly Tripp has a real script that automatically backups
> a 2000 database and restores to 2005. It uses a temporary table
> #BackupFileList to hold the filelist info.
> --
> INSERT #BackupFileList
> EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
> --
> then she works through the temporary table using a cursor.
> http://www.sqlskills.com/blogs/kimb...33-10b2d34981bb
> --
> Karl Tarbet
> MCSD .net
>
I need to get information from a backup file. For example the logical name
of database file (data/log) that exist in the backup set.
I know that RESTORE FILELISTONLY and RESTORE HEADERONLY provide this
information, but I need to get them in variables, or something that makes me
able to use these information in my dynamic tsql string.
Thanks in advance,
LeilaKimberly Tripp has a real
script that automatically backupsa 2000 database and restores to 2005. It uses a temporary table
#BackupFileList to hold the filelist info.
--
INSERT #BackupFileList
EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
--
then she works through the temporary table using a cursor.
http://www.sqlskills.com/blogs/kimb...
3-10b2d34981bb
--
Karl Tarbet
MCSD .net|||And some potentially useful code here as well:
http://www.karaszi.com/SQLServer/ut...all_in_file.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Karl" <ktarbet@.[xx-no-spam-xx]gmail.com> wrote in message
news:CAD48B53-94CC-413F-B1CF-B9DC9547E470@.microsoft.com...
> Kimberly Tripp has a real
script that automatically backups> a 2000 database and restores to 2005. It uses a temporary table
> #BackupFileList to hold the filelist info.
> --
> INSERT #BackupFileList
> EXEC('LOAD FILELISTONLY FROM DISK = ''c:\temp\$(DB).bak''')
> --
> then she works through the temporary table using a cursor.
> http://www.sqlskills.com/blogs/kimb...33-10b2d34981bb
> --
> Karl Tarbet
> MCSD .net
>
Subscribe to:
Posts (Atom)