|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.
This is definitely not the case. You can backup up and restore to different
servers.
|can you provide more information about "sp_attach_db"? i've never heard
|of that...
This is a stored procedure and can be found in BOL. An example is listed
below
with Listing 1 performing the detach and Listing 2 attaching. This is also
used to
move databse locations on the local file system.
Listing 1:
EXEC sp_detach_db MyDatabase,true
Listing 2:
EXEC sp_attach_db
@dbname = 'MyDatabase', @filename1 = 'h:\sqldata\MyDatabase_data.mdf',
@filename2 = 'h:\sqldata\MyDatabase_log.ldf'
------------------------------------------
Dan O'Keefe
TriPoint Technologies
[EMAIL PROTECTED]
954.675.3115
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
