> Really? I've always been under the impression that that was
> not possible. I'd be very interested in knowing how you've
> done that as that is one of my biggest fears for my SQL box.
>
> Would you be willing to share that config?
Sure, there's nothing to it. I'll assume that you know how to backup to
file.
>From Enterprise Manager:
1. Right-click on the "Databases" folder, and select "All Tasks", followed
by "Restore".
2. Select the "From device" option, specify the file location, and click
"OK".
3. Then - and this is the trick - select the "Options" tab.
4. Under the "Move to physical file name" section, change the file path to
match the server on which you're restoring, rather than the one used to
create the backup.
That's all there is!
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
