There is an easy of doing this, you can run this executable to script out database objects.

mssql/upgrade/

scptxfr.exe

Closing this thread. Thanks for all the help.

My goal is to perform partial database recovery.

To restore stored procedure(s) or function(s) or view(s) or revert to old table structures without having to restore whole database to acheive...

log shipping and replication are going to two different databases

FTP sends files in clear plain-text exposing them to the plethora of bad guys out there who have nothing better to do than violate the privacy of others, pilfer confidential...

i didn't phrase the question properly.

Let me put this way.

I want log shipping and replication both from primary production database. One for standby(DR) and one for replication(read only db)

Primary Database(proddb)...

i am suprised that no one responded to my query, wondering how people do replication over internet using secure FTP? there should be way doing it

can someone direct me...