Imperial, Robert wrote: > Scrambling here trying to restore a db on a ms sql server and cannot > connect with Enterprise Manager (another story). Is there a command line > utility out there anywhere that will let me restore a db from a .bak > file on a windows box? Or is there a way to do this from a CF query? TIA
<cfquery ...> RESTORE DATABASE [database_name] FROM DISK = N'path_to_full_backup_file' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10 </cfquery> Make sure you connect to a database that is not the one you are trying to restore. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308547 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
