SLS File But No xp_restore_database?

• bjr149

  Valued Member

  Points: 53

  More actions

  January 6, 2011 at 9:41 am

  #232983

  I was provided a .SLS file to restore my database from. That is fine but everywhere I look it is telling me to use the stored procedure master.dbo.xp_restore_database. The problem is if I look in the list of stored procedures I don't see it in the list? I have 2005 Express SQL Server installed.

• homebrew01

  SSC Guru

  Points: 55553

  More actions

  January 6, 2011 at 1:08 pm

  #1270305

  A quick search suggests that xp_restore_database is a Litespeed procedure. Do you have Litespeed installed on the server you're working with ?

  Some 3rd party tools let you restore to an unlicensed server (good) ... some don't (bad), but you'd need to invoke it from the licensed server.

  Could you give more details ?