How to copy or restore an entire database(everything) from one server to another server no

I am in a situation where I have to copy an entire database(not only
data but alos storedprocedures etc like restoring a database) from one
server to another server from time to time. I could archive by
creating a backup file from one server, copy that to the another
server and then restore a database from the backup file. but the thing
is the backfile is too big to copy it over. Are there any scripts or
whatever I run to archive this?
Thank a lot in advance,See my reply in .DTS
--
Andrew J. Kelly SQL MVP
"Leon" <yootaeho@.yahoo.com> wrote in message
news:8a817d39.0409121712.7942afab@.posting.google.com...
> I am in a situation where I have to copy an entire database(not only
> data but alos storedprocedures etc like restoring a database) from one
> server to another server from time to time. I could archive by
> creating a backup file from one server, copy that to the another
> server and then restore a database from the backup file. but the thing
> is the backfile is too big to copy it over. Are there any scripts or
> whatever I run to archive this?
> Thank a lot in advance,|||"Leon" <yootaeho@.yahoo.com> wrote in message
news:8a817d39.0409121712.7942afab@.posting.google.com...
> I am in a situation where I have to copy an entire database(not only
> data but alos storedprocedures etc like restoring a database) from one
> server to another server from time to time. I could archive by
> creating a backup file from one server, copy that to the another
> server and then restore a database from the backup file. but the thing
> is the backfile is too big to copy it over. Are there any scripts or
> whatever I run to archive this?
Is Logshipping an option? That'll be smaller files usually.
> Thank a lot in advance,|||What about snapshot replication.
HTH
Saleem@.sqlnt.com
"Leon" wrote:
> I am in a situation where I have to copy an entire database(not only
> data but alos storedprocedures etc like restoring a database) from one
> server to another server from time to time. I could archive by
> creating a backup file from one server, copy that to the another
> server and then restore a database from the backup file. but the thing
> is the backfile is too big to copy it over. Are there any scripts or
> whatever I run to archive this?
> Thank a lot in advance,
>