recreate system tables

Hi!
I need to recreate the system tables (sysobjects, syscolumns,
sysindexes, sysforeignkeys, sysconstraints, sysreferences, sysindexkeys
at least) in another SQL server.
You may say "Thats easy! Backup and restore the database!" and I would
answer "I can't, the database size is above 50GB and I just can't do it
every time I need to recreate the info".
So, ¿Do you know any simple way to do these?

I don't need the data on the user tables and I'll log-in always as dbo
(using trusted connection), perhaps that helps.
Perhaps the simplest way is to do a bcp to backup and restore the data
but.... you never know what would happen. This is why I write ask you
guy, probably you know much more than me.

Thanks in advance

.

Relevant Pages

  • Re: How to repair a corrupt sysindexes
    ... You'll need to restore your database from a backup - repair cannot fix ... > The sysindexes table in one of the user databases is corrupt. ...
    (microsoft.public.sqlserver.server)
  • Accidently deleted user
    ... I accidently deleted two users from a SQL Server database (from the ... I tried to recreate the user in the database but I get an error that the ... How can I use a backup to restore the permissions? ...
    (microsoft.public.sqlserver.server)
  • Re: Accidently deleted user
    ... Have you tried use sp_change_users_login in the database where the users ... > database, not from the server). ... > I tried to recreate the user in the database but I get an error that the ... How can I use a backup to restore the permissions? ...
    (microsoft.public.sqlserver.server)
  • Re: Restoring MSDE database
    ... make a copy of your old content database ... recreate one - will generate a new one with a new name ... backup will crash the sharepoint site. ... I must make sure my new WSS site content database name ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: 9i rman question
    ... BACKUP ARCHIVELOG ALL; ... Recreate the controlfile? ... database would surely do it; ...
    (comp.databases.oracle.server)