Hi, I've got this problem with your instructions for running the code and database, which one can download from your site.

It states that : "..The procedure for database backup is same for both MSDE and SQL server 2000..."

and then you guys state :

"..Restore the thephile-database-backup database file in SQL Server Enterprise Manager .."

But MSDE doesn't have a EM or even a QA for that sake. Its just a service running and yes, it does have a DTSRUN.EXE somewhere in the deep realms of the bin catlog of an extension i found, but i can't figure out how the bloody ¤¤¤¤, i should import the data...

I've already stripped google, but couldn't really find a useful tool.

Has: Frustration , Will exchange for: Link

Hi,

You can download trial version of Microsoft SQL Server 2000 from the following URL

http://www.microsoft.com/sql/evaluat...al/default.asp


Install it on client machine such as windows 2000 professional and setup will install only client tools, so you can use Enterprise manager for all management related issues.

You can also download this handy piece of software that provides some of the functions of SQL Enterprise Manager:

http://www.asql.biz/DbaMgr.shtm

Good luck.

Neither of these responses really answer the question they just say cant get MSDE to work download SQL Server 2000 trial or Use this manager. Has anyone actually gotten the backup into MSDE and if so HOW?

This might help:

http://www.microsoft.com/downloads/d...DisplayLang=en

You can't restore a database backup file into MSDE without using Enterprise Manager.

Like another poster said, you can get Enterprise Manager for free, and it will work with MSDE. The SQL Server 2000 trail download comes with the client tools, and that includes Enterprise Manager. These client tools don't expire.

The original code download for this book didn't require this database restore. They supplied a SQL script that could create all the objects. Yes, it's still in the code download, but it's obsolete now. They made some changes after the book was published, so the script doesn't have all the lastest stuff.

You need to restore the database backup file if you want it all.

Eric

You can restore the database with MSDE. I downloaded the MSDE setup file, and installed with the following command:
setup.exe /qb+ INSTANCENAME=DOTNET DISABLENETWORKPROTOCOLS=1 SECURITYMODE=SQL BLANKSAPWD=1
Then, to restore the database, I copied thephile-database-backup to c:\Phile.bak, and the used:
osql -S MACHINENAME\DOTNET -U sa -P (replace MACHINENAME with your own machine name). You then get a 1> prompt. Then:
1>RESTORE DATABASE THEPHILE FROM DISK='C:\PHILE.BAK' WITH RECOVERY
2>GO

Hope this helps.

That's cool. Thanks for the info!
I think this will help a lot of people.

Eric

Hi Hamilton,
I've tried to ur command and 'osql -S MYMACHINENAME\MSSQLSERVER -U sa -P' and I got
[DBMSLPCN]Invalid connection.
[DBMSLPCN]ConnectionOpen <ParseConnectParams<>>

hope you can advise me on this,
:)