Try this way:-

- stop log shipping

- took a new FULL backup of the primary database

- restore this to the 2ndary database (with standby option)

- delete ALL .trn file on...

@ sqldch

Generally, if you had selected the right backup, it

shouldnt get you both.

What sort of error you get when you try to restore the backup on other server.

You can...

@ richard

When I die please don't let my wife sell my hardware for the price I told her I paid for it!

Whats the meaning of this signature?? (out of curiosity)

Regards,

Sushant

@ gila

That means microsoft just repeats its questions??

They dont have different sets of questions.

Regards,

Sushant

@ steve

So, it means that microsoft has selected questions only for the certification.

Dont they change the questions or have different sets of questions..??

Regards,

Sushant

Pls check if the Sql service account in secondary server has sufficient permissions to the shared folder in which the log backup is being copied to inorder to perform restoration...check...

@ richard

After studying also, we need to see what kind of questions come in the exam

Where from can we see that??

Dumps are good for that..

Regards,

Sushant

@ gila

Where do you study from, for the MCITP exams..

Cant u study from dumps??

There should be some practice questions also...

Dumps serve good for this purpose.

Regards,

Sushant

what are the sizes of the bak and trn files of the backupset

Regards,

Sushant

oops

sorry for posting twice

i couldnt find the delete post option

is it there?

Regards,

Sushant

@ eric

Ya, true , you have to give them a login and permission too.

About the refresh page, there is a option in connection properties,

refresh after __ minutes and also

refresh data...

@ eric

Ya, true , you have to give them a login and permission too.

About the refresh page, there is a option in connection properties,

refresh after __ minutes and also

refresh data...

there is nothing like default

it remembers the last back up you did on that database whether it was a .bak or .trn

You can find out whcih is correct one by...

it should be bak not Bak

Go to excel --> data

data -->other sources

-->sql server

-->new connection

write t sql script there

execute, the excel would be filled with the result

of the t sql specified..

no use of dts...