|
|
Posted by javelin on 01/29/07 19:10
There are two requirements here, the first being the need to restore
tables to a different server than the backup originated from without
messing up mapping of server logins. The second is the need for a user
to work remotely on one single table without implementing fancy
database features, such as replication. Why not? Because the DBA is a
real "P.I.T.A.", and there's no way to convince him he's wrong! I did
discover one script to "generate INSERT statements from the existing
data" (found here: http://vyaskn.tripod.com/code.htm#inserts).
However, this one doesn't work well with tables with many columns, and
my table is definitely a "many-columned" table. If someone has
experience with fixing this script to be more flexible and suit my
needs, I could use it to have the remote user modify records in the
table and have the insert scripts generated from this code.
Thanks again for further advice.
On Jan 28, 4:34 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> javelin (google.1.jvm...@spamgourmet.com) writes:
> > I'm having difficulty searching for an answer to this challenge. Can
> > someone give me a clue on the right keywords to use to find a
> > discussion on this subject? All of the ones I saw appear to touch on
> > older versions. I'm working with SQL Server 2000, and need to backup
> > and restore only tables, because the full backup/restore appears to
> > mess up users/security, or something or another.You cannot backup and restore individual tables. SQL 6.5 had such a
> feature, but thankfully this folly was dropped.
>
> You can however backup and restore single filegroups.
>
> But it is not likely to be the solution to your problem. BACKUP/RESTORE
> as such does not mess up users, but if you restore a backup on a different
> server, you lose the mapping between database users and server logins.
> Obviously - the logins in two servers are likely to be different.
>
> As Greg said, user sp_change_users_login to sort out the situation.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|