December 6, 2011 at 9:27 am
Can some one point to me some sample scripts to backup and restore using Litespeed (without going through the console).
December 6, 2011 at 9:41 am
What do you mean without going through the console? Do you mean not logging on to the actual server? Or without using SSMS?
You can't run a command without a connection to the remote server. Either you have a remote process execution shell, like PSEXEC, that connects to the remote server and runs the commands, or you use some other shell command, like accessing through T-SQL with SQLCMD, SSMS, or some other program.
The command line arguments for litespeed are on the Quest site or included in your documentation for the tool.
December 6, 2011 at 10:11 am
I mean not connecting to the litespeed console. We have about 65 databases that we need to setup the backup/restore jobs. Is there a way I can run some sort of litespeed script to restore the databases from litespeed backups?
If we have to go through the litespeed console, it will take a while to restore all these databases.
December 6, 2011 at 10:46 am
Litespeed has commands from T-SQL or from a command prompt.
You can script something there, and it would be similar to a script that restores multiple normal SQL backups from multiple files. Look for those scripts in our script section.
December 6, 2011 at 11:06 am
Refer to the Litespeed help for other options:
-- Sample Litespeed Database Restore Command
exec master.dbo.xp_restore_database
@database = 'MyDBName'
, @filename = '\\MyServer\MyShare\MyDirectory\MyDBName_db_201111060700.BAK'
, @with = 'stats = 5'
, @with = 'NORECOVERY'
, @with = 'move "MyDBName_Data"to "D:\MSSQL\Data\MyDBName_Data.mdf"'
, @with = 'move "MyDBName_Log"to "E:\MSSQL\Data\MyDBName_Log.ldf"'
December 7, 2011 at 4:58 am
if you're unsure then open the Litespeed console and step through the backup or restore process for your chosen database. At the end of the wizard, before executing, there is an option to script for command line or extended SP use. You may then use this as a template for further actions too 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply