Error says that the secondary database is skipping the transaction logs as it already applied them.

You should check the copy, restore and alert timings of the database..maybe they are not...

@chrisph

I had the same problem few days back...

When I created one mainteneance clean task and pointed to that folder contaning sub folders(wid .bak file) then, the job ran...

@Bhuvnesh

It was newly built server...so didn't check it earlier..

@sumit

I got through now...restored successfully after the 2 changes as mentioned above..

@ above all.....

I made 2 changes

1) in server properties-->connections-->remote query timeout changed from 600--> 0

2) started the sql server browser (sql server configuration manager--> services)(it was off earlier)

Now the...

@ Ray mond...

Is the 410 GB drive connected to the server that you are trying to restore the database on? If so, why would SQL Server raise a TCP...

the database mail profile can be made

the receipients of that profile can be made by adding the accounts

there u can mention the address receving hte mails..

the restore script also failed with the same error.. 🙁

I restored another database from the same prod server to dev server which went smoothly, but that one was just 1GB....This...

u can restore on that database itself with choosing hte option overwrite the existing database.

the .bak file is generally compressed one,

the original size of database is the .mdf size..

so the .bak file size would be 5 gb

but the .mdf file would be 15...

plz reconfigure log shipping

@ jeffrey...

But my database restores starts from 10%, 20% , 30% ...then it stops in between....

it is not that it doesnt start...but after sometime it throws error.

The article explains...

@ all

I got a new drive 410 gb on my server, Now when i copied the .bak file locally, and then trying to restore it, then also I am...

@ oomboom

how long does the command run before it gives error?

how are you sharing the file? Normal windows share?

The restoring starts with 10%,20%.....around 50-60% it throws the error

as...

add a identity column..

its a self increment column

ALTER TABLE XYZ

ADD id_num int IDENTITY(1,1)

@ ray mond..

ya u r right, thtsy i wanted to restore it over hte network as i didnt had enough space.

...

I dont know if its advisable to do as...