In M$ SQL7, how do you complete the following:
RESTORE DATABASE MainBiz2
FROM DISK = 'd:\mssql7\backup\MainBiz\MainBiz_db_200301130102.BAK'
WITH RECOVERY,
MOVE 'MainBiz2.mdf' TO 'd:\mssql7\data\MainBiz2.mdf',
MOVE 'MainBiz2.ldf' TO 'd:\mssql7\data\MainBiz2.ldf'
where I want to "restore" a database with name MainBiz with a database
named MainBiz2
best, paul
At 04:54 PM 1/15/03 +0100, you wrote:
>I always use the command line for management. There might be some tools for
>visualization I use simultaneously, but in the end it will be some ALTER TABLE
>.... because that ends up in a log and can be reproduced easily, and often
>even
>be ran against a different RDBMS.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
