> You can back it up to file on the source
> machine, then send that file off to the target machine, where the
> administrator of that machine could then restore it from the
> file.
i have not had any luck using this method. it was really simple on SQL6,
however SQL7 seems to require that the backup file being restored must
have come from the same machine it's being restored to. i've even tried
to create a temp backup file, replace it with a new backup file that
includes the new data, and then try to restore that but somehow SQL7
knows that it's different and won't use it.
> In this vein, you could send the actual database files
> themselves - without
> even doing a backup - and they could be attached on the
> target server using
> sp_attach_db (which I believe is new to SQL Server 7).
can you provide more information about "sp_attach_db"? i've never heard
of that...
thanx!
mike
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
