Wondering if SQL 2000 offers any compression of logical backups vs. no software compression in SQL 7.5. I've been asked to evaluate a 3rd party tool that compresses SQL 7.5 backups nicely, but this tool does not allow concatenating all databases into a single logical device file. I'm thinking I won't recommend the tool if SQL 2000 does compression on the fly as we will be upgrading sometime over the next handful of months.
TIAwhat tool are you referring to? sqllitespeed? and why would you need to append to the device? so that when you really need it you can't find it or it became corrupt and you consequently cannot recover anything?
sql2k does not compress, but m$ adopted sqllitespeed just for that purpose, as well as because it offers encryption (something that everybody is concerned about nowadays)
Showing posts with label logical. Show all posts
Showing posts with label logical. Show all posts
Tuesday, March 20, 2012
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)