How Do I restore a SQL 2000 database without a UNC path?

HI everyone,

I'm the IT Director of a music company, and due to being left high and dry by our designers I now have the task to manage our database and asp site. None of this is in my skill set so I have a long learning curve to progress the project.

My dilema is: (If this may hasbeen coveredmy apologies, but I can't find a post on it)

I need to upload a database to my new SQL 2000 hosted DB. I use Tetratrax Database Manager for mylocal DBmanagement so I thought I would be able to use this for the web DB management. However, I forgot about the UNC path requirement. Any assistance in pointing me in the right direction is gratefully received.

And whether you celebrate Christmas or not , I wish you all an abundance of joy and good health throughout the holiday season and prosperity for the coming year.

Ian

 

Hi Ian,

Welcome to the <s>wonderful scary world of database management.

Unfortunately, In my experience, moving a database around can be one of the less pleasant things to do with your time.

I think the 'best' way to do it is to use SQL Enterprise Manager to do a full backup of the database and then take that backup and do a restore into the new database on the new server. More bad news is that DASP doesn't let you do this because it has security implications (you would be restoring user accounts, etc.)

I believe a close second in terms of ways to move a SQL 2000 database around is to use DTS (Database Transformation Services). You can create a DTS 'Package' which will do the import or export of data for you. When you create the package there is a 'Copy Database' task which lets you copy a database from one server to another. I think it does a pretty good job of copying all of the data, but you might have to move Stored Procedures, Views, Functions and Indexes on your own.

You might have some luck with this Google query:

www.google.com/search?q=DTS+%22Copy+database%22

I hope this helps you at least a bit. This is by no means the end-all answer to your problem and in general I think moving SQL databases around is a fairly difficult task, but you can do it if you stay positive and don't give up!

Good Luck!

Jeremy