george sibbald (8/14/2010)

---

shrinkfile with notruncate will have no effect on a log file.

I can only presume one log restore is using the log shipping jobs, one isn't?

the version of SQL...

george sibbald (8/13/2010)

---

do not run any log backups outside of the jobs created by the logshipping wizard to do so. Only those log backups will be copied and restored,. Other...

george sibbald (8/13/2010)

---

control the log file growth by taking log backups more frequently. Avoid shrinking the log file.

If you shrink files on a database acting as primary in logshipping ...

desmith 68071 (8/12/2010)

---

The more important question here is why would you try to shrink the log? 60mb is extremely small for a 100gb database (unless you meant 60GB log). Shrinking...

Hi,

I am just playing with log shipping now a days.

so just find some where in that case you have to re do log shipping work.

Thanks

Rajat

Hi

Thanks for reply.

can you please help with any solid way by which i don't need to do whole backup and everything go smoothly.

I am just guessing if its possible...

Hi,

Sorry that "no recovery " was typo mistake.

Thanks for your response.

it means i have to take again 110 GB's Database from secondary database and restore on primary database for further...

I have also implemented Log shipping according to your document on 110 GB database. Now i am worried when primary server fail we will restore Secondary server with “no recovery...

Hi Roy,

Thanks for response.

Yes job is running but that is only log shipping related nothing else.

but sometime transaction log size is very high in that case.

any specific reason for that?

thanks

Rajat

Hi,

I think you should go with profile.

Just create a new profile provide require credential.

Hope it will work smoothly for you.

Thanks

Raj

Hi ,

can you send your current db structure ?

Thanks

Raj

Hi,

Please checkout my post

http://indiandotnet.wordpress.com/2009/05/23/sql-server-performance-improvement/

Hope it will help you out some way.

Thanks

Raj

Hey ,

That's great !

Thanks a lot to for appriciation.

😎

Hi,

try this

DELETE px

FROM #prodextend px

INNER JOIN #product p ON p.din = px.din

...