I've currently written an application using IBS Portal and pointing to the Portal database. I would like to write another application that is not related. I've copied all my programs from PortalVBVS to another folder and pointed IIS to that folder. I've also changed the web.config file to the name of the new database.

My problem is in copying the portal database to a database with a different name. I am getting login problems and I've also noticed that if I update data on the new application, it still updates tables on the portal database. Is there a best way to go about copying the portal database and pointing the application to it? I feel that I'm close, but it has been driving me crazy-

How are you copying and restoring your DB?

Are you using enterprise manager to do this?

If so, are you making sure to change where you write the mdf and ldf to?

---

Brian

Unfortunately, I don't have access to Enterprise Manager. I was simply shutting down SQL and doing a manual copy of the database file and log and then renaming it. Something tells me I can't do it that way.

go to microsoft and download the SQL 2000 eval version and install the client tools. They do not expire like the actual server does. This will help you in the process and you will not have to deal with osql.

---

Brian

Thanks. That's a good idea. Does it matter that I have MS SQL 7 instead of 2000?