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
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: Tuesday, June 30, 2015 1:26 PM
Points: 367, Visits: 955
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.

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.


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

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