Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shanilash
Starting Member
17 Posts |
 Posted - 2009-05-19 : 08:47:51
|
| In my environment logshipping process is there.For this we created backup job from primary server (LON549)and restore job in secondary server(BCPDBS01). every 15 minutes differential backup will happen and restore it in secondary server....today the job is getting failed...error details is as follows[Executed as user: CMCK\SQLBCPDBS01. Cannot apply the backup on device '\\Bcpdbs01\g$\Backups\LON549\MH\Diff\MH_DiffBackup_20090519_084500.BAK' to database 'MH'. [SQLSTATE 42000] (Error 3136) RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.]Please help me on this its urgent |
|
|
chudman2
Starting Member
5 Posts |
Posted - 2009-05-19 : 21:52:30
|
| You are probably out of space on your secondary server on the database drive, or the file was corrupt. If it was corrupt, restore a differential but leave the database in recovery, and it should resume.Jeff Bennett |
 |
|
|
uberman
Posting Yak Master
159 Posts |
Posted - 2009-05-20 : 04:25:29
|
| or as this is a diff, has a full backup been taken on the primary server and this isnt on the secondary server? |
|
|
|
|
|
|
Logshipping