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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 backup

Author  Topic 

rjrferreira
Starting Member

13 Posts

Posted - 2007-05-08 : 10:00:33
I all,

I have been made a backup file from a database. That database are in the principal server. This DB as a user as named DBBOOKS.

Now, i restore the database in my computer, to keep it local. When i restore the DB the user names DBBOOKS stays at DB, but he don't exists in the new instance, so i can't remove/alter him, because he don't have any Login attributed.

So, what i want is, there is anyway to backup a DB without the users? Only tables and info tables?

Greetings,
Rodrigo

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-05-08 : 10:03:57
Duplicate: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83246

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -