Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sqlsafe restore Expand / Collapse
Author
Message
Posted Thursday, March 13, 2014 4:49 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 16, 2014 12:56 PM
Points: 332, Visits: 868
I need to restore lastest full backup and latest differential backup file using xp_ss_restore

I am using this command. But I'm getting follwoing error. Can you please help?


xp_ss_restore did not complete. An error(0,1) was encountered. Please check the parameters and their values. [v4.6.0.0]

SQLsafeCmd output:
------------------
SQLsafe Enterprise-scale Backup and Recovery CLI Version 4.6.312.4023
Copyright (c) 2004-2007 BBS Technologies, Inc., All Rights Reserved.
<http://www.idera.com/>

1 is an invalid parameter for Restore.

--- End of SQLsafeCmd output ---
Msg 50000, Level 16, State 1, Line 14
One or more operations failed to complete.


DECLARE @ResultCode INT

EXEC @ResultCode = [master].[dbo].[xp_ss_restore]
@database = 'NewDB',
@filename = '\\Server\Z$\afull_201403091027.safe',
@withmove = '"NewDB_Data" "F:\SQLData\NewDB_New_Data.MDF"',
@withmove = '"NewDB_Log" "G:\SQLData\NewDB_New_log.LDF"',
@disconnectusers = '1',
@server = 'MyServer'
@Recoverymode='StandBy'


IF(@ResultCode != 0)
RAISERROR('One or more operations failed to complete.', 16, 1);

Post #1550962
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse