Re: Database copy

Marcos (marcos_rodas@xxxxxxxxxxx) writes:
I guess is the BACKUP the one bringing the users with the database. Is
there a way to run a BACKUP without the users? I know I should be able
to remove the users once I restore the database, but I just like to see
if I can take care of the users before the RESTORE.

No, neither BACKUP nor RESTOARE are selective on that level. (You can
backup/restore a filegroup only, but that is not going to help you
here.)



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Backing Up WSS
    ... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: stsadm.exe
    ... Yes, Stsadm will create the site for you on restore, and it will maintain all permissions. ... Stsadm only backups up data that is stored in the database, so any changes you make to the IIS server's file system you'll have to back up via some other method. ... only backup. ... For example, your production environment is IIS/WSS on one server, SQL Server on another. ...
    (microsoft.public.sharepoint.windowsservices)
  • Backing Up WSS
    ... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
    (microsoft.public.sharepoint.portalserver)
  • Backing Up WSS
    ... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Backups Best Practices
    ... I use SQLLiteSpeed to backup to a UNC share on a remote file server. ... The UNC host is also the tape host so tape backups and restores happen ... I don't bother with index rebuilds after a restore unless the backup was ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)