August 24, 2012 at 12:21 am
hi,
Can anyone please suggest how to check and find whether my SQL Server is using litespeed software as the mode of backup?
Note: I do not have the litespeed databases hosted there to find quickly.
Thanks.
August 24, 2012 at 9:01 pm
If your backup script is using the native "Backup Database" then it's not... Litespeed backup scripts are different something like "Litespeed.exe -d..." something like that... it's been 6 months since I've seen it so I can't be sure but it uses it's own extended procedures for backups so it can multi-thread.
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
August 25, 2012 at 10:03 am
chang.hahn (8/24/2012)
If your backup script is using the native "Backup Database" then it's not... Litespeed backup scripts are different something like "Litespeed.exe -d..." something like that... it's been 6 months since I've seen it so I can't be sure but it uses it's own extended procedures for backups so it can multi-thread.
Not necessarily - you can install Litespeed in a mode that replaces the native commands. If Litespeed is installed in this configuration, all native backup commands would still be using the Litespeed engine.
Assuming this is not the case, you can look in the master database for the Litespeed extended procedures. If they exist - then you know that Litespeed is installed.
Then, start looking through all of the backup jobs and see if they are using those extended procedures. However, it is possible that the backups were implemented using the Litespeed console as Litespeed maintenance plans.
If that is the case, look for any agent jobs that execute the Litespeed maintenance plans.
Even that won't tell you whether or not all databases are actually backed up using Litespeed. The best way to determine if a backup came from Litespeed or not is to use the xp_restore_filelistonly Litespeed extended procedure to read the backup file. This procedure reads both native and Litespeed backup files and will tell you whether or not the backup file was created using native SQL or Litespeed.
I believe there may also be a command line utility that can be used - check the Litespeed command line help.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply