SQL Server 2000 Restore Backup problem?

[Nasir Iqbal]

I am getting problme when i try to restore a previous database backup on newly installed sql server 2000, i.e thier is no Database ohter then default databases.

[horsenbuggy]

I'm not sure what you're asking. You have a new installation of SQL 2000. Naturally, none of your older databases exist on this installation. If you have a copy of the .bak file for the database you want to restore, you should be able to restore it to this new installation. You can either create an empty database with the right db name in the new installation and restore to it. Or you can do the restore action with the wizard in Enterprise Manager and give it the right db name in one of the last steps without creating the new db first. If you are saying that you don't have a copy of the .bak file, and you don't still have the db online on a different server... you're up the creek. Do you have backup tapes with a copy of the .bak file anywhere?

[damstr8]

Hey, just bringing this old question up for a vote. If you have not found the answer you are looking for, please, feel free to use one of the following links from my personal collection:http://www.dogpile.comhttp://www.ito...d.net/free-ed/ http://www.hplearningcenter.com http://www.petfinder.com/http://www....glyrics.com/My post is simply to encourage you to pick a "Best Answer" or to assist you in finding the answer. Thank you!