![]() ![]() Or, I could take a minute to teach you how to do it for yourself. I have lost count of the number of vendors I have sent the extracted files to and received an email back that either says “we don’t know what to do with these files” or “can you send us just one file instead?” And while the extraction utility makes it easy to provide the necessary files, you have no idea who is on the receiving end of the multiple files. One common reason for needing to have a native backup is for those rare times when you need to provide a vendor with a copy and that same vendor does not have a copy of Litespeed. OK, so what do you do with these files? Well, you restore them, of course, using either T-SQL or SSMS. You can configure a path and filename here if you want to have the files stored somewhere other than the current directory. This command results in the creation of multiple files. So, if you had a backup of AdventureWorks saved to C:\AdWks.bak, and you wanted to extract the native dump from that file and create new files in the same directory, you would run the following command:Įxtractor.exe -F c:\AdWks.bak -E c:\AdWks_ext.bak The command is roughly as follows:Įxtractor.exe -F -E In fact you will have one file created for each thread that was used when Litespeed was taking the initial database backup. Next, issue the following command to extract the native backup file. Yes, files. First step is to open a command window and navigate to the directory where the utility is located, this is typically the C:\Program Files\Quest Software\LiteSpeed\SQL Server directory. If your database is of a considerable size then the time needed to accomplish that task could be prohibitive it will always be simpler to do the extraction as opposed to a restore and a backup.Įxtraction is very straightforward. Otherwise, you would be forced to do a restore followed by a native backup. Fortunately Quest provides an extractor utility in order to help with the process. You can now access the backed-up databases at any time.More than once I have had the need to recover the native backup file from within the compressed Litespeed backup file.
0 Comments
Leave a Reply. |