Backup & restore of data Like organization chart in sqlserver
-
Hi dear friends I have a database (sql server) that every username should Enter some information in system & his (Admin,Admin User )then his (Admin) should give those Update Information to his (Users). Now, I have some Problems to solve this & need your help 1) This program offline & there are no network! 2) The (Users) shouldn’t have all database & they have just information about themselves This like organization chart that each user can just access to his information. I want to know, how can I do backup & restore this information? In which way? Do you Know any software that can Restore? Backup this information the best possible way? Image of this Message[]
-
Hi dear friends I have a database (sql server) that every username should Enter some information in system & his (Admin,Admin User )then his (Admin) should give those Update Information to his (Users). Now, I have some Problems to solve this & need your help 1) This program offline & there are no network! 2) The (Users) shouldn’t have all database & they have just information about themselves This like organization chart that each user can just access to his information. I want to know, how can I do backup & restore this information? In which way? Do you Know any software that can Restore? Backup this information the best possible way? Image of this Message[]
This is not a backup/restore issue. You need to do some research into replication and distributed database strategies. This is not a trivial subject.
Never underestimate the power of human stupidity RAH
