Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 xp_restore_database

Author  Topic 

carumuga
Posting Yak Master

174 Posts

Posted - 2009-08-05 : 03:13:04
Hi,

can someone please explain me the commands used in this query. It would be great if you could send some useful links on them.

xp_restore_database @database = 'xxx',
@filename = 'filename1.bkp', @filename = 'filename2.bkp', @filenumber = '1', @with = 'RECOVERY', @with = 'REPLACE', @with = 'NOUNLOAD', @with = 'stats = 10', @with = 'move N''xxx'' TO N ''xxx.mdf'''
@logging = 2, @affinity = 0

Thanks in advance.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-05 : 04:10:14
It is a SQL LiteSpeed procedure.
I suggest you look over at http://www.quest.com/litespeed-for-sql-server/


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

- Advertisement -