Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Question about restoring DB

Author  Topic 

Starting Member

1 Post

Posted - 2014-07-07 : 17:40:19
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

Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-07-08 : 01:48:55
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

38200 Posts

Posted - 2014-07-08 : 13:16:16
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

- Advertisement -