so, how to make that queue available...

Hello experts,

i went through the reports tab of service broker under that report in queue pane the status of my queue is showing inactive..

i don't know whether this might be...

Service broker is enabled, Trustworthy = on, owners of the databases is correct only

and there are no records found in sys.transmission_queue

query of queue is :

Create queue dbo.[xxx] with status =...

hi,

the results of the queue is am attaching the screenshot.

the wait_type and last_wait_type are BROKER_RECEIVE_WAITFOR

Experts, please advise me on this issue...

yes u need to copy all the .trn files which were not copied to secondary server.

It might be network problem or some other reasons,

as u said there was only 450 tran. logs in secondary. so just sort all the .trn files in modified date wise...

Apart from this there is another alternative, i.e., from GUI.

Right click on database-->click on Reports-->click on standard Reports-->Click on Disk usage by Tables.

It will generate a report and gives the...

check with LSN number, what was the last copied LSN in secondary server, after that u need to copy all the log backups from primary and copy those in secondary...

Please can anyone give some valuable inputs to sort out this issue...

manually copy the .trn files into secondary(stand by) server which are not copied in stand by server and run the restore job.

Every time will u take backup through query?

u can create a maintenance plan for backup and select the retention period u required?

If u wants to maintain for last two days...

Hi Ninja..

Thanks for giving valuable suggestion...

🙂

I dont know whether job is saved or not?

but in the Agent properties history has been set to 10000 rows and for each job 1000 rows.

this job runs more than...