Wrox Programmer Forums
|
BOOK: ASP.NET Website Programming Problem-Design-Solution
This is the forum to discuss the Wrox book ASP.NET Website Programming: Problem - Design - Solution, Visual Basic .NET Edition by Marco Bellinaso, Kevin Hoffman; ISBN: 9780764543869
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET Website Programming Problem-Design-Solution section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 22nd, 2004, 08:04 AM
Registered User
 
Join Date: Jul 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Installing thePhile Database help

When i try and restore thePhile DB in my SQL Server 2000 db I recieve the following error:

---------------------------
Microsoft SQL-DMO (ODBC SQLState: 42000)
---------------------------
Device activation error. The physical file name 'C:\Wrox\thephile_data.mdf' may be incorrect.
File 'ThePhile_Data' cannot be restored to 'C:\Wrox\thephile_data.mdf'. Use WITH MOVE to identify a valid location for the file.
Device activation error. The physical file name 'C:\Wrox\thephile_log.ldf' may be incorrect.
File 'ThePhile_Log' cannot be restored to 'C:\Wrox\thephile_log.ldf'. Use WITH MOVE to identify a valid location for the file.
RESTORE DATABASE is terminating abnormally.
---------------------------
OK
---------------------------

My SQL Server is not installed on c:\ but on my logical p:\. I have followed the instructions but i don't know why this error is occuring. Please help asap if anyone can.

Thanks
Garry

 
Old July 22nd, 2004, 09:09 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Why not try "with move" as it suggests?

restore database ThePhile
from disk = 'c:\thephile-database-backup'
with move 'ThePhile_Data' to 'p:\DB\thephile_data.mdf',
move 'ThePhile_Log' to 'p:\DB\thephile_log.ldf'

http://www.experts-exchange.com/Data..._20942138.html

Eric
 
Old January 11th, 2006, 12:19 PM
Registered User
 
Join Date: Jan 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Did this work?






Similar Threads
Thread Thread Starter Forum Replies Last Post
restore thePhile database with 2005 SQL Server ecarnews BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 4 July 2nd, 2007 12:58 PM
Installing a access database program in VBA MDrumm Access 4 August 22nd, 2005 02:48 AM
Need Help( installing the database) Frank1111 BOOK: ASP.NET Website Programming Problem-Design-Solution 2 March 23rd, 2004 04:50 AM
keep getting an error with ThePhile ar3ol BOOK: ASP.NET Website Programming Problem-Design-Solution 15 February 4th, 2004 01:19 PM
ThePhile: Restoring Database mbschmitt BOOK: ASP.NET Website Programming Problem-Design-Solution 2 July 29th, 2003 07:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.