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,



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Have you tried using some type of compression on the backup file? DB
backups usually compress as much as 70 or 80% of their original size. If
it's too big for PKZIP you can use SQL LiteSpeed to do the backup and
compression all in one and it will be faster than the plain backup. Here
are some links related to moving DB's in general:



http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server

http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues

--
Andrew J. Kelly SQL MVP


"TaeHo Yoo" <yootaeho (AT) yahoo (DOT) com> wrote