Hi Ivar, if you use SAP DB's backup/restore you have to backup and especially restore complete databases. Maybe the SAP DB Loader is the tool you are looking for. You can extract and load single tables from the database.
Best Regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Ivar [mailto:[EMAIL PROTECTED]] Sent: Freitag, 31. Januar 2003 11:53 To: [EMAIL PROTECTED] Subject: Re: Sap Db running as service What about bakcup ? Can i backup/restore only one user namespace or must retore/backup all ? "Elias Martenson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Ivar wrote: > > Hi, > > > > Each SAP Db is running as service, is it ood idea ? > > Eg. for large number of databases it's problematic (Messes up win service > > list and hard to manage). > > > > Many DataBase servers conatains over 100 small databases. > > You really shouldn't do that. You'r emuch better off rethinking your > configuration. The manual explictily recommends against putting more > than one database on one server. > > I had a similar problem to you when I migrated from a PostgreSQL setup > where I had a lot of databases to SAP DB. With SAP DB I made what had > originally been a database into a user instead. Each user has its own > default name space and because of this, their tables won't collide. > > Hope this helps _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
