Needed: Litespeed Syntax
-
LiteSpeed help doc isn't cryptic enough for me. I've got roughly 6-8 hours until a LiteSpeed backup ends before I have to run the verify statement. The backup to disk is to 4 files. I can't remember how to construct the syntax! Help please.
Q:\subdirectory1\File1.mdf
Q:\Subdirectory\File2.mdf etc.
EXEC
master.dbo.xp_restore_verifyonly
@filename
= ??
Thanks!
-
Hello Ariadne,
I hope this is help ful to u
restore database [Test1]
from DISK= N'D:\MSSQL\Test200603151229.BKP'
with FILE = 1, NOUNLOAD, STATS = 10, RECOVERY,
MOVE N'Test_Data' TO N'I:\Data\Test1_Data.mdf',
MOVE N'Test_Log' TO N'T:\Logs\Test1_Log.ldf'
-
Adriadne, you've got it right. The xp_restore_verifyonly sproc takes as many @filename parameters as you need, so you'd have something like this:
EXEC master.dbo.xp_restore_verifyonly
@filename = 'Q:\subdirectory1\File1.mdf',
@filename = 'Q:\Subdirectory1\File2.mdf',
@filename = 'Q:\Subdirectory1\File3.mdf'
-
Karen! Thank you!!!!
-
Ariadne,
Remember also, that if you automate your backups via the Litespeed Enterprise console, it can self verify without you having to "wait until it's done" and running that extended sproc.
-
I think "xp_restore_verifyonly" will work only in sql 2005 but not in sql 2008, it should be something different, right?
-
Tara,
I don't think Litespeed uses the SQL Server extended procs. I'm pretty sure they built their own.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply