SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Question about restoring DB
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 07/07/2014 :  17:40:19  Show Profile  Reply with Quote
First of all, hello to everyone.

Straight to the point:

I have some desktop app that is using sql 2000 which works just fine on this PC.

What I am trying to do is basically reverting it to db that has empty tables so that I can start using it from scratch (fill it with different data but still maintain the layout or what-have-you) on another, different PC.

I have found some bak file that says "clean_db" which is loaded just fine. (using the restore function)
The thing is, when I open my desktop app (add new user and everything) on this other PC now, it's entirely empty, I only see "File" and nothing else which was not my intention.

Could someone point me to the right direction as to what I am supposed to do ?
I am quite new to this and I'd appreciate some assistance.

Thank you

Flowing Fount of Yak Knowledge

United Kingdom
2032 Posts

Posted - 07/08/2014 :  01:48:55  Show Profile  Visit jackv's Homepage  Reply with Quote
If you have access to a SQL Server Client - attempt to connect to the SQL Server installed.Do you know the address of the SQL Server instance.
I assume you know the address as you restored the database.
Once you've connected - doublecheck the connection string of the application to the database server.

Jack Vamvas
Go to Top of Page

Almighty SQL Goddess

36834 Posts

Posted - 07/08/2014 :  13:16:16  Show Profile  Visit tkizer's Homepage  Reply with Quote
Did you unorphan the login and the user (sp_change_users_login)?

There's perhaps default data that still needs to be in the database. We can't help you with that as that requires application knowledge, but you can run a SQL Trace to see what it's doing and compare that with trace data for the database that is working.

Tara Kizer
SQL Server MVP since 2007
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000