Suggestion: for errors like these always use stored procedure restore_filelistonly from disk = 'C:\Test.bak' this will show you how the backup set looks like.

Also use the option "WITH MOVE"...

Try using SQL Litespeed 2005 its a thrid party backup software recommended by microsoft I have used while working in Microsoft.

The compression is awesome almost 80% reduction in the...

hi,

I ran a query into sys.database_files for both the databases and LSNs match but still I didnt restore. I think that is because the recovery plans are different in...

Hi,

Thanks for your response. Yes at one point in time the copies were identical. On the primary server I added few rows to a table on secondary file group,...

you can create any stored procedure

and use sqlcmd which a command line utility use robocopy or move any of O/S commands. It would work

Create procedure movefile

as

(

exec xp_cmdshell or...

Thank you so much. I had the same issue and resolved it by dis-abling the execution account.

Hi,

Does this option work with SQL Lite Speed 2005?

I had one suggestion in case of a failure: we can set this as a sql job in step1 with mirroring...