Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ChaosCode
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 |
|
|
jackv
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--------------------http://www.sqlserver-dba.com |
 |
|
|
tkizer
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Question about restoring DB