backup n restore commands using Redgate

• madhu-686862

  SSChampion

  Points: 10707

  More actions

  June 7, 2008 at 6:55 pm

  #208174

  hi,

  We are using redgate n litespeed tools for backup n restores.

  could you please give me the scripts used to do backups and restores in management studio using redgate? as well as litespeed.

  Thank You

  Madhu

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  June 9, 2008 at 4:31 pm

  #826389

  http://www.red-gate.com/help/sqlbackup/Topics/SBU_CommandRESTORE.html

  http://www.red-gate.com/help/sqlbackup/Topics/SBU_CommandBACKUP.html

  For LiteSpeed restores, you can execute something along the

  lines of:

  EXEC master.dbo.xp_restore_database @database='YourDBName',

  @filename = 'C:\PathTo\YourDBName_Backup.BAK',

  @WIth = 'Replace'

  There is also a GUI for LiteSpeed - try logging onto the

  server and looking in the program files for the LiteSpeed

  folder.

  For litespeed backup it uses a stored procedure named xp_backup_database(search out for its parameters

  on internet or just do a GUI backup and at the end step you can view the backup command using view tsql

  command option avaialble under backup GUI..Search for it)

  Hope this helps..

  Manu