Restore of any database backups using a script such as the example below is failing:
exec master.dbo.xp_restore_database
@database = N'ROBBIE'
, @filename= N'C:\Backup\Robbie.BAK'
, @encryptionkey = N'encryption-key'
, @filenumber = 1
, @Buffercount = 30
, @logging = 2
, @trace = 'logpath = C:\Temp\LitespeedLog'
, @with = N'NOUNLOAD'
, @with = N'STATS = 1'
, @with = N'REPLACE'
, @with = N'RECOVERY'
, @with = N'MOVE "ROBBIE" TO "W:\MSSQL\Robbie2.mdf"'
, @with = N'MOVE "Robbie_log" TO "W:\MSSQLLogs\Robbie_log.ldf"'
GO
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center