> > 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.
You can do this in SQL 7; there's an Options tab when you restore that will
allow you to change the restore path. We use this quite often to copy
databases from active development servers.
> > 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...
It's a system stored procedure which instantly creates a new database using
the files you specify as parameters. It's very easy to use this, if you have
the original database files, to make them into an active database. I have
run into one catch with this: the original database will contain the
original rights information, so if you created a specific user and gave that
user rights within the original database, it'll list that user when you
attach it - even if that user hasn't been defined within that server!
This stored procedure can be called through the command-line SQL interface,
making it ideal for install scripts.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
